- What Grafana version and what operating system are you using?
Grafana 9.3.2 on Ubuntu. - What are you trying to achieve?
I am using sqlite with Grafana and I am trying to plot a bar chart for each account of the accounts column, such that the x axis have accounts [agri, asr, bsg, …] and y axis have the JobsNumber [1-1000], and I have a bar for each JobState [CANCELLED, FAILED, TIMEOUT, COMPLETED] - How are you trying to achieve it?
I tried to do it with the bar chart, but I can’t plot multiple bars unless the bars are columns in my table
Another thing I want to do is to try to plot a pie chart that shows every account with the number of jobs of each state, but I am also unaware of how to do it.
This is an image of the table
and this is an image of the pie chart that appears to me
