Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
So I would like to calculate the on time delivery and then show in a graph the distribution of this interval.
The image below shows that I used:
Dimension: =interval([_C_BI_MSEG_39.ActualDT]-[_C_BI_VBAP_10.PreferredDT],'d')
Measure: a count of cases
What I want in the graph is that the interval is grouped which means: if I have cases where the delivery interval takes -12 days I want to see how many cases takes -12 days. So that the -12 should be grouped and not distributed into 3 buckets.
Is that possible?
Try this as your dimension
=Floor([_C_BI_MSEG_39.ActualDT] - [_C_BI_VBAP_10.PreferredDT])
Hi Sunny, thank you. It did work. 🙂