Creating Pie Chart based on database

eilongold2503 · 2020-11-21T15:19:40.147Z

Hey,

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
Eilon

mikeloc · 2020-11-21T16:46:29.643Z

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

group709×468 22.2 KB

Hope this helps.

Best…
Mike

system · 2021-01-30T15:19:43.891Z

This topic was automatically closed after 70 days. New replies are no longer allowed.