Thanks a lot, it works great for the html selected timerange “today”, “yesterday”", but not for “last 2 days”.
I made some datapoints for my test:
select * from S0
name: S0
time value
2020-02-15T00:00:00Z 0
2020-02-15T03:00:00Z 1
2020-02-15T06:00:00Z 2
2020-02-15T09:00:00Z 3
2020-02-15T12:00:00Z 4
2020-02-15T15:00:00Z 5
2020-02-15T18:00:00Z 6
2020-02-15T21:00:00Z 7
2020-02-16T00:00:00Z 8
2020-02-16T03:00:00Z 9
2020-02-16T06:00:00Z 10
2020-02-16T09:00:00Z 11
2020-02-16T12:00:00Z 12
2020-02-16T15:00:00Z 13
2020-02-16T18:00:00Z 14
2020-02-16T21:00:00Z 15
2020-02-17T00:00:00Z 16
2020-02-17T03:00:00Z 17
2020-02-17T06:00:00Z 18
For “Last 2 days” i get S0.spread 2, but I expected 15.
Any suggestion, please?