1 of 1 people found this helpful
Can you post the packaged workbook (twbx file) or the calculation that is being used?
I couldnt find the exact issue in your work sheet. Can you take a snapshot and display that here?
values in red are wrong , for 30:04:00:00 it should be 0:04:00:00 but for Zero its showing 30 , for green its working perfect. And I am using custom format (dd:hh:mm:ss) for ech column.
Response time = (calculation 1+calculation 2+ AddDifff)...
The issue appears to be your machine specific as I am getting correct values. Try doing these
- Upgrade to latest version of Tableau 7 or 8 (download from site and reinstall)
- If above does not work, try making the sheets again.
- Lastly if this also does not work, I will probably check the system settings of your computer.
I am using Tableau 8 , and getting same error.
try this create calculate field with value .17 then through custom formatting change it to dd:hh:mm you will get 30:04:04,
you can also check my system settings.
I have zeroed into your problem.
Tableau is starting its date calculation from
Saturday December 30, 1899
So if I input zero.. this will give the above value(Saturday December 30, 1899). In dd:hh:mm it will be 30:00:00.
In this format unfortunately, you will never get 0 days(it will be either be 30, 31, or 1).
I will suggest custom formating using calculations to be the right way.
thanks for your quick response,
Can you guide me how to write calculation for custom format , I have separate day measure , we can write that
if day =0 then sum (Value ) in hh:mm:ss format else sum (value) in dd:hh:mm:ss format.
I will prepare an example aheet and share with you tomorrow. BTW I searched the forum and there is no easy way of doing this.
Here is the work sheet attached.
I have created 2 additional fields
- # of seconds
I first converted your decimals into seconds and then worked backwards to format it into Days, Hours, Minutes and Seconds.
I used some help from below thread for formatting>
Hope this helps.
workdays.twbx.zip 51.3 KB