SAP Knowledge Base Article - Public

2821697 - Dashboard does not display null values

Symptom

Dashboard does not display null values, but if you click "Select All" you can see all the data

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP SuccessFactors HCM Suite
    • Dashboards and Tiles

Reproducing the Issue

  1. Create a new tile in Tile Builder of Performance Management
  2. In Chart Data tab you select "Overall Performance Rating" for Category and "Document ID" for Metric
  3. Go to Preview
  4. The charts are not displaying null values

    1_dash.png1_dash2.png

  5. Click "Select All" on the top right
  6. In the drill down there are rows with null values

    1_dash3.png

 

Cause

The Tile Builder cannot count null values from the Category, therefore the charts will only display the data with values.
However if you click 'Select All' it will display all results (even the nulls) in the Drill Down.

Resolution

This is expected behavior. If you do not want to display the rows with null values in the Drill down you can apply a filter "Is not null" for the columns with null values.

1_dash4.png

1_dash5.png

Keywords

Dashboard, Charts, do, not, display, all, values, Select, All, data, null, value, missing, hidden, sync, issue , KBA , LOD-SF-ANA-DSH , YouCalc Dashboards and Tiles (Dashboards 2.0) , Problem

Product

SAP SuccessFactors HCM suite all versions