How to Hide Duplicates in Story
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 HXM Suite
- People Analytics
- Story Reports
We call a row a duplicate only if all the values are same in more than one row.
Getting duplicate rows in a list report is very common. This could be expected if we query a database table that holds the same values for a user up to certain fields (say Set A) and different values in remaining fields (say Set B). Now, if we just add fields from set A in a report, it will output the same values for a user in multiple rows.
In Stories, we can easily hide the duplicate rows by using Aggregated List Type
See more details on Our portal: People Analytics – What it offers distinctively?
SAC, People, Analytics, Story, Reports, Hide, Duplicates, Enable, Distinct , KBA , LOD-SF-ANA-SAC-SDS , Story Designer - Story & Formatting , How To