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
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.
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