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
-
Create a new tile in Tile Builder of Performance Management
-
In Chart Data tab you select "Overall Performance Rating" for Category and "Document ID" for Metric
-
Go to Preview
-
The charts are not displaying null values
- Click "Select All" on the top right
- In the drill down there are rows with null values
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.
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