Given 1 table in panel1 with column names(A,B,C) and similarly a table 2 in panel 2 with columns(A,B,C), we have three-three different queries to get the data for the columns ,in output a single table with column (A,B,C), with entries from table 1 first, and following them entries of table 2, how can this be achieved?
try the merge transformation
I am new to grafana and unable to apply merge transform, while trying to so i get option btw annotation and query results, i select query results, then it gives me option to select only one query, I am not able to figureout where to add the other query in which it is needed to be merged.
I have google cloud monitoring as my data source, so i cannot input the data like u did in query B.
Can you share how your tables look like (sanitized if needed)? Do you have two queries in one panel, or two different panels?
Its a bit difficult to provide the table view, but let me elaborate the structure. There are 2 panels, named A,B, both the panels contain 3 queries, and each query yield one column, so in the output we have k1,k2,k3, three columns, with 1 entry each, in the output I want a merged table where table from panel 1, table from panel 2 have their entries one after the other in columns k1,k2,k3
This is the output table required, in input i have one panel, that contains details about allocation and utilization of RAM, Panel 2 consists for CPU and Panel 3 for storage, so how to merge these 3 panels in one to get this as the output.
Unfortunately, you cannot merge data from two panels. You’d have to duplicate the queries (you can have two queries in one panel) and then merge transformation suggested by sowdenraymond should work.
if I have input table as
and in output I want a table like
then what can i do
why do you have it that way in the first place?
Its actually I am retrieving the allocation n utilization data for RAM and storage sperately and then want to merge it like that