Hi, I am new to Grafana and the requirement I have is I need to plot graph from MySQL datasource where certain rows (may be just 2 or 3) and their metric should always be displayed on panel irrespective of time frame user selects. This is just like in google sheets we can freeze certain column/row and even if the user scrolls, that column/row is always displayed. I want something similar to this in Graph panel where values from 2-3 rows in table are always displayed on the extreme left and the rest of the data is plotted from recent records. Is it possible to do that?
I think so, but it would need to be done with a query.
Something like:
Query A: Very specific query with the data you want frozen.
Query B: Data for everything else.
Transformation: Merge table or Outer Join
Transformation: Organize columns to get the order you want
I’d also like to achieve this. doing 2 queries and joining still doesn’t seem to allow columns to be frozen. Any other idea?