Forum Academy Marketplace Showcase Pricing Features

Group the count for Line/Bar Chart

Hello!

Looking for some help with creating a chart with the Bubble Line/Bar Chart tool.

I have a Moods field in a table called Diary that is a list of items from an Option Set of Ref_Moods and want to present a bar chart of the counts of those Moods from the Diary entries.

e.g.
Happy 5
Sad 4
Angry 2
Excited 4

I’m struggling to group the count by Mood either as a Search for data or Ref_Moods. Does anyone know how to do this? Thanks!