I am experiencing difficulties when trying to display result from SQL query from database (result of the query is on image below. I would like to display these values in bar-chart (1st column should be category (i.e. label for X axis) and 2nd-last column should be value) - it means for one category, three bars would be displayed. I thought this is gonna be no-brainer (15 seconds to configure the bar chart), but I am failing to see what am I doing wrong (I had to hide values in column projectnumber).
Behavior of the bar char is as follows:
- I enter the SQL query to the data atribute
- click OK
- data atribute does not change at all - like I haven’t changed anything.
Please advise. Thank you in advance.