# Plugin histogram

**URL:** <https://community.grafana.com/t/plugin-histogram/63722>\
**Category:** Time Series Panel\
**Tags:** plugins\
**Created:** [April 8, 2022, 3:48pm UTC](https://community.grafana.com/t/plugin-histogram/63722 "2022-04-08T15:48:01Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![frenchy76](https://avatars.discourse-cdn.com/v4/letter/f/df705f/32.png) [@frenchy76](https://community.grafana.com/u/frenchy76)\
**Post date:** [April 8, 2022, 3:48pm UTC](https://community.grafana.com/t/plugin-histogram/63722/1 "2022-04-08T15:48:01Z")

</div>

hello,  
I use grafana 8.4.4 (i tried 8.4.5) and create panel with plugin Histogram.  
I made query (Postgresql database) which give 4 series .  
2 problems:

1. When i clic on serie’s name into legend of panel nothing change .
2. tooltip doesn’t work (no values etc)

some solutions will previews ?

thanks for your feedback

frenchy76

---

<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:** [April 8, 2022, 5:05pm UTC](https://community.grafana.com/t/plugin-histogram/63722/2 "2022-04-08T17:05:58Z")

</div>

hello

can you please provide sample data and we can try on our grafana?

```auto
create table #sample(id int, value varchar(50), metric int, waka datetime)

insert into #sample
select 1, 'cake', 4, '2022-04-08 13:00:00'

```

type of thing

---

<div class="post-metadata">

**Author:** ![frenchy76](https://avatars.discourse-cdn.com/v4/letter/f/df705f/32.png) [@frenchy76](https://community.grafana.com/u/frenchy76)\
**Post date:** [April 8, 2022, 7:37pm UTC](https://community.grafana.com/t/plugin-histogram/63722/3 "2022-04-08T19:37:29Z")

</div>

hi  
i don’t understand what you want try but i can give you precision  
my panel with histogram

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

if i want clic on “2120” to see only it then nothing change  
The tooltip don’t work also

Thanks

---

<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:** [April 8, 2022, 8:19pm UTC](https://community.grafana.com/t/plugin-histogram/63722/4 "2022-04-08T20:19:56Z")

</div>

images are nice but if you provide us sample data (since we do not have access to your database) it would help us answer your question quicker.

```auto
create table #sample(id int, value varchar(50), metric int, waka datetime)

insert into #sample
select 1, 'cake', 4, '2022-04-08 13:00:00'

```

---

<div class="post-metadata">

**Author:** ![frenchy76](https://avatars.discourse-cdn.com/v4/letter/f/df705f/32.png) [@frenchy76](https://community.grafana.com/u/frenchy76)\
**Post date:** [April 10, 2022, 10:21am UTC](https://community.grafana.com/t/plugin-histogram/63722/5 "2022-04-10T10:21:24Z")

</div>

i yosiasz

the sample data ,i think that i understand what you need 😉

_create table chronogram (heure timestamp,varname varchar(25),duree int)_

first serie :  
insert into chronogram (heure ,varname ,duree )  
values (‘2022-03-21 13:00:14’,‘op2250\_1\_tcy’,29),  
(‘2022-03-21 13:00:45’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:01:20’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:01:53’,‘op2250\_1\_tcy’,29),  
(‘2022-03-21 13:02:21’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:02:52’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:03:29’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:04:00’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:04:44’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:05:22’,‘op2250\_1\_tcy’,26),  
(‘2022-03-21 13:05:58’,‘op2250\_1\_tcy’,26),  
(‘2022-03-21 13:06:43’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:07:13’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:07:45’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:08:16’,‘op2250\_1\_tcy’,26),  
(‘2022-03-21 13:08:51’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:09:21’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:09:56’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:10:31’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:11:09’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:12:16’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:12:49’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:13:28’,‘op2250\_1\_tcy’,28),  
(‘2022-03-21 13:14:01’,‘op2250\_1\_tcy’,28),  
(‘2022-03-21 13:14:31’,‘op2250\_1\_tcy’,28),  
(‘2022-03-21 13:15:04’,‘op2250\_1\_tcy’,28),  
(‘2022-03-21 13:15:35’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:16:06’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:16:35’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:17:58’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:18:28’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:19:19’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:20:30’,‘op2250\_1\_tcy’,27),  
(‘2022-03-21 13:21:41’,‘op2250\_1\_tcy’,27),  
(‘2022-03-21 13:22:13’,‘op2250\_1\_tcy’,27),  
(‘2022-03-21 13:23:12’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:23:48’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:24:19’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:24:55’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:25:29’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:26:02’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:26:34’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:27:08’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:27:40’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:28:13’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:28:49’,‘op2250\_1\_tcy’,24),  
(‘2022-03-21 13:29:26’,‘op2250\_1\_tcy’,24)

second serie :

(‘2022-03-21 13:00:14’,‘op2250\_2\_tcy’,29),  
(‘2022-03-21 13:00:45’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:01:20’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:01:53’,‘op2250\_2\_tcy’,29),  
(‘2022-03-21 13:02:21’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:02:52’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:03:29’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:04:00’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:04:44’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:05:22’,‘op2250\_2\_tcy’,26),  
(‘2022-03-21 13:05:58’,‘op2250\_2\_tcy’,26),  
(‘2022-03-21 13:06:43’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:07:13’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:07:45’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:08:16’,‘op2250\_2\_tcy’,26),  
(‘2022-03-21 13:08:51’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:09:21’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:09:56’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:10:31’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:11:09’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:12:16’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:12:49’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:13:28’,‘op2250\_2\_tcy’,23),  
(‘2022-03-21 13:14:01’,‘op2250\_2\_tcy’,23),  
(‘2022-03-21 13:14:31’,‘op2250\_2\_tcy’,23),  
(‘2022-03-21 13:15:04’,‘op2250\_2\_tcy’,23),  
(‘2022-03-21 13:15:35’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:16:06’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:16:35’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:17:58’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:18:28’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:19:19’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:20:30’,‘op2250\_2\_tcy’,25),  
(‘2022-03-21 13:21:41’,‘op2250\_2\_tcy’,25),  
(‘2022-03-21 13:22:13’,‘op2250\_2\_tcy’,25),  
(‘2022-03-21 13:23:12’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:23:48’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:24:19’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:24:55’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:25:29’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:26:02’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:26:34’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:27:08’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:27:40’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:28:13’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:28:49’,‘op2250\_2\_tcy’,24),  
(‘2022-03-21 13:29:26’,‘op2250\_2\_tcy’,24)

the query A (format as = table) : SELECT  
“heure” AS “time”  
,duree as “op2250\_2\_tcy”  
FROM chronogram  
WHERE $\_\_timeFilter(“heure”) and “varname” =‘op2250\_2\_tcy’

the query B (format as = table) :  
SELECT  
“heure” AS “time”  
,duree as “op2250\_1\_tcy”  
FROM chronogram  
WHERE $\_\_timeFilter(“heure”) and “varname” =‘op2250\_1\_tcy’

thanks for answer

frenchy76

---

<div class="post-metadata">

**Author:** ![frenchy76](https://avatars.discourse-cdn.com/v4/letter/f/df705f/32.png) [@frenchy76](https://community.grafana.com/u/frenchy76)\
**Post date:** [April 10, 2022, 2:28pm UTC](https://community.grafana.com/t/plugin-histogram/63722/6 "2022-04-10T14:28:33Z")

</div>

hi  
a complement (an idea) at this topic … will it is possible in the futur to have a further bars for each bucket (ex: 2 bars for bucket of values 24 if query have 2 series ) ,like this (color for each serie)

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

Thanks for your replies

---

<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:** [April 11, 2022, 12:49am UTC](https://community.grafana.com/t/plugin-histogram/63722/7 "2022-04-11T00:49:55Z")

</div>

> [@frenchy76](#):
>
> insert

tres bien! Je vais essaye Lundi matin. 😉

This is one approach using bar chart with time series.

 ![image](https://us1.discourse-cdn.com/grafana/original/3X/7/0/703e3ede371d6f6d7823ef54a78b8e068ca47bc7.jpeg)

Also this is a good video to checkout

[![](https://img.youtube.com/vi/ky78RZ2f7oc/hqdefault.jpg "Grafana - Bar Chart with Multiple Series | How To Tutorial Example") ](https://www.youtube.com/watch?v=ky78RZ2f7oc)

---

<div class="post-metadata">

**Author:** ![frenchy76](https://avatars.discourse-cdn.com/v4/letter/f/df705f/32.png) [@frenchy76](https://community.grafana.com/u/frenchy76)\
**Post date:** [April 24, 2022, 9:57am UTC](https://community.grafana.com/t/plugin-histogram/63722/8 "2022-04-24T09:57:31Z")

</div>

hi yosiasz  
i was in holiday so sorry if i didn’t answer at your last post.

well your proposition is good but it is not what i want to have finally.

i think write this topic in “grafana plugin development” in order to have an issue ,an upgrade for the plugin histogramm…

thanks