We currently have a calculation called “Business ElapsedTime” that shows the total amount of hours worked for a request. This datacomes in as seconds.
I would like to show this information in “Days”, so thefollowing calculation was made: [Business elapsed time]/60/60/9
(Currently the calculation shows 1 Day = 24 hours.) I would like each “Business Day” to = 9 hours.
My question is, what is the calculation to make every 9hours=1 Day?
Wouldn't you just divide your elapse time by 32400?
Your 1 day = 60*60*9 = 32400
3 x 9 hour days = 97200 second
For example ET = 101,340 seconds/32400 = 3.128 days.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...