Hello, can you tell me how the code has to be so that I can convert seconds in Grafana and display them in hours and minutes? The background is as follows: My Wihtings Sleep Sensor Mat gives me the daily bedtime in seconds. So e.g. 24800 seconds would be 6.8 hours. But I would rather have an outpu…

Hi @damrak2022 , Thanks for opening this post. Did you try the option “Standard Option” on the right side of the panel? If you go into “unit” it will open a drop-down list. Select Time from that and then select hours (h) [image] Let us know if this helps.

I set it up like this and my panel looks like this: [Bildschirmfoto 2023-03-01 um 19.35.07] In my Withings app, the values look like this: [IMG_9DF6A6D8F7C7-1] [IMG_62A5FC5DE079-1] [IMG_74759855F4C9-1] I think that’s going in the right direction, but the question now is how do I display the …

@grant2 can you please take a look and provide some suggestions if possible :smiley:

Is the problem just to have 6.72 hours dispayed at 6h34m (or 06:34)? Wouldn’t a custom unit like this work? [image]

I can’t set time:hh:mm under unit. For me there is only duration hh:mm:ss and then the result is completely wrong. Even if I enter it by hand, it is completely wrong. [Bildschirmfoto 2023-03-01 um 20.55.20]

@damrak2022 I tested on some of my data and you are correct in that the HH:MM values are not correct. Here is some data that I have, which is in hours: [image] and here is that same data with the unit duration:(hh:mm:ss) [image] Basically, it thinks that my units were seconds, so 14.9 second…

My flux request looks like this everywhere. Can you please explain to me what I have to change here, because unfortunately I’m not that fit yet. The values that I record are in Unix format. see the screenshot [Bildschirmfoto 2023-03-19 um 16.16.34] [Bildschirmfoto 2023-03-19 um 16.20.00]

@damrak2022 What is the unit of measure for these values? Newtons? Seconds? Minutes? Nautical miles? [image] I am trying to understand how the above output relates to your originally posted query, i.e. import "timezone" option location = timezone.location(name: "Europe/Berlin") from(bucket: …

Value is the duration a device is switched on measured in minutes.

OK, so if it’s in minutes, you need to convert it using a map() function to convert it to seconds, because (as I concluded in the original post above), you need your Flux query to return the value in seconds, then in Grafana use the unit duration:(hh:mm:ss). See below and see if that works for yo…

Output seconds in hours/minutes - no date

Grafana Dashboards

grant2 March 19, 2023, 9:38pm 15

In the map function, instead of 60 try writing as 60.0 and see if the same error message appears.

Topic		Replies	Views
Grafana dashboard, seconds to HH hours MM minutes format Dashboards influxdb , dashboard	2	1799	August 15, 2023
Output seconds to hh Hour mm Min format Grafana time-selection	6	1815	February 21, 2024
Display of the time recording of individual devices Dashboards	21	1647	April 24, 2023
Calculate HH:MM from decimal time within Grafana... transform, override or other? Grafana	1	3566	November 3, 2020
Gauge Panel Shows hh:mm:ss, but I only want hh:mm Grafana	0	799	November 19, 2020

Output seconds in hours/minutes - no date

Related topics