Average of an Customer's Delivery Time

Question & Answer
,
1

Hi,

So I have an requirement where I want to project the count of customers in a Vertical Bar Chart whose average delivery time is greater than 90. Hence for which I have created this calculation

Customers >= 120 :
Ifelse(avg({Average Delivery Time},[{Customer},extracted(“MM”,created)]) >= 120, 1, 0)

With having create_date(Month) in the X Axis and Customers >= 120(SUM) in the Values i’m getting the accurate results which I have validated.

However lets say I drill it down this to weekly in the Vertical bar chart and no.s are not adding up correctly. Hence can you let me know whats wrong here.

2

Hello @samytar97 !

Are you using the drill down that appears when you click on the bar or are you filtering this in another way?

My guess is the truncated date in your calculated field is causing the problem.

1 Like
3

Yes I’m using the drill down in the bar and what would be the alternative in this case? And also while I was not using the month truncdate it was not showing me the accurate results hence due to which I had to add truncdate

1 Like
4

Hello @duncan

Bringing this up again to your notice if there is an update on the same?