Troubles configuring a barchart

whywork · 2025-01-27T12:32:56.383Z

Hi all, I’m building an app where I need to show occurrence of data in a chart. I’ll give an example, the ‘current_level’ data in the database is as follows: 6, 2, 4, 11, 8, 5, 4, 1, 1, 6, 6, 1, 10 and I want the chart to show number of occurrences of each value.
I would like the x-axis label to show all value from lowest to highest without duplicates. I was able to achieve this with: Search for User: each item’s current_level:unique elements: sorted

The problem I have is properly representing number of each occurrence with the bars. I hoped that: Search for User: each item’s current_level:unique elements: count would work, but it doesn’t. It counts unique elements in the entire database (8 in this case) and does not count numbers of each element.

Screenshot 2025-01-27 at 1.29.49 PM862×1444 105 KB

Screenshot 2025-01-27 at 1.29.30 PM1122×618 5.97 KB

I tried playing with various options, ‘group by’ etc etc, nothing seems to work.

If anyone could help, I’d greatly appreciate it. Thanks!

hergin · 2025-01-28T03:55:05.457Z

The Bar value should be something like this:
Search for Users: each item's current_level: unique elements: sorted: format as text
Then, in the format as text box below:

image346×331 5.39 KB

content to show ... will be Search for Users (current_level = this number): count and
delimiter will be , (comma only).

The explanation is: you already had the X-axis labels as the current_levels, now for each level, you have to find user count and separate them with commas for the bar value field.

whywork · 2025-01-28T15:01:40.533Z

Thanks, I just tried and it doesn’t seem to work. I wasn’t able to enter it exactly as you instructed. Here’s how I did enter it:

Screenshot 2025-01-28 at 3.19.53 PM1826×1458 328 KB

hergin · 2025-01-28T17:00:54.403Z

In the content to show... you will just Search for Users and in the constraint, you will add current_level = this number. You won’t do each item’s current level this time. Then, get count.

whywork · 2025-01-28T17:20:41.476Z

It works now. Thank you SO MUCH! I spent several hours on this.

system · 2025-04-07T12:33:18.219Z

This topic was automatically closed after 70 days. New replies are no longer allowed.