How Can i calculate Average Days between Order Date And Shipment Date?
Hello everybody,
I'am using Qlik sense Desktop. I'am unable to get the desired output for my question.
First i calculated Days between Order Date and Shipment Date in script as: Day([Ship Date]) - Day([Order Date]) as days;
Here i get the difference days in seperate column. Now i want to find Average of difference days according to Sub-Category wise example:- chairs, art etc. Here i don't get the the desired output. i have attached an image. kindly help me. Thank you
.png){kind=link}