Hello everyone,
I’m actually facing a problem with the Bar chart component in the 7.7.2 Version of Ignition. When i bind the data property to a SQL query, i have nothing displayed on the chart (as you can see int he attached image). However if i manually create a dataset with the Dataset Viewer it displays it well.
Is it a bug in Ignition or is there a way to bind this property?
In the lower left of your screen capture, it shows [0R x 3C] for the result of your binding. Are you sure you are getting data from your database?
The bar chart is looking for a label as a string. Then the next columns should be integers.
Try this code:
SELECT ACTION as Label, COUNT(ACTION) as ACTION_COUNT
FROM AUDIT_EVENTS
GROUP BY DATEPART(MONTH,EVENT_TIMESTAMP), ACTION
ORDER BY LabelCheers,
Chris