Hour Average

[sevvalk]

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') 

[hic · Accepted solution]

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'

   )