How to use Charts with query based on boolean value?

Wappler General How To
,
#1

Hi everybody,
I need to display a pie chart of total users.
Some of them are regular ones, others admins and/or responsable. I used boolean values (true/false) in DB to set they are admins and/or responsables.
How should I do to count and display this?
Thanks

#2

Other question.
How should I do if I want to display the count of users created (I assume i have a created field in my table) day after days (or week)?
Is there somewhere any documentation on how to use charts? I mean dealing with datas in chart.
Thanks for your help.

#3

The way I have done not sure if it’s the best but works for me.

I set up queries then set values to count the numbers of items of in a query using the .count().

image
image980×274 21.2 KB

Then add a chart element to your page and use the set values as the set data.

image
image690×1042 53 KB

Using this I ended up with

image
image1060×774 17 KB

1 Like
#4

Thanks for your answer.
I just tried without succes.

I think i’m missing something with the data source… I don’t know wich query I should select, or if should select the SC or SC.data - depending of it I can or can’t bind the values I just setted.