Finding Duration and formatting output

[scottmkirkland]

I'm having trouble getting my duration into the format I'd prefer... I'd like to see the duration to be MM:SS. However, despite a few different approaches, I keep getting milliseconds.

[scottmkirkland]

Thank you @VatsalJagani 

I took that and I'm trying to get the avg response time for each year. AvgAtScene is in seconds, so I'm trying to get that into the duration. Any suggestions there?

[ITWhisperer]

| eval AvgResponse=tostring(round(AvgAdScene,0),"duration")

[ITWhisperer]

Stop parsing the milliseconds from your time values, or convert the resultant time to an integer, or round the times to zero decimal places.

[scottmkirkland]

@ITWhisperer Are you suggesting I just drop the %N in my strptime?

If I do that, my results don't change.

[isoutamo]

You should use round to seconds before (or inside) tostring function. That just drop ms away.

[VatsalJagani]

@scottmkirkland- In your latest query you can just drop all millisecond zeros with the help of substr.

Example:

| eval secondsToAtScene = tonumber(substr(secondsToAtScene, 1, len(secondsToAtScene)-7))

This will just remove last 7 characters which will remove milliseconds part from it.

And you can apply this to any fields the same way.