Plotting a multiple-bar Bar Chart using Grafana and sqlite plugin

  • 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