Stacked bar chart from json data source

Grafana Time Series Panel
1

Hello,

using grafana 8.3.3.

Im trying to create a stacked bar graph of what our computer cluster is doing, i cant access the backend db directly, so i have written a flask/json wrapper for it.

If it helps, im looking to display the data like this, We have “job_types” , example gpu_compute, cpu_compute, failed_compute.
Different projects then use one of the job_types. so im looking to from a project stack the totals of each per project.

right now i have the json data coming back like this:

[
      {'datapoints':[2599, 1640131443.0],
                 [5553, 1640132067.0]],
  'target': 'BB_gpu_compute-complete'},
 {'datapoints':[2599, 1640131443.0],
                 [5553, 1640132067.0]],
  'target': 'BB_gpu_compute-failed'},
 {'datapoints':[4578, 1640131443.0],
                 [5553, 1640132067.0]],
  'target': 'BB_cpu_compute-complete'},
 {'datapoints':[65, 1640131443.0],
                 [115, 1640132067.0]],
  'target': 'BB_cpu_compute-failed'},
]

the value is in seconds.

i can see the data side by side if i use a gauged bar, but how do i need to format the data to do the stacked bar graph correctly.

Thanks
Kym

edit :: i release the time stamp was seconds not milli seconds and have fixed that

2

ok, i figured out how i can stack this data, using the columns/rows example here

Is there a way that i can define the colours for the stacked graph here aswell?