I’m currently working on an app designed to assist children with eating disabilities in mastering various food items. I have implemented a bar graph that displays the number of sessions it takes to master each food item. However, I’m facing an issue with data representation on the X-axis.
The issue arises from the fact that the session count values are derived from the count of records in my table for each respective food item. These records are scattered and not entered in a specific order, resulting in multiple entries for the same food item on the X-axis.
For instance, if it took 3 sessions to master Peanuts, the graph displays values like 2.5 in one instance and 0.5 in another. Ideally, I want to represent one item with the correct value of 3.
Could someone guide me on how to organize the data or tweak the graph settings in Glide to ensure accurate representation on the X-axis?