Hi, I'm trying to produce a bar chart that will show the lead origin of our customer base. Each customer record has a field called 'lead origin' and this is filled out using a drop down menu of values. e.g. Google Search, Trade Show, Website, etc. I want to produce a chart in Filemaker that will show each value, and the number of times its been chosen, Google Search (6), Trade Show (4) etc.
I've been looking into the value count etc. But not sure how to get the count of each choice and not the count of the unique values.
Please, could someone point be in the right direction?