Influxdb2: Combining last + sum to get weekly values

[dieterlind]

Result with -1 day:

Result with -2 days:

Result with +1 day:

Conclusion:
Figues stay the same, just the labeling on the x-axes changes by days of timeshift