3041807 - How to Hide Duplicates in Story in Classic Design Experience (CDE)

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 HCM 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