Tseesecake is a lightweight proxy for time-series query engines, supporting multiple database engines and storage providers, with a SQL dialect dedicated to time series
This implicit aggregation function is similar to DIFFERENCE but doesn't return the delta between the previous value and the current value but the division of this difference by the previous value.
SELECT
Instant,
Producer,
DIFFERENCE_RATIO(Produced)
FROM
WindEnergy
WHERE
Instant < '2023-01-01'
BUCKET BY
DAY
Globally, it's similar to #69 but the main SQL should have this aggregation
(
Produced
-
LAG(Produced)
OVER (PARTITION BY Producer ORDER BY DateTrunc('year', Instant) ASC)
)
/
(
LAG(Produced)
OVER (PARTITION BY Producer ORDER BY DateTrunc('year', Instant) ASC)
)
Same use case than DIFFERENCE should return the following table
This implicit aggregation function is similar to
DIFFERENCE
but doesn't return the delta between the previous value and the current value but the division of this difference by the previous value.Globally, it's similar to #69 but the main SQL should have this aggregation
Same use case than
DIFFERENCE
should return the following table