How do i get the bar chart with Grouped by buckets for dates in views

Hi @Rahul Bhat,

If I understand your problem correctly, would be the first step to calculate the throughput times as a number and use this as X-axis? You then do not need to use dates in your graph.

To calculate the throughput times in hours, use:

CALC_THROUGHPUT ( CASE_START TO CASE_END , REMAP_TIMESTAMPS ( "<Activities>"."<Timestamp>" , HOURS) )

(see https://docs.celonis.com/en/throughput-times.html)

Replace here the "<Activities>"."<Timestamp>" with the Activity Table and Timestamp column of your data set.

To get the number of cases on the Y-axis, use the COUNT_TABLE("<Case_Table>") function (see COUNT_TABLE (celonis.com))

I hope this helps.

Cheers,

Jan-peter

Hello @janpeter.van.d 

Thank you for your suggestion. Below is the screenshot with your suggestion.

But i would want them in buckets. like 0-10 10-50 50-100 ...

As in histogram.

Would be helpful if you suggested me about that.

Thanks

Hmm, I see your point.

I have a couple of options:

1. Try to set the x-axis to a different scale type (click on the wheel icon, see screenshot below)
2. Use Round to automatically make buckets (of the same size). In this example the Throughput time is rounded to the nearest ten. Replace 'x' with your throughput time formula.
   1. ROUND(x /10)*10
3. Create Buckets manually using a CASE WHEN statement.
   1. CASE WHEN x BETWEEN 0 AND 10 THEN '0-10 hours' WHEN x BETWEEN 10 AND 50 THEN '10-50 hours' END

Unfortunately, these are still workarounds to mimic the function of the Histogram, but hopefully it helps.

Hi @sujeevan.ferru13  Thanks a lot this worked

Cool, I wasn't aware that the Histogram was available in Studio yet. Thanks for sharing!