How to make bars side-by-side instead of stacked/overlapping

Grafana Time Series Panel
1

  • Version: v10.2.3 via web interface

  • Goal: a time series with a data point each week for each of several columns, displayed as a bar chart with several different side-by-side bars for each week.

  • How: The data is massaged into the columns i need, using a Grouping to Matrix, and then fed into a time series visualization.

  • Observed behavior: the panel options seem to offer only stacked or non-stacked overlapping. I don’t see any option for side-by-side at all.

  • Expected behavior: I should be able to select between stacked, side-by-side, etc. using the panel options.

  • Show config:

    image
    image1898×768 87 KB

  • errors: n/a

  • online instructions: n/a

I’ve already seen several older threads about this question like this one or this one. Those show how to do it in a bar chart visualization- i don’t want to use a bar chart visualization, I want to use a time series visualization, both because this is a time series and because i want to add other series as lines above the bars. Surely this is possible?

2

Something like this?

image
image1096×589 38.3 KB

3

More like this:
image
…but right now I’m just trying to manage the bars part without ditching a time series panel. the line will come later once i figure out how to get group to matrix to work with more than one column at once

1 Like
4

what is your data source? my recommendation, try to use as little transformation as possible. use transformation only when your datasource cant

for ex if your data is sql flavor, use pivot to matrix it

5

believe me, i would if I could, I can’t stand the transformation gui and would much rather do it in sql code. unfortunately this particular query needs to reference data from a google sheet, so i have to bring it in using the google drive data source and then do all my processing within grafana. (specifically, i need to bring in the sheets data and several columns of SQL data as two queries of a “mixed” data source, and then join & process them.)

1 Like
6

use business chart and marry those two disparate data sources using js

7

i’m definitely not doing that. it’s bonkers that this isn’t possible within the time series panel of vanilla grafana, if it isn’t then I will not try to do this in grafana at all

1 Like