I’m trying to figure out how to have stacked time results for a query such as: SELECT __timeEpoch(time_stamp), retry_percent as value, config_name as metric FROM dbo.AER1600_eth_tcp_1 WHERE __timeFilter(time_stamp) ORDER BY time_stamp ASC There are 2 tables in question, that have the sa…

Hello, I think you should try with an INNER JOIN something like that : SELECT __timeEpoch(time_stamp), dbo.AER1600_eth_tcp_1.retry_percent as value, dbo.AER1600_eth_tcp_1.config_name as metric FROM dbo.AER1600_eth_tcp_1 INNER JOIN ON dbo.AER1600_eth_tcp_1.config_name = dbo.AER2200_eth_tcp.conf…

Will that show one set of data stacked behind the other? [image] viapass: SELECT __timeEpoch(time_stamp), dbo.AER1600_eth_tcp_1.retry_percent as value, dbo.AER1600_eth_tcp_1.config_name as metric FROM dbo.AER1600_eth_tcp_1 INNER JOIN ON dbo.AER1600_eth_tcp_1.config_name = dbo.AER2200_eth_tcp.…

So why is it giving a error of: mssql: Ambiguous column name ‘time_stamp’. Same reference to time_stamp didn’t throw and error before the join was attempted

Stacked results?

Grafana

viapass October 29, 2018, 7:42pm 4

No it’s just to get datas from another table which match with you primary columns,
But check the exact syntax to do your query.

Topic		Replies	Views
How to Join columns from two different tables from sql database and present it as a single table in grafana MySQL dashboard	1	10989	November 18, 2022
Display Stacked Series Time Series Panel	18	47286	May 3, 2021
Stacked Bar Chart from Table Values Grafana	12	20044	May 29, 2024
How to create stack chart in grafana Time Series Panel mysql	6	15289	June 4, 2020
Panel Table - Join queries don't work because different timestamp Grafana	0	559	September 17, 2020

Stacked results?

Related topics