Using Breakdowns in a Count Distinct Automated Indicator

[jtowens]

Hello, when using Count Distinct as the aggregate for an automated indicator, should breakdowns provide relevant scores as well? For example, I have an indicator that returns the qty of distinct users that closed one or more tasks in a given day. If there is a breakdown applied for things such as priority or workgroup, should a distinct count of users within that breakdown be returned as well? The breakdowns work for indicators using Count, but return scores of 0 for all breakdown elements when the aggregate is Count Distinct.

[pieter_goris]

Hi Jason,

it works for me on a Geneva Patch 3 Hot fix 2 instance.

Example, for an indicator 'Number of distinct callers of resolved incidents' I get a score of 41 distinct callers on 81 resolved incidents:

If I go to the breakdown Priority I see:

zooming in on priority High, notice that there are 2 distinct callers for 3 resolved incidents:

Now the two callers from the screenshot above, are also callers for resolved incidents with other priorities. That explains why the sum of the priority breakdown elements (24 + 20 + 19 + 2 + 0 = 65) is higher than the indicator score (41).

Hope this helps.

Cheers, Pieter

[jtowens]

Ok, thanks, this is helpful. I'm currently in Fuji, so once we upgrade I will retest.