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:
some solutions will previews ?
thanks for your feedback
frenchy76
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
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
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'
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
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
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
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
