topic Re: Calculate between time stamps in App Development

Calculate between time stamps

Eaun — Mon, 20 Dec 2021 21:38:40 GMT

This sounded simple to start with I thought just use interval to give me the times but no. On the spreadsheet is the data I'm getting I need to calculate the time between status 4-1 that will give me the up-time and the time between status 1-4 will give the time stopped and the time between 2-4 will give the time in manual mode.
I've tried the above function but with no luck what would be the best way to do this or do i pass it back has its not possible with data in the format it is in ?

Re: Calculate between time stamps

sunny_talwar — Tue, 11 Feb 2020 12:24:15 GMT

Are you looking to do this on the front end or back end of the app? If you tried above() in the back end, it wouldn't work because Above() is only available on the front end of the app (in a chart).

Also, if you did try it in a chart, what were your dimensions? What was your expression?

Re: Calculate between time stamps

Eaun — Tue, 11 Feb 2020 12:52:00 GMT

Looking at this from the front end I've tried this :

Sum({<InAuto={'True'}>}Aggr(Interval([Machine Time]-Above(total[Machine Time],1),'hh:mm:ss'),[Machine PK]))

its the same as looking status 4 but its wrong because it will only calculate between status 4 and status 4 does that make sense ?

Will attach the app Can not get the qvd to attach

Re: Calculate between time stamps

sunny_talwar — Tue, 11 Feb 2020 12:54:55 GMT

Are you looking to get 8 minutes and 23 seconds on the row where Machine PK is 433?

Aggr( Interval(Only({<InAuto = {'True'}>} [Machine Time]) - Above(Only({<InAuto = {'True'}>} [Machine Time])), 'hh:mm:ss') , [Machine PK])

Re: Calculate between time stamps

Eaun — Tue, 11 Feb 2020 13:27:06 GMT

Thank you that looks correct will try it and report back : )

Re: Calculate between time stamps

Eaun — Tue, 11 Feb 2020 14:36:13 GMT

Made a little change

Sum(Aggr( Interval(Only({<Status_code = {1}>} [Machine Time]) - Above(Only({<Status_code = {4}>} [Machine Time])), 'hh:mm:ss') , [Machine PK]))

and then changed the status codes to get the difference times with each status