I have a chart where the x axis contains a lot of values. Here I don't want to display every single case, but to include a certain distance in the values. For example I don't want the values 1,2,3,4 .. 10 etc. but 5,10 etc. to be displayed. Unfortunately I didn't find a way to do this in the options.
Thanks for the help
Hi @t.m.,
Do you want to include the same number of bars/data points and just reduce the number of axis thicks, or aggregate the data points?
For the former, there are limited options available in the chart setups, but that depends on if you are using an analysis or view in Studio.
For the latter, you could bypass this using the ROUND (celonis.com) (or CEIL (celonis.com)/FLOOR (celonis.com) depending on your use case) functionality and some mathematics.
For instance, to round 1, 2, 3, 4 and 5 to 5, use CEIL("column"/5)*5
Hopefully this helps.
Best regards,
Jan-peter
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
