Hi,
I'm trying to get a card visual on my dashboard that will show the average number of clients per resource (excluding holiday). For example, Mark Diplot has 4, Pavarti Prinka has 6, Robert Lee has 2, Sam Enfield has 3 and Terri Malone has 0. The average clients per resource is therefore (15 / 5) = 3 which is what I want my visual to say. Can anyone suggest a column or measure that would allow me to do this please? It needs to be dynamic, so that if more data is added it will update automatically. I have added a screenshot of my data tab for reference. Thanks in advance for any help.
I'm trying to get a card visual on my dashboard that will show the average number of clients per resource (excluding holiday). For example, Mark Diplot has 4, Pavarti Prinka has 6, Robert Lee has 2, Sam Enfield has 3 and Terri Malone has 0. The average clients per resource is therefore (15 / 5) = 3 which is what I want my visual to say. Can anyone suggest a column or measure that would allow me to do this please? It needs to be dynamic, so that if more data is added it will update automatically. I have added a screenshot of my data tab for reference. Thanks in advance for any help.
