Hi Denise,

this can be done like this:

AVG(PU_COUNT_DISTINCT(CASE_TABLE, ACTIVITY_TABLE."USER_NAME"))

In case you would like to only count Dialog Users and your use case is based on SAP you can add a filter like this:

AVG(PU_COUNT_DISTINCT(CASE_TABLE, ACTIVITY_TABLE."USER_NAME", ACTIVITY_TABLE."USER_TYPE" = 'A'))

BR

Dennis

Thank you Dennis, it works.

@dennis.pflug if I use this formula in a graph to trend against time (monthly), does the formula stay the same? I do that and then if I filter on a specific month then the KPI and the graph value differs.

I am using the formula with the filter ACTIVITY_TABLE."USER_TYPE" = 'A'

I solved it, I had to use a PU_FIRST in my time formula. The KPI and the graph is now the same.

Great :)

Good to hear that the logic is now working for you