I am not an expert on tableau and I think that maybe there is an easy solution to my problem...
I have staff productivity calculated as Completed H/Available H.
I got the max productivity in each group (max pane down)
In the first team in the first screenshot below (CHCorrective Actions), the max productivity is 442.22%
When I group that at team level instead of staff level (second screenshot below), I would like still to show 442.22% for team CHCorrective Action, but instead is taking the max along all teams.
Are you able to assist, please?
Thank you very much for the assistance.
Retrieving data ...