Stacked results?

Grafana
1

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 same field names, dbo.AER1600)_eth_tcp_1 and dbo.AER2200_eth_tcp

How can I write a query for a dashboard that will stack the results for each of these tables??

2

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.config_name
WHERE __timeFilter(time_stamp)
ORDER BY
time_stamp ASC

Just correct column where you make the JOIN between the two table.
You work with MSSQL right ?

3

Will that show one set of data stacked behind the other?

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.

5

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