[SOLVED] Plotalot and Community builder

Hi,

I started to use plotalot, that make chart with joomla sql queries data. And get a statistic chart for CB fields.

I have a CB field single-select [dropdown] and i would like to make a chart with that field.

This field have 3 values, and i would like to make a query to get the value of how many of each i have, for example:

teachers, [joomla query for nº of teachers]
students, [joomla query for nº of students]
parents, [joomla query for nº of parents]

and get the results:

teachers, 15
students, 75
parents, 23

Thanks

Do a COUNT select query on _comprofiler with a WHERE statement for your dropdown fields column. Please see the below tutorial on how to create a COUNT select query.

www.w3schools.com/sql/sql_func_count.asp

Thanks,

Really nice. I think i'm getting close to my first sql "code".

I wrote that code but some thing is wrong could you help me to figure out what?

But i get a error on the syntax!

thanks

You didn't use any apostrophes or quotes to designate tables/columns and values. You also don't need to table prefix every column and don't need the prefix for queries using Joomla as it'll auto replace #__ with the prefix. Please see the below.

Thanks

Hello,

I have recently found this component as well and i would like to be able to create bar graphs. In our CB fields we have created fields for each day of the week and for certain times. When members fill this out it shows the site owner the best days for planning events. The fields are named like this: cb_monday, cb_tuesday, cb_wednesday and so on.

I want to show the results of how many members are available for a given day.

Example: Monday 5, Tuesday 7, Wednesday, 3 and so on then use this data in a bar graph so everyone can see how many people are available. I hope I'm making sense. Anyways i am not a programmer so i don't really know what to do or how to craft the code to work.

Thanks for any help with this.

Regards
Alan