Indicator Source - Group by User

[DreDay3000]

Hello, is there a way to add "Group by user" to these conditions? This is a Indicator Source pointed to the user has role table but duplicates are being pulled. I would like to only show 1 record for each user

[AndersBGS]

Hi @DreDay3000 ,

No, this should be set on the automated indicator to count destinct.

[DreDay3000]

Thanks, I set the Aggregate to Count Distinct which gave the same results, 

I also tried adding a script on the user has role table

However, I still get duplicate users being pulled from the indicator

[AndersBGS]

Hi @DreDay3000 ,

What if you don't do it as scripted, but only count distinct user?

Have you verified from a widget perspective and not only from an automated indicator perspective? 

[HasarinFareeth]

Hello @AndersBGS 

I have a similar scenario where I need to have the count of SLA breakdown by assignment table but the count should be grouped by Task number and Task SLA name so that the SLA can be calculated accurately for a given supplier as below, 

% x No of SLAs Met by a supplier /  No of SLAs triggered for a supplier. 

Please note that the No of SLAs triggered for the supplier should at the supplier level and not group level as the supplier may have multiple groups.