Hello everyone,
I'm facing issues while creating a view. I have a grouped column chart. Now I want to limit the number of displayed bars to 6, but scrolling to the other bars in the time line should be possible. When I use the data setting "Allow scrolling," scrolling works. However, when I set a limit in the data setting, I can't scroll anymore, and the displayed time period is fixed.
I hope you understand what I mean.
Does anyone have an idea how this could work?
+6Hello,
I used the General Setting > Advanced > Query Limit to set the number of top X values I wanted to see... it has a limitation though: it will show ONLY the first X values, without the scrolling feature to go further (a workaround could be to select from the graph the top X values and invert the filter, not ideal but something)
As a workaround to fix this issue (which I think you need), will be to manually create 2 buttons "previous" and "next". These buttons will increment/decrement variable values based on how much data we need to show (first 0 to 10, 10 to 20, 20 to 30, etc). Then use a filter in yaml to show only data that falls within the selected range. Filter utilises the INDEX_ORDER PQL to limit data. I leave an example underneath:
FILTER INDEX_ORDER ( PU_COUNT("LFA1","EKPO"."_CASE_KEY") , ORDER BY (PU_COUNT("LFA1","EKPO"."_CASE_KEY") DESC) ) < ${rankright} AND INDEX_ORDER( PU_COUNT("LFA1","EKPO"."_CASE_KEY") , ORDER BY ( PU_COUNT("LFA1","EKPO"."_CASE_KEY") DESC) ) >= ${rankleft}
Having checked in out forums, scrolling in the charts is already in the roadmap for Celonis product developers, hope the workaround helps in the midtime!
Thank you
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
