As I state in this '24.2 authored article - this is currently not possible.
'25 improves this: https://docs.pega.com/bundle/platform/page/platform/release-notes/reporting/whats-new-reporting-25.html#rn-reporting-parent-con__section_s4s_nqg_c2c_title
Hi All,
We have an Insight for a data object, which has 3 advanced associations. One of the associations is between Work object (Exception case) class and another table which has the list of Exception Codes and Descriptions.
So, for example if there are two Exception cases created in total (one per Exception code)
Case 1 : Exception Code “ABC”
Case 2: Exception Code “XYZ”
When we use the Exception Description from the association in the Insight, we are seeing duplicate results as below:
Case 1 : Exception Code “ABC”
Case 2 : Exception Code “XYZ”
Case 1: Exception Code “XYZ”
Case 2: Exception Code “ABC”
Basically the cases and the exception codes are getting multiplied and instead of 2 results we are getting 4 results. (The join condition of the association is the Exception Code )
Did anyone face similar issue? If yes, how can this be resolved?
I would suggest posting a brand new thread on the User Experience Expert Circle, buried in this Infinity '24 article it might not get the attention it deserves!
It would be good if you could post in that some screenshots of your advanced associations in that post. I suspect with will be in the “type” for using that Class Join where the duplication has occurred, though it could be the nature of the join condition itself (hard to tell without some of configuration)
You may also find this useful Utilising Advanced Associations (joins) with Insights in Explore Data to report on Tags