1 of 1 people found this helpful
You'll likely need to use Jonathan Drummey's calculation work to make this modification. Attached is a 2018.2 workbook and below are the screenshots. Here's the link to his method: Formatting Time Durations in Tableau | Drawing with Numbers
I set the [Seconds] to be a measure:
Then a new calculation to SUM the Seconds:
Then JD's calculation to bring it to d:hh:mm:ss and the formatting is custom to: 0:00:00:00 instead of d:hh:mm:ss
Hope this helps! Thx, Don
Thanks Don! This does work, the only downside is that it doesn't seem to like the very large numbers to be displayed in just hours instead of days. For example, 346,027 seconds displays accurately in terms of 4 days, but if I remove the 00 from this, it displays as 400:07:07 instead of 96 hours. Is this a limit of the calc or is there any other way to add it to total hours?
2 of 2 people found this helpful
No worries...I'd thought you wanted hours greater than 24 hours displayed as DD:
The modified calculation and attached workbook now sums to total HH:mm:ss. In the previous example there were 4 days (4*24=96) and 16 hours already displayed in the sum as a remainder. So the total of 96+16=112 hours.
Hope it resolves your concern! Thanks, Don
Yep that's it! Thank you!
Glad to have helped! Don
This has answered my question too. Thank you!!