Thanks, I missed it.
In the meantime I was able to accomplish what I needed.
For the relative time I set “0s” in all the panels, and as time shift “0d/d”, “0M/M”, “0y/y” depending on what I wanted to display.
Now I have the last problem: In a panel I want to show all the result from the beginning till now, grouped by year (I use Mysql).
It’s strange the result I get, even without setting anything as relative time:
As you can see I have these as last value for each year:
2019-12-20 01:00:00 with 50908 and 2020-12-19 01:00:00 with 54066
But I have no data for the 2019, and several data till now in 2021. This is my table, from the beginning till now (a row per each hour):
Timing | Avg | Yearly
2020-12-04 17:00:00 | 3.98 | 47804.2
..............
2020-12-19 00:00:00 | 3.75 | 50908.3
2020-12-19 01:00:00 | 5.24 | 50918.4
..............
2020-12-31 23:00:00 | 3.3 | 54065.9
2021-01-01 00:00:00 | 3.25 | 2.3
..........
2021-06-02 13:00:00 | 4.32 | 32178.5
2021-06-02 15:00:00 | 4.6 | 32489.5
This is what I should have, plotted from the same DB with this instruction:
SELECT AVG(Avg), MAX(Yearly), YEAR(Timing) AS Year FROM historic GROUP BY YEAR(Timing) ORDER BY Timing
Avg | Yearly | Year
4.50 | 54065.9 | 2020
4.32 | 32489.5 | 2021
