topic Re: Hour Average in App Development

Hour Average

sevvalk — Fri, 15 Nov 2024 21:12:44 GMT

Hello, the following formula gives the difference of time and date recorded in two cases for each order. Each complaint has an entry date, which is "Date2". How can I show weekly average time differences on a chart?

interval(Timestamp#(Max({<ssldrm={'H'}>} Date1),'dd.mm.yyyy hh:mm:ss') - Timestamp#(Max({<ssldrm={'A'}>} Date1 ),'dd.mm.yyyy hh:mm:ss'),'DD hh:mm:ss')

Re: Hour Average

hic — Fri, 01 Dec 2023 12:53:42 GMT

I assume that you want to calculate the time difference per order, then average this over all orders in a week and display it per Week(Date2).

If so, you should try the following measure in a chart that uses Week(Date2) as dimension:

Interval(

Avg(

Aggr(

Max({<ssldrm={'H'}>} Date1) - Max({<ssldrm={'A'}>} Date1 ),

OrderID

)

'DD hh:mm:ss'

)