How to create a pie chart?

April 13, 2021, 08:06:58 PM

Hi all,
I would like to create a pie chart about a table but I cannot make it to display anything.
The table contains registered users. The user record has an "active" field.
The "active" field can be 0 or 1.
I would like to display a pie chart about regitered users (the whole pie) and a registered and active users (pie slice).
But I cannot understand how to select the correct data.
I can succesfully create bar chart.
But is there a tutorial about pie chart?
TIA
tony

Re: How to create a pie chart?

Reply #1 – April 26, 2021, 01:26:58 PM

@sweetman‍ please use the group by active clause in your SQL query. or you can download a sample project from here to learn.