Graph values on x axis are shown twice

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?

Thank you in advance for your assistance!


Can you show me a screen shot of what the source data looks like? (from the Glide Data Editor)

1 Like

@Darren_Murphy thanks for the response

I’m dealing with a bit of complexity here. Here’s the breakdown:

  1. There are multiple instances/records of the same food with the same session number.
  2. I’ve set up a relation column to gather all these instances (Column: Graph relation).
  3. Using Session counter (unique), I count all the unique sessions.
  4. I also have Session count (total) to count all sessions.
  5. In the “No of sessions” column, I calculate the ratio by dividing Session counter (unique) by Session count (total), and this becomes my Y-axis.
  6. When displaying in the graph, it correctly accumulates all foods on the x-axis, providing the correct session count.
  7. The issue arises when records are far away from the rest of the group, creating duplicate entries for the same food on the x-axis.

Can you try changing the “Page Size” of graph to a higher value?

3 Likes

@Hassan_Nadeem thanks a lot, i increased the size and it worked :slight_smile:

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.