I have records that have a field called `Compliance Framework` which can be [x,y,z,other]. I want to get a count of how many records there are for each “compliance framework” and then to visualize that as a pie chart
Hey Jordan!
We would need 2 fields here:
So, when you select these 2 fields you will get exactly the result you want - your data will be grouped by distinct `Compliance Framework` values and they will have the count for each value.
And you select the pie chats in the visualization tab after that