How to add extra info in tooltips on Grafana Time Series dashboard based on SQL?

[mlubinsky]

I have a table with 4 columns:
date, name, num_value, comment.

I can plot Grafana time series using this SQL:
select date, name, num_value as " " from T

and applying transformation: Prepare Time Series → Format → Multi-frame time series.
The tooltip shows (date, name, value).

I would like to add to tooltip the content of column “comment” in my table T.
How to do it?

There is similar feature request created on Aug 29, 2023:

[feature-request] Labels/metadata on tooltips

Thanks!

[hunterstevenson]

I see so many people requesting this online. Seems like a no brainer feature. There doesn’t even seem to be a good workaround

[yosiasz]

looks it still needs some polishing but something is available in latest grafana v11

[bellpark]

Could you share how you achieved this? I’m trying to show text values in tooltips as well and this looks exactly like what I’m looking for.

[yosiasz]

the picture I posted above is exactly how I did it. what is your datasource

[bellpark]

Thanks for your reply. I tried replicating your query format:

SELECT  
    'foo' as comment, 
    33.7 as num_value, 
    'juicy' as metrics, 
    '2024-11-11' as time 
FROM issue_stats

But I can only see the timestamp and numeric values in the tooltip - the string values (comment, metrics) don’t show up. I’m using MySQL as my data source.

Am I missing something in the configuration? Do you have any additional settings or transformations applied to make the text values appear in the tooltip?

[condrove10]

The key here is setting the Query Type to Time Series; either way the feature is quite limiting. Maybe a conversion to string is required to display more information, either way is something that still needs to be worked on.