Display time in bar gauge

[Gerdofal]

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

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

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!

[Gerdofal]

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.

[sowdenraymond]

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

Storing current date into a variable

I am trying to achieve something fairly simple, and despite spending the last couple of hours browsing this forum I have not found my answer. Maybe I can’t search properly. Anyway, there you go: I’m building a dashboard plugged on an API (there is no db connection) and I need to send the current date (and eventually also current_date - n_days) as a parameter to the API. It is my understanding that I have to create a variable first. This is where I’m currently struggling, I’m selecting “Grafan…

[yosiasz]

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

[Gerdofal]

Yep. That’s it.

[yosiasz]

Please post data sample of json