Forum Academy Marketplace Showcase Pricing Features

Creating Pie Chart based on database


i have a table of contacts where one column lists the contact status. I want to present the data in a pie chart that will show the total number of contracts in a particular status. For example, if I have 5 contacts in ‘disqualified’ status, I would like the chart to show that as a lump figure, rather than as 5 separate figures.

Please advise me on the best approach for this.

Kind regards

Hi there, @eilongold2503… you need to use the :group by option when creating the chart, and it would look something like this…

Hope this helps.