Two dimensional time graph

Grafana Dashboards
1

Hello!

I have a questions regarding dashboards. I’m currently logging some events. They have an associated timestamp. So, something happened at X time.

I’m trying to achieve a two dimensional time graph, meaning I want to plot the events (multiple per day!) in regard to the day & time they were captured.
Is that possible?

Attached is a picture what I’m trying to achieve (I did it once in Google Sheets and have absolutely no idea, how I did it lol)

image
image1166×269 16.3 KB

(time format is: dd:mm:yyyy in that case)

I’m using Grafana v9.1.5.

Greetings,
Nils

2

Welcome @nilskruck

Yes, this is exactly what Grafana does (and it darn good at!). What is your datasource? Can you upload the data in CSV format?

3

Yeah, I can upload it in csv. Currently, I’m feeding it from a MySQL DB where there’s just one timestamp column (can be changed, obviously). Do you want a look at the csv from the example picture or the one, I’m currently creating?

Since I’m moving the process over, I can change a lot in my workflow! :slight_smile:

4

How about the CSV from the one from the picture?

5

Unfortunately, I’m only allowed to upload pictures. Here’s a photo:

image
image480×777 13.5 KB

(I removed the column on the right, as it contains information, I’m just not comfortable to share)

Here’s a link for the csv in my GDrive: https://drive.google.com/file/d/1-zDWlb1eTK4c33ulThftLQAV6FBzbYCl/view?usp=share_link

6

Hi @grant2!

Sorry, just saw your request. Was busy the entire weekend. :slight_smile:
You should have access to this sheet now.

7

@nilskruck

Sorry for the delay. OK, I think you can accomplish your goal using Grafana. I took your CSV data and put into Google Sheets, which I have configured as a data source in Grafana. I took your Hour data and converted it to decimal form as follows:

image
image838×158 20.5 KB

then plotted the data like this (small snippet of data only)…

image
image1638×869 52.7 KB

You could format the y-axis to look nicer (instead of 0 to 24, format as 00:00 to 24:00), but overall this approach should work.

1 Like
8

Hey @grant2!

No worries!
Thank you very much for your help. It looks exactly like I’d like to have it and it helps me a lot! :slight_smile:

I hope you had nice christmas (if you’re celebrating) and will have a nice new years!

Thanks again!