Display time in bar gauge

  • What are you trying to achieve?
    I’m using Grafana via grafana.com and I have data that looks like this:

image

when I put it in the bar gauge it looks like this

image

I would like the bar length to indicate a ratio of how long until the time (and bar be gone when time has passed)

  • How are you trying to achieve it?

I’ve tried just about every transform I can think of so far. I’m using an override on the bar gauge to make it show “from now”. My working hypothesis is that I need to do the conversion via a transform so I have an integer number of minutes instead of a date/time… but I can’t figure out how to do that. Any suggestions welcome!

Thanks!

I want to add here. This is instant data from the Infinity data source. It’s an API so it’s can’t change the source data like I could with a SQL query.

you can reach out to another API using infinity like worldtime to get the current date and time, and then you can calculate the difference from now

what does the json payload from api look like? it just returns a date time datam?

Yep. That’s it. :slight_smile:

Please post data sample of json