Title: How to remove duplicate rows in HR Service assignment report?

[ghitabahaj]

Hello everyone,

I am currently building a report on the HR Service Assignment Group (database view) to identify which assignment group is managing each HR service.

However, I am seeing what appear to be duplicate rows in the report. After reviewing the data, it seems that the duplicates are caused by multiple assignment rules pointing to the same group for a single HR service.

My goal is to display each HR service only once per assignment group for better readability.

Has anyone faced a similar situation?
What would be the best approach to avoid showing these duplicates in the report?

Any recommendations or best practices would be greatly appreciated.

Thank you!

[pratikjagtap]

Hi @ghitabahaj ,

Group By in Report

If you’re using a Platform Report:

Configure:

• Group by = HR Service
• Then group by = Assignment Group
  
  

Enable:
✔️ Show distinct values
✔️ Aggregate → Count (optional)

This collapses duplicate rule rows automatically.

If my response helped, please hit the 👍Thumb Icon and accept the solution so that it benefits future readers.

Regards,
Pratik