Forums :: Dynamic Chart :: DwZone Forum

DwZone Forum
Welcome to the DwZone-it Forum

FAQ

Memberlist

Usergroups

Dynamic Chart

DwZone Forum Index -> Dynamic Chart

Moderators: Administrators, Moderators

Mark all topics read

Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes.

	Search for
View Per page Messages Since

Messages 1 to 10 of 74 (Total: 31)

First | Prev | Next | Last

Subject

Author

Date

Cannot get the image file from Temp folder

Alfredo Guerra

15:14 19 Oct 2012

Re: Cannot get the image file from Temp folder

Gianluigi

15:24 19 Oct 2012

Re: Cannot get the image file from Temp folder

Alfredo Guerra

15:27 19 Oct 2012

Re: Cannot get the image file from Temp folder

Gianluigi

0:48 20 Oct 2012

Dynamic chart and Count function

RichardBellamy

2:55 27 Aug 2012

Can you help with a difficulty when using Count in Mysql.

I have a simple recordset which returns a count of individuals who have completed some training. If they are not trained the field 'Indep' is set to Probationer, if they are trained, it is set to Independent.

My query (mysql) generating the chart data is :
Select Indep, count(Indep) from
database.table
Group by Indep

When tested this produces the correct data - a label and a count of the people meeting that criteria.

However, when I run the chart I get the following error:

Warning!!
DwZone.it Dynamic Chart error:
The recordset contains a non numeric value
Field: indep
Value: 3
Verify the data in your recordset, all the value fields must be numeric

I have tried setting an alias for the count value - the same error is produced
I have tried casting the resulting alias as a signed integer - the same error is produced