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?
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?
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
QUANTILE - https://docs.celonis.com/en/quantile.html
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
only 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.
But 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
only 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.
But 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": they 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" ....
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.