Multiple Time Range in dashboard - Specific day in previous week

[turpedo]

Hello,

Inline to what was asked in this, do you think what asked in this feasible?

Average of this week vs Average of Last week

Hello, We are using InfluxDB and I would like to know how can I compare a average of this hour vs the average of the same hour 7 days back. I have two queries below, that does gives me just the value but I can’t seem to find a way to do a math between two queries. I do not want to use an absolute value in the timerange as I want the system to use the current date & time and minus -7 days from now. SELECT mean(“value”) AS “Last 7 days” FROM “xxxxtablexxx”.“xxxtablexx” WHERE (“process” = ‘x’ A…