create a dashboard where I can select a client and see how many juniors vs. seniors have worked on that client month by month, based on the sum of "Du

[Alina_T]

I want to create a dashboard where I can select a client and see how many juniors vs. seniors have worked on that client month by month, based on the sum of "Duration (decimal)".


Basically, I want to:

• Compare the total time worked between juniors and seniors
• Observe whether different people are being assigned to that client over time
• Analyze if there are significant differences in workload between juniors and seniors
• Compare senior-to-senior and junior-to-junior contributions across month

Can you help me, please?

 

[vletm]

In the beginning You wanted something
BUT
After that You wrote that Basically You wanted something else ...

I tried to solve Your latest ... want.
I added those around Your given data.
> there are some Tags which has two members - those pair has used as 'single' tag.
All those four 'basically's can move to other sheet too.