I would like to ask for help. I am trying to make a report which would show used capacity of my coworkers. But i am getting data from excel in the form of digit 1 as filled day and digit 0 as a free day for work.
I need to make visualisation of used capacity per worker and as whole team as percentages capacity utilization. I have data in this form:
And i am trying to vizualize workloud in % per worker. I was trying gauge but i cant figure out how to show a goal (cca 97 % of total) and the most importantly the percentage of days which are used for work. Vizual here:
I would apreciate any help or tips very much.
Based on my assumption, maybe you could try this measure:
Percentage = CALCULATE ( COUNT ( table[Days in work] ), FILTER ( ALLEXCEPT ( table, table[Jmeno] ), table[Days in work] = 1 ) ) / CALCULATE ( COUNT ( table[Days in work] ), FILTER ( ALL ( table[Jmeno] ), table[Days in work] = 1 ) )
For more advice, please show us your desired result. And tell us which columns should be used and what the calcution rule should be.