SAP Knowledge Base Article - Public

2356342 - Drill down for custom tile in Dashboard 2.0 showing more records than the number appearing on hovering

Symptom

  • Customer is seeing the difference in the number when hovering over the custom tile created through tile builder and the actual data coming while drill down in Dashboard 2.0
  • More data is coming in the export file creating during drill down than the number appearing on hovering over the same tile bar

Environment

  • SAP SuccessFactors HCM Core
  • Dashboards
  • Youcalc

Reproducing the Issue

  1. Hover over a section of the tile and note the number.
  2. Drill down that section and export the data. Note the number of records coming in the export file.
  3. You will see that both the numbers are different.

1.PNG

Cause

This is not an issue but an expected behavior which occur due to the tile configuration.

  1. Go to Admin Center -> Manage Dashboard ->  Manage Standard Dashboards and YouCalc Files
  2. Edit the Custom Tile
  3. Go to Chart Data tab
  4. Check the value selected under Field Calculation. Is it COUNT(DISTINCT)?
  5. COUNT (DISTINCT) will calculate the unique records of the column selected under Metric but whole data will be available in drill down.

In Below Example : COUNT (DISTINCT) will calculate the unique Subject User ID and display that number on hover. Here are 107 unique Subject User ID who have their form in Modify Stage but in drill down there might be more than one record present for one Subject User ID which is the reason of more data coming through drill down.

2.PNG

 

Resolution

In order to get the same value on hover and drill down, change the Calculation type from COUNT(DISTINCT) to COUNT.

Keywords

Data difference in Dashboard 2.0 Hover Drill Down COUNT(Distinct) Custom Tile Tile Builder , KBA , LOD-SF-ANA-DSH , Dashboard and YouCalc , How To

Product

SAP SuccessFactors HCM Core 1608 ; SAP SuccessFactors HCM Core 1611