Good day, can someone please share with me the formula that is used in the PI Social to calculate the KPI "Users per case"

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