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?