Column data to tooltip

[bie]

• What Grafana version and what operating system are you using?
  10.3

• What are you trying to achieve?
  Additional information in tooltip

• How are you trying to achieve it?
  Adding a column with besides this _value

• What happened?
  Dont see the column data

• What did you expect to happen?
  See the column data in tool tip

• Can you copy/paste the configuration(s) that you are having problems with?

I have this table and I would like to be able to see the “baseline” information in the tool tip besides the value, how can I achieve that?

[sowdenraymond]

There is a feature request for this:

[feature-request] Labels/metadata on tooltips

[bie]

Oh, great, hope it will be available soon

[yosiasz]

You need proper column naming
value, time, metric

Mocking your data in my ms sql

select cast('2024-04-11 10:28:42' as datetime) as [time], 3339 as value, 'cspcd.cis_master.10189' as metric union
select cast('2024-04-11 15:33:18' as datetime) as [time], 2935 as value, 'cspcd.cis_master.10198' as metric union
select cast('2024-04-11 20:22:18' as datetime) as [time], 3489 as value, 'cspcd.cis_master.10217' as metric union
select cast('2024-04-15 10:55:34' as datetime) as [time], 2258 as value, 'cspcd.cis_master.10224' as metric 

and proper format selected Time series

when you choose Table as Format you don’t get the metric

[bie]

Im using influxdb and time series graph. I think that the column naming should be ok…

[bie]

@yosiasz when you see the baselines in the time series graph, the points are not connected, right?

[yosiasz]

in that case please provide sample data in csv or line protocol fornat to test things out in our influxdb

[bie]

Here is a csv sample:

#group,false,false,false,false,false
#datatype,string,long,dateTime:RFC3339,long,string
#default,_result,
,result,table,_time,_value,baseline
,0,2024-04-11T08:28:42.073Z,3339,cspcd.cis_master.10189
,0,2024-04-12T13:33:18.687Z,2935,cspcd.cis_master.10198
,0,2024-04-12T18:22:16.969Z,3489,cspcd.cis_master.10217
,0,2024-04-15T08:55:34.879Z,2258,cspcd.cis_master.10224
,0,2024-04-15T16:07:16.394Z,2992,cspcd.cis_master.10228
,0,2024-04-16T10:29:53.914Z,2085,cspcd.cis_master.10234
,0,2024-04-17T13:24:46.109Z,4315,cspcd.cis_master.10266
,0,2024-04-18T14:52:37.295Z,7870,cspcd.cis_master.10290
,0,2024-04-18T18:41:08.341Z,2852,cspcd.cis_master.10295
,0,2024-04-19T10:41:57.344Z,3472,cspcd.cis_master.10314

[yosiasz]

change Format to Time Series

[bie]

Not sure what that means…

[yosiasz]

are you using influxql or flux query language?

[bie]

Im using flux

[yosiasz]

from(bucket: "bie")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "bie_bie")
  |> filter(fn: (r) => r["tag1"] == "bie")
  |> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")  
 |> drop(columns: ["_start", "_stop", "_measurement", "tag1"])

change according to your bucket name and measurement.

[bie]

Can you please zoom in on the relevant time period?

[bie]

Still not able to see lines for graph in time series with column info in tooltip, using 10.3.0, only works with points. Hope [feature-request] Labels/metadata on tooltips · Issue #73989 · grafana/grafana · GitHub will solve the problem

[bie]

@sowdenraymond I tried with grafana 11.0.0 and newVizTooltips enabled but I still cant get a time series graph with lines with column info in tool tip. The closest I get is points: