Dear Community,
I trust this message reaches you in good health. I have successfully developed a tracker application and defined program indicators, as depicted in the attached image.
I am seeking assistance with the Data Visualizer or Event Visualizer to restrict the number of bars on the chart, specifically to display the top 10 bars based on data values, as illustrated in the image. Your help in achieving this would be greatly appreciated.
Thank you.
Hi
Although it’s not possible to enter a generic formula to limit the number; however, it’s possible to use other features such as:
Limit minimum/maximum values
Axes Options / Axis range
I hope this helps!
I appreciate your prompt response. Implementing a limiting feature is effective when a constant cutoff level, such as a pass mark of 50% for students, is applicable.
However, in my case, the top ten values in my implementation will consistently vary. For instance, the values for an indicator in Dec-2023 might be (49, 47, 41, 38, 34, 32, 32, 19, 15, 14), and this month’s values could be (451, 443, 433, 385, 375, 295, 243, 222, 191, 149), with continuous fluctuations.
To address this, I need the top ten list to be dynamically dependent on the values after sorting them in descending order.
I would appreciate your guidance on how to achieve this. PLEASE HELP. Thank you.
