I see this as a possible solution: GitHub - maxsivanov/influxdb-timeshift-proxy: Add timeshift feature to influxdb for grafana users with mathematics between metrics feature Follow up question: is there a workaround within Kapacitor?

What is the intended use of this ? The time shift is available in grafana.

I’m interested in this as well. There were a couple GitHub issues for it that were supposedly aggregated to this issue: [[feature collection]] requested Functions and query operators opened 10:48PM - 07 Mar 16 UTC (UTC) …

Hi, +1 for timeshift or lag to put comparaison in the same graph

Its also currently available if you are using Kapacitor see ShiftNode | InfluxData Documentation Archive

Does anyone have any approach they’ve taken to compare two separate time periods against each other with data captured with Influx? My personal solution was to pull the data via GET request, parse via powershell, dump to json and then compare two separate test periods with custom Power BI charts. I…

+1 for shift. For now I’m able to multiply a first by a last using a WHERE time > now() - 90m, in order to kludge multiplying a value for one hour by than of another, but it’s very kludgy. It would be easier to multiply “last x last but one” in some form.

+1 for timeshift. I’m displaying the energy output of my photovoltaic system in Grafana. I’d like to compare the monthly data with the same period of last year in one graf.

Look at these nice grafs and the comments. THAT’S THE REASON why I’d love to have timeshift supperted by InfluxDB

+15,6 for a timeshift function, it would be… awesome

Is a "time shift" or "lag" function on the roadmap?

Store

pauldix July 13, 2017, 8:25pm 5

Yes, timeshift is definitely on the roadmap. It will most likely make it into an early version of the new functional query language that we’re developing (details here). Then we’ll look at potentially adding it to the SQL version of the query language.

Topic		Replies	Views
Dual axis panel with timeshift in Grafana InfluxDB 2 influxdb , grafana , influxql , query , flux	3	358	April 16, 2024
Kapacitor moving timeStamp 24H Telegraf influxdb , kapacitor , influxql	2	972	October 27, 2017
Timeseries overlay for regression testing (or relative timeseries) Dashboards influxdb , grafana , influxql	4	2865	July 5, 2018
Changing timestamps in a query	2	477	December 18, 2020
Difference fonction with python under (Spyder) Telegraf influxdb , python	3	670	December 17, 2020

Is a "time shift" or "lag" function on the roadmap?

Related topics