Hi all,
Right. So, I have created a report for work tracking the weekly staff allocations of a few hundred people over the last few months as they've been redeployed to other areas during the pandemic. This took the form of a pretty simple cluster bar chart that showed wekly allocations and an accompanying donut that showed the split between teams pretty nicely. One entry per person per week. Simple.
However, now that we have passed the first big covid spike people are being (in some cases) rotated back to their usual role, which is fine, but also increasingly now doing split-roles (say, a couple of days research and a couple of days on wards).
Now, I could record the hours someone spends on each role easily enough and keep a count that way, but I can't think of any obvious way to have the report recognise both roles as being done by a single individual - I'm pretty sure I'd have to have two entries for the person in question, which is [i]ok[/i] I guess but would skew the donut visualisation by making it seem like a team has more staff in it than it does. And also make my spreadsheet messier.
If I created, say, a seperate helper table that is just a list of names/IDs for example and had the visualisations refer back to that in some way, just to keep the team size constant?
