RunTime in seconds to Runtime in minutes

jasmeenkr · ‎2019-12-16

Hi ALl,

I have field Runtime with values in seconds- sum(Runtime).How to get Runtime in minutes in qliksense load script

rwunderlich · ‎2019-12-16

Interval(Interval#(sum(Runtime), 's'), 'm:s')

or if you only need whole minutes:

round(Sum(Runtime) / 60)

sunny_talwar · ‎2019-12-16

May be divide it by 60?

Sum(runtime)/60

or

Interval(Interval#(Sum(runtime), 'ss'), 'mm:ss')

jasmeenkr · ‎2019-12-16

What does divide by Sum(Runtine in seconds)/86400 would do ?

What does Sum(runtime in seconds)/1440 would do?

sunny_talwar · ‎2019-12-16

Hey Rob -

'm:s' might not show the correct seconds... although underlying value will be correct. I think 'm:ss' would be correct

sunny_talwar · ‎2019-12-16

24*60*60 = 86400 will convert seconds into days

24*60 = 1440 will convert minutes into days... but won't really mean much for seconds

jasmeenkr · ‎2019-12-16

Ok.Thanks

in case I have to show runtime over span of days shown in another chart, I should divide it by(86400)