Hi, Is there any way to stack different series of data. Please see attached screenshots. At the moment, series are displayed next to each other, not on the top of each other. Thanks [47_btTB7y] [57_jwpWqr]

Yes, combine your queries into one query. Use regex for the table name to combine those queries together. An example: [image] InfluxDB - one table with two metrics InfluxDB Select multiple tables using regex. Here I have included the cpu and derivative tables: [image] T…

Hi, Could you please explain based on my 2 queries because it sounds very complicated to me :frowning: SELECT sum(“value”) FROM “FRTMAP_TAGS_JC_DEPT_DEI” WHERE $timeFilter GROUP BY “year”, “week” and SELECT sum(“value”) FROM “FRTMAP_TAGS_JC_DEPT_DEX” WHERE $timeFilter GROUP BY “year”, “week” Th…

Like this I think. This part of the regex (I/X) matches both I and X - the only difference between the two table names. SELECT sum(“value”) FROM /FRTMAP_TAGS_JC_DEPT_DE(I/X)/ WHERE $timeFilter GROUP BY “year”, “week”

No quite :frowning: Error: error parsing query: error parsing regexp: missing closing ): FRTMAP_TAGS_JC_DEPT_DE(I at line 1, char 25

oh sorry - typo: SELECT sum(“value”) FROM /FRTMAP_TAGS_JC_DEPT_DE(I|X)/ WHERE $timeFilter GROUP BY “year”, “week” This: (I/X) should be (I|X) The pipe symbol means OR.

Thanks ! SQL works without any errors but graph still not displayed as stacked despite Stack box is ticked :frowning: [20_4EbxlF]

You can group by tag - if you have a unique tag value per table?

Sorry, I don’t follow you. I already Group By Year and month …

You don’t know what tags are? Here are some docs to learn more about InfluxDB: Key Concepts | InfluxDB OSS 1.3 Documentation Data Exploration | InfluxDB OSS 1.3 Documentation I just figured it out. You are not using time mode: [image] Stacking does not work in series mode. As you are grouping b…

Thanks. I use year, month and week time because I want to filter by week (Monday to Sunday), month (whole month, not 30 days with InfluxDB…)-… etc. InfluxDb and Grafana don’t give the flexibility to filter by full month … You can use 30 days … but some months are 30 days, 31 days, 28 and even 29 f…

Display Stacked Series

Grafana Time Series Panel

nthienan May 13, 2019, 10:31am 15

Hi,
Does anyone have solution yet?

Topic		Replies	Views
Grafana multi series graph MySQL templating , mysql	3	3591	April 4, 2018
Stacked Bar Chart from Table Values Grafana	12	20213	May 29, 2024
Stacking fields in graph panel Grafana	2	2177	June 14, 2018
How stack lines in new beta Time series panel? Grafana	2	870	May 10, 2021
[GRAPH] Problem stacking graphs Time Series Panel mysql	0	563	January 31, 2020

Display Stacked Series

Related topics