1 of 1 people found this helpful
in this case normalize all of your aggregations at the minute level. if i worked 8 hours and 23 minutes today, I would have worked 503 minutes. If the rest of my team worked those same hours (6 people) our total minutes would be 3018 minutes. divide this total by 60 and you will get 50.3 hours
Yeah that's how ive ended up doing it. I did ideally want it to show it as a time eg 50:23:00 or something like that instead of 50.3 hours though. I've done some serious googling today and come to the conclusion that it cant be done unless you break it up and make it into a string which I don't want to do.
Tableau really does have some glaring omissions on standard stuff.