# Column data to tooltip

**URL:** <https://community.grafana.com/t/column-data-to-tooltip/121734>\
**Category:** Time Series Panel\
**Tags:** tooltip\
**Created:** [May 15, 2024, 7:48am UTC](https://community.grafana.com/t/column-data-to-tooltip/121734 "2024-05-15T07:48:03Z")\
**Posts on this page:** 16\
**Page:** 1

<div class="post-metadata">

**Author:** ![bie](https://avatars.discourse-cdn.com/v4/letter/b/58956e/32.png) [@bie](https://community.grafana.com/u/bie)\
**Post date:** [May 15, 2024, 7:48am UTC](https://community.grafana.com/t/column-data-to-tooltip/121734/1 "2024-05-15T07:48:03Z")

</div>

- 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?  
 ![image](https://us1.discourse-cdn.com/grafana/original/3X/b/5/b5064f5762507bc356101115394f64957d87da16.png)

![image](https://us1.discourse-cdn.com/grafana/original/3X/3/a/3a0aa8c5a6acbf382c57bb2ecae49668aae44fb3.png)

---

<div class="post-metadata">

**Author:** ![sowdenraymond](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/sowdenraymond/32/38541_2.png) [@sowdenraymond](https://community.grafana.com/u/sowdenraymond)\
**Post date:** [May 15, 2024, 8:12am UTC](https://community.grafana.com/t/column-data-to-tooltip/121734/2 "2024-05-15T08:12:16Z")

</div>

There is a feature request for this:

> <https://github.com/grafana/grafana/issues/73989>
>
> \*\*Why is this needed\*\*:
> 
> When showing data on state timelines, I need to be ab…le to see some clarifying info on hover to e.g. understand the cause of the state or how a potential issue was resolved.
> 
> \*\*What would you like to be added\*\*:
> 
> I want to be able to specify fields to show in the tooltip on hover. Example from the community panel call Gannt, where this feature is indicated:
> !\[image\](https://github.com/grafana/grafana/assets/88662219/554502bc-c3fb-4e85-a23c-a07fe4a1d30b)
> It is specified based on column name like this:
> !\[image\](https://github.com/grafana/grafana/assets/88662219/76ea3404-6c5c-4395-9094-35e10f220a91)
> 
> \*\*Who is this feature for?\*\*
> 
> This is relevant for all state timelines where quickly getting more info about a specific state is necesdsary without going to another dashboard for it.
> 
> Link to the forum topic, where other s show interest in a similar feature (or something that this feature would resolve): https://community.grafana.com/t/grafana-tooltip-customization/66221/10

---

<div class="post-metadata">

**Author:** ![bie](https://avatars.discourse-cdn.com/v4/letter/b/58956e/32.png) [@bie](https://community.grafana.com/u/bie)\
**Post date:** [May 15, 2024, 8:24am UTC](https://community.grafana.com/t/column-data-to-tooltip/121734/3 "2024-05-15T08:24:26Z")

</div>

Oh, great, hope it will be available soon 🙂

---

<div class="post-metadata">

**Author:** ![yosiasz](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/yosiasz/32/45847_2.png) [@yosiasz](https://community.grafana.com/u/yosiasz)\
**Post date:** [May 15, 2024, 1:46pm UTC](https://community.grafana.com/t/column-data-to-tooltip/121734/4 "2024-05-15T13:46:09Z")

</div>

You need proper column naming  
`value, time, metric`

Mocking your data in my ms sql

```auto
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 

```

 ![image](https://us1.discourse-cdn.com/grafana/original/3X/5/c/5c22df0e0cd82d42447d0506bc5b811f892052af.png)

and proper format selected `Time series`

![image](https://us1.discourse-cdn.com/grafana/original/3X/e/5/e56fbb29d5a65c72fcc47660f2d1fab6570467cc.png)

when you choose `Table` as Format you don’t get the metric  
 ![image](https://us1.discourse-cdn.com/grafana/original/3X/e/d/ed80de592a4de2a4e3f1c33456caa0f83241a813.png)

---

<div class="post-metadata">

**Author:** ![bie](https://avatars.discourse-cdn.com/v4/letter/b/58956e/32.png) [@bie](https://community.grafana.com/u/bie)\
**Post date:** [May 22, 2024, 6:10am UTC](https://community.grafana.com/t/column-data-to-tooltip/121734/5 "2024-05-22T06:10:50Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![bie](https://avatars.discourse-cdn.com/v4/letter/b/58956e/32.png) [@bie](https://community.grafana.com/u/bie)\
**Post date:** [May 22, 2024, 7:01am UTC](https://community.grafana.com/t/column-data-to-tooltip/121734/6 "2024-05-22T07:01:52Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![yosiasz](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/yosiasz/32/45847_2.png) [@yosiasz](https://community.grafana.com/u/yosiasz)\
**Post date:** [May 22, 2024, 1:41pm UTC](https://community.grafana.com/t/column-data-to-tooltip/121734/7 "2024-05-22T13:41:57Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![bie](https://avatars.discourse-cdn.com/v4/letter/b/58956e/32.png) [@bie](https://community.grafana.com/u/bie)\
**Post date:** [May 22, 2024, 1:53pm UTC](https://community.grafana.com/t/column-data-to-tooltip/121734/8 "2024-05-22T13:53:40Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![yosiasz](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/yosiasz/32/45847_2.png) [@yosiasz](https://community.grafana.com/u/yosiasz)\
**Post date:** [May 22, 2024, 2:02pm UTC](https://community.grafana.com/t/column-data-to-tooltip/121734/9 "2024-05-22T14:02:19Z")

</div>

change Format to Time Series

---

<div class="post-metadata">

**Author:** ![bie](https://avatars.discourse-cdn.com/v4/letter/b/58956e/32.png) [@bie](https://community.grafana.com/u/bie)\
**Post date:** [May 22, 2024, 2:09pm UTC](https://community.grafana.com/t/column-data-to-tooltip/121734/10 "2024-05-22T14:09:51Z")

</div>

Not sure what that means…

---

<div class="post-metadata">

**Author:** ![yosiasz](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/yosiasz/32/45847_2.png) [@yosiasz](https://community.grafana.com/u/yosiasz)\
**Post date:** [May 22, 2024, 2:15pm UTC](https://community.grafana.com/t/column-data-to-tooltip/121734/11 "2024-05-22T14:15:50Z")

</div>

are you using influxql or flux query language?

---

<div class="post-metadata">

**Author:** ![bie](https://avatars.discourse-cdn.com/v4/letter/b/58956e/32.png) [@bie](https://community.grafana.com/u/bie)\
**Post date:** [May 22, 2024, 2:16pm UTC](https://community.grafana.com/t/column-data-to-tooltip/121734/12 "2024-05-22T14:16:13Z")

</div>

Im using flux

---

<div class="post-metadata">

**Author:** ![yosiasz](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/yosiasz/32/45847_2.png) [@yosiasz](https://community.grafana.com/u/yosiasz)\
**Post date:** [May 22, 2024, 3:39pm UTC](https://community.grafana.com/t/column-data-to-tooltip/121734/13 "2024-05-22T15:39:39Z")

</div>

```auto
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.

 ![image](https://us1.discourse-cdn.com/grafana/original/3X/5/e/5e7231d71582164ea235fa51805e6a7065fb1d54.png)

---

<div class="post-metadata">

**Author:** ![bie](https://avatars.discourse-cdn.com/v4/letter/b/58956e/32.png) [@bie](https://community.grafana.com/u/bie)\
**Post date:** [May 23, 2024, 7:25am UTC](https://community.grafana.com/t/column-data-to-tooltip/121734/14 "2024-05-23T07:25:23Z")

</div>

Can you please zoom in on the relevant time period?

---

<div class="post-metadata">

**Author:** ![bie](https://avatars.discourse-cdn.com/v4/letter/b/58956e/32.png) [@bie](https://community.grafana.com/u/bie)\
**Post date:** [June 10, 2024, 2:04pm UTC](https://community.grafana.com/t/column-data-to-tooltip/121734/15 "2024-06-10T14:04:10Z")

</div>

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](https://github.com/grafana/grafana/issues/73989) will solve the problem

---

<div class="post-metadata">

**Author:** ![bie](https://avatars.discourse-cdn.com/v4/letter/b/58956e/32.png) [@bie](https://community.grafana.com/u/bie)\
**Post date:** [June 13, 2024, 7:33am UTC](https://community.grafana.com/t/column-data-to-tooltip/121734/16 "2024-06-13T07:33:17Z")

</div>

@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:

 ![Screenshot from 2024-06-13 09-25-07](https://us1.discourse-cdn.com/grafana/original/3X/7/7/77a306d2496b4af5b0830085933d85c0f45d7c96.png)
