
2. Re: How do I divide time by a whole number and return time?
Vishal Patel Sep 30, 2016 9:30 AM (in response to Shinichiro Murakami)Hi Shin,
Please see the attached Excel file for the example. The calculation is done within the Pivot Table.

AHT Example.xlsx 45.5 KB


4. Re: How do I divide time by a whole number and return time?
Vishal Patel Sep 30, 2016 10:02 AM (in response to Shinichiro Murakami)Yes, that is correct.
What I did for Cal THT in Tableau was convert what was there to all seconds and than use a calculation of <seconds>/86400 and format to hh:mm:ss to get back to hh:mm:ss.
But when I divide Cal THT/Total IB Calls in Tableau, it comes up with something completely different than I would expect. I'm expecting the answer I see in Excel.

5. Re: How do I divide time by a whole number and return time?
Shinichiro Murakami Sep 30, 2016 11:06 AM (in response to Vishal Patel)I tired but cannot make it by very easy way.
I mean it's impossible to show aggregated "date/hour" format and normal number at same time in multiple measure value".
So put three measure separately, follow post for detail procedure.
Anyway to calc "date" value.
Table and Excel handle date data differently.
Tableau starts from 1899/12/30, while excel starts from 1990/1/1 or even allows something unrealistic 1990/1/0.
To remove day part from hhmmss.
I created the formula
[THT Days] // this is recognized as "days"
[Total Handle Time]DATEPARSE("yyyyMMddhhmmss","18991230000000")
and to format as hhmmss
[THT (hhnnss) ]
DATEPARSE("hhmmss","000000")+sum([THT Days])
same thing for AHT
[AHT dyas]
sum([THT Days])/sum([Total IB Calls])
[AHT (hhnnss)]
DATEPARSE("hhmmss","000000")+[AHT (days)]
To put three measures separately, follow post for detail procedure.
Thanks,
Shin

hhnnss_format_9.2_SM.twbx 83.3 KB


6. Re: How do I divide time by a whole number and return time?
Shinichiro Murakami Sep 30, 2016 11:25 AM (in response to Shinichiro Murakami)1 of 1 people found this helpfulTo get THT days this formula is much cleaner and understandable.
[THT days 2]
[Total Handle Time]
datetrunc('day',[Total Handle Time])
Thanks,
Shin

7. Re: How do I divide time by a whole number and return time?
Vishal Patel Sep 30, 2016 11:43 AM (in response to Shinichiro Murakami)Thank you Shin for your help and insight. I will try this and get back to you with my results.
Greatly appreciated!

8. Re: How do I divide time by a whole number and return time?
Shinichiro Murakami Sep 30, 2016 1:26 PM (in response to Vishal Patel)1 of 1 people found this helpfulSounds good.
Good luck!
Shin

9. Re: How do I divide time by a whole number and return time?
Vishal Patel Oct 3, 2016 10:34 AM (in response to Shinichiro Murakami)It worked great. Thank you for your help again!