Table of Contents |
---|
On change only
Checking measurements when they has changed.
...
Code Block | ||
---|---|---|
| ||
SELECT * FROM asset_6458 GROUP BY TUMBLINGWINDOW(DD,365) // <- intervall in days! |
Possible intervalls:
DD - Days
HH - Hours
MI - Minutes
SS - Seconds
MS - Milli seconds