Hello everyone,
I have a table that shows Individual productivity of each employee in % ( sum of hours spent on projects+IO only/ total working hours from contract). There I am using Include LOD to include period into the view, otherwise calculation shows wrong result.
And then I have a doughnut chart showing split of hours based on hours from the contract. For labels I am using table calculation to show % of total for each activity. I would expect when I select an employee my "green area" pie chart (projects+IO if available) and individual productivity for this employee will have the same result. But as I do not use Include LOD for period results are not the same.
Is there any way to modify either LOD calc or table calc to achieve needed result?
Thank you in advance!
Workbook is attached
Understood. Consistency is usually important but not always logical..
Anyways, if I was Aaron Smith and I had worked 122 productive hours overall over 100 working hours in total, i'd expect it to be 122%.
After all, the donut does not distinguish by period, especially not when the BAN in the center of the donut lists the entire productive hours. If you go for the 125% here, it would be inconsistent within the donut itself.
Having said that, I believe you should change the moving average calculation in your graph to this formula:
WINDOW_sum(sum([Productive Hours]),FIRST(),0)
/
WINDOW_sum(sum([Working hours per month]),FIRST(),0)
which will yield the 121.96% at 8/22
And then change the table accordingly, get rid of the include lod.
