6 Replies Latest reply on Feb 24, 2017 1:50 PM by Jonathan Drummey

# grand totals for Aggregation of Time field of HH:MM:SS

Hello Tableau Users,

I wanted to find out if we can have grand totals for string calculation of time of HH:MM:SS.. Is there any workaround for grand totals..appreciate the help...I have kept the step by step of procedure

1. First calculate the differen in seconds of the time fields

2. The Calculate the HH:MM:SS using string calculations,

Yes it is aggregating but i'm loosing grand totals because its not measure so i'm the using same procedure to calculate another HH:MM:SS field called Time Duration so now i have calculate the avg that is HH:MM:SS of session Duration / HH:MM:SS of Time suration..but both of them are string i'm unable to do that and also unable to get the grand total..

• ###### 1. Re: grand totals for Aggregation of Time field of HH:MM:SS

Jamieson Christian any idea on this sir??

or Jonathan Drummey any idea please sir?

Appreciate the help

• ###### 2. Re: grand totals for Aggregation of Time field of HH:MM:SS

See Formatting Time Durations in Tableau | Drawing with Numbers , it goes through a number of different options and talks about the order of operations and what to do when in order to deal with grand totals.

Jonathan

• ###### 3. Re: grand totals for Aggregation of Time field of HH:MM:SS

Jonathan Drummey Really thanks for the reply.. I have followed this post..but here for the grand totals i see the calcualtion is there until MM:SS.. i was looking to add hours HH:MM:SS.. just wanted to check with you how to just add the hours ?? appreciate the help

• ###### 4. Re: grand totals for Aggregation of Time field of HH:MM:SS

There's a Tableau Public workbook for the post that is linked to at the bottom of the post, here's the link: Duration Formatting. Download the workbook and open it, there are calculations for HH:MM:SS in it.

Jonathan

• ###### 5. Re: grand totals for Aggregation of Time field of HH:MM:SS

You are awesome... Thanks Jonathan saved my day Jonathan Drummey

• ###### 6. Re: grand totals for Aggregation of Time field of HH:MM:SS

You’re welcome!