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.
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:
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.
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.
