Plugin histogram

frenchy76 · April 8, 2022, 3:48pm

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:

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

some solutions will previews ?

thanks for your feedback

frenchy76

yosiasz · April 8, 2022, 5:05pm

hello

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

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

frenchy76 · April 8, 2022, 7:37pm

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

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

Thanks

yosiasz · April 8, 2022, 8:19pm

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.

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'

frenchy76 · April 10, 2022, 10:21am

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

frenchy76 · April 10, 2022, 2:28pm

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)

Thanks for your replies

yosiasz · April 11, 2022, 12:49am

tres bien! Je vais essaye Lundi matin.

This is one approach using bar chart with time series.

Also this is a good video to checkout

frenchy76 · April 24, 2022, 9:57am

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