2484215 - Dashboard chart does not display all data / null values

SAP Knowledge Base Article - Public

2484215 - Dashboard chart does not display all data / null values

Symptom

  • Dashboard Charts do not display all values, however 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. See that the charts are displaying only two values
  5. dash.pngdash2.png
  6. Click on "Select All" on the top right
  7. See that in the drill down there are more than two rows
  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

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