Average by Type

[danieldors]

Hello,

Im trying to find the average number of unrun drivers for the work type Generic Full, the formula Im trying below does not pull the correct average

=(count({<Unrun_Drivers={'1'},Action={'Application','Additional Benefit','Redetermination'}>}[Access Number]))/(count([Work Type]=('Generic-Full')))

[Vegar]

It's hard to pinpoint good advice without knowing more about your data, but I world recommend you to check if the calculation error lies within the nominator or denominator of your expression. By the looks of it your denominator looks a bit unusual, what are you trying to calculate?

[danieldors]

I was able to figure out the solution, the numerator was the total number of cases per worker cohort (Generic-Full) and the denominator the total number of employees under that cohort . Thank you for taking the time to look it over.

=(count({<Unrun_Drivers={'1'},Action={'Application','Additional Benefit','Redetermination'},[Work Type]={'Generic-Full'}>}[Access Number]))
/(count({<[Work Type]={'Generic-Full'}>}[Work Type]))