I would like to draw a bar chart based on the data available in mysql data base. I am using the mysql data source plug in with Table option to draw chart. I am getting below exception after writing
“No field name specified to use for x-axis, check your axes settings”
When i try to add filed name in axis tab, i could not add. Can you let me know how to draw bar graph?
Below is the data query which is getting data in 3 columns.
SELECT l.location_name, count(oi.quantity), oi.order_status from order_items oi, location l
where oi.location_id=l.location_id group by order_status;