SAP Knowledge Base Article - Public

2484215 - Dashboard does not display null values

Symptom

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

Environment

SuccessFactors Workforce Analytics (ANA) - All versions

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
  5. dash.pngdash2.png
  6. Click on "Select All" on the top right
  7. In the drill down there are rows with null values
  8. 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 on 'Selec 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.

dash4.png

dash5.png

Keywords

Dashboard Charts do not display all values Select All data null value , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , LOD-SF-ANA-DSH , Dashboard and YouCalc , How To

Product

SAP SuccessFactors Workforce Analytics all versions