Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › Dynamic Web Charts › textfields not showing on x-axis

textfields not showing on x-axis

Thread began 10/28/2010 12:05 pm by jonas.ottosson417319 | Last modified 11/01/2010 7:13 am by jonas.ottosson417319 | 2266 views | 5 replies

10/28/2010 12:05 pmjonas.ottosson417319

textfields not showing on x-axis

I am trying to make a basic dynamic chart work like this:

I have a MySQL database table with a column "ID", and a column "instrument"
I want the chart to display the number of rows per instrument, so I choose
"instrument" for the x-label and I choose Group by value.
For the Y value I choose "ID" and I also choose calculation count.
The only result I get is a blank chart where the x-axis has the labels 0-10 (nothing to do with the "instrument" column that i want to be there.)
I keep getting the same result as long as I choose a text field for the x-label.
But when I choose a numeric field for the x-label the chart gives back a correct result.
Doesn´t Dynamic web charts support text fields in dynamic charts?
This could not be the case or what?

/Jonas

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.