Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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')