Average of an Customer Delivery Time

Question & Answer
,
2

Hi @samytar97

Can you try trunc date function with WK & MM for week level & month level calculation .

avg(Sales,[Product,truncDate(‘WK’,{Order Date})])
avg(Sales,[Product,truncDate(‘MM’,{Order Date})])

If its not working , could you please upload the sample dataset and create the sample visual Arena and share it with us to check further.

Thanks
Vinod

1 Like