Suppose I have a [Time]: 164551 seconds. I want it to show with hh:mm:ss format.
I tried two ways, but neither worked.
1. If I put my function as [Time], choose number formatting as Duration and format pattern as h:mm:ss, then it shows as 3949224:00:00, which is the wrong result.
2. If I put my function as time([Time],'hh:mm:ss'), the result also shows as 3949224:00:00.
What's wrong with these two methods? What should I do?
Thanks in advance!
Accepted Solutions
Maybe someone else will come with a more meaningful response. You may want to forgo using the format in the UI, and try formatting it in the dimension.
Try something like this:
Data:
TestData:
LOAD * Inline
[
'UserId', 'seconds'
1, 164551
]
;
EXIT Script
;
UI;
=Interval(seconds/86400,'h:mm:ss')
On another note, I'm not sure why my original attempt at Time(Time#(seconds,'s'),'hh:mm ss') didn't work and gave me the wrong answer.
Hope this helps.
Maybe someone else will come with a more meaningful response. You may want to forgo using the format in the UI, and try formatting it in the dimension.
Try something like this:
Data:
TestData:
LOAD * Inline
[
'UserId', 'seconds'
1, 164551
]
;
EXIT Script
;
UI;
=Interval(seconds/86400,'h:mm:ss')
On another note, I'm not sure why my original attempt at Time(Time#(seconds,'s'),'hh:mm ss') didn't work and gave me the wrong answer.
Hope this helps.
