I am trying to figure out how to show how much each person is being utilized every month out of their total capacity in a stacked graph.
I have appended query showing
Yellow - how many days each week a person is booked on a project (allocated)
Blue - How many days they are available that week (capacity)
I think I need to add a measure, but not sure what calculation will work.
No 1 is my primary visual showing all allocated, but when I filter this by date my 2nd visual aligns to allocated and removes the capacity. Ideally, i would like this 2nd visual as a stacked graph but haven't been able to make that work