Skip to main content

Does anyone know how I can create a histogram in a view? In the standard analysis sheet it is out-fo the box available but not in views. Or a way how I can create 'ranges' of a dimension?

 

 

image

It is not clear. I have been playing a bit and looks like with Chart, selecting layer BAR, and using as vertical value count of occurrences, and as x value something using QUANTILE you should get it (or something similar)

 

You can also toy with the parameter Scale Type, Nominal

 

imageQUANTILE - https://docs.celonis.com/en/quantile.html

 

image 

HTH

P.S.: If you discover how, please let me know!


Thanks, Guillermo for you reply, I tried using QUANTILE but not really getting what I want but it is close.

What I did now is define the 'buckets' I need my self

imageonly things what I have don't figured our here is how to sort it properly. The buckets are days between 2 dates.

This is how it looks when I use QUANTILE.

imageBut would be nice to have less points on the x-axis

 


Thanks, Guillermo for you reply, I tried using QUANTILE but not really getting what I want but it is close.

What I did now is define the 'buckets' I need my self

imageonly things what I have don't figured our here is how to sort it properly. The buckets are days between 2 dates.

This is how it looks when I use QUANTILE.

imageBut would be nice to have less points on the x-axis

 

Yes I am afraid that's the approach. I checked one TryCelonis demo and that's how they build their "histograms"

 

As example search for Order Management Process Cockpit (EN)

https://partners.try.celonis.cloud/try/ui/demo-portal/ui?contentId=order-management-process-cockpit

 

And in this "histogram": imagethey use as x value a KPI where they create manually the buckets with a complex CASE WHEN

 

So... you have to build your own "histograms" ....

 

 


Reply