How to show correctly % of Absences in Total workforce?

[#1]

Hello,

I am trying to create a chart which would show what was the percentage of absences among workforce for given weekday.

I have written such expression as a start but it is not correct as when selecting broader time range absences just cumulate and percentage rises:

count ({$<IsFuturePeriod={0}>} [#Absence Days])/count({$<IsFuturePeriod={0}>} DISTINCT %PersonnelNumber)

I am attaching the screens with data model.

Thank you,

Mat

[Anonymous · Accepted solution]

Hello,

It seems normal to accumulate, isn't it?

You would need an average %.

Try something like :

avg(AGGR(count ({$<IsFuturePeriod={0}>} [#Absence Days])/count({$<IsFuturePeriod={0}>} DISTINCT %PersonnelNumber),%DATE) )

BR

Serhan

[#3]

Thanks Serham, that is what I needed.