Data visualization by Grafana

[marlov8]

Grafana is data visualization platform with good visualization options. It can take CSV file as input. I do not have good skills to make it work other than simple pie chart. So i am asking help from community to try this & share templates.

[marlov8]

I managed to get Postgresql code,

results are wrong. Difference in results are shown in image. & application's start day hour is 00:00. Sum of hours for 19 June = 23.63, 24 in application

SELECT tag
  , date_trunc('day', offset_date) AS dt
   , COUNT(*) / 60::float AS hours
FROM
  (
    SELECT e.record_tags tag 
       ,   d.offset_date
    FROM  "public"."stt_records_20250621_124608_20250702123637" e
    CROSS JOIN 
          generate_series( e.time_started
                         , e.time_ended - '1 minute'::interval
                         , '1 minute'::interval
                         ) d(offset_date)
  ) t
GROUP BY tag
  , date_trunc('day', offset_date)
ORDER BY date_trunc('day', offset_date)
  , tag;

[marlov8]

I used seconds instead it works