Integer Dimension Grouped by (Delivery On Time)

[Mira2423]

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?

[sunny_talwar]

Try this as your dimension

=Floor([_C_BI_MSEG_39.ActualDT] - [_C_BI_VBAP_10.PreferredDT])

[Mira2423]

Hi Sunny, thank you. It did work. 🙂