What Grafana version and what operating system are you using? Grafana v10.3.3 (252761264e) What are you trying to achieve? I want to use part of my MySQL Result as a display name. For example, I have a simple MySQL query that returns the last ID and Date of a record like so: app_id app_date …

I have figured out a way to do this, I still think the whole DisplayName and variables is awful to work with… But I suppose with a ton of data sources it’s very general. If there is a way to basically filter down the “Query Inspector” result to get to it, that would be ideal… How far I’ve done this…

Pivot might be the way to go for this so that the column name is the dat and the row value is the numeric value SELECT * FROM ( select 478195 as app_id, '2024-04-10' as [app_date] ) AS SourceTable PIVOT ( MAX(app_id) FOR [app_date] IN ([2024-04-10]) ) AS PivotTable; [image]

Hi Yosiasz, I’m not entirely sure how that would work, my basic query is this: SELECT id AS app_id, created_at AS app_date FROM db.table ORDER BY id DESC LIMIT 1 In the pivot, you have FOR [app_date] IN ([2024-04-10]) but i wouldn’t know the date, the date is dynamic from the table itself, it’s t…

[image] yosiasz: group by matrix transfornation This is a really nice clean solution, works for this situation, thank you!

How to use a MySQL Query result as a variable in DisplayName

Grafana MySQL

yosiasz April 11, 2024, 10:45am 5

You can then uae dynamic query.

Or try group by matrix transfornation

Topic		Replies	Views
Dashboard variable: how to separate display name and value? Dashboards	8	3030	August 27, 2024
Change Grafana query dynamically based on user inputs mysql	7	16761	July 4, 2024
Can I use column value from mysql query as panel title? MySQL	10	7100	August 2, 2024
Using Variables to dynamically select Columns in MySQL Grafana templating	12	12195	July 5, 2023
Pass value from query variable to a custom dashboard variable Grafana dashboard-variables , sql	2	1019	June 10, 2024

How to use a MySQL Query result as a variable in DisplayName

Related topics