3716673 - Data Discrepancy in Totals between Different Chart Types that use same Data Source - Story Reporting

• Data discrepancy issue observed in Story Report between e.g. Numeric Point Chart and Bar Chart, while using the same data source.
• Same fields and Filters are applied to the different chart types
• The total shown in the Numeric Point Chart is different from the totals of the Chart values (when manually summed)
  
  

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

SAP SuccessFactors HCM Suite

1. Navigate to Report Centre
2. Edit Story report
3. Copy the e.g. Numeric Point widget.
4. Paste it to the same Story Canvas page.
5. Adjust the chart type from Numeric Point to Bar/Column.  Select a Dimension for this new chart type
6. Observe that the number of totals displayed is not consistent between the two charts.

Insufficient Dimension Context for the Calculation.

1. Add the Dimension used in the bar charts as Dimension Context for the Calculated Dimension. e.g. Select Business Unit from the list if the bar chart uses Business Unit as Dimension.
2. Ensure that the dimension context of the calculated measure aligns with the bar chart's configuration to achieve consistency in the total values displayed across different chart types.
   
   

data discrepancy, story report, inconsistent values, same data source, numeric point, bar chart, dimension context, calculation, hours worked, SAP SuccessFactors Platform , KBA , LOD-SF-ANA-SAC-SDS , Story Designer - Story & Formatting , Problem