How do I compare time ranges?
There is not currently a specific mechanism to comparing a value versus that same value one day or week ago. Instead, this function can be achieved by using union with a second stage that offsets the time, bringing data samples from "yesterday" forward to "today".
Example OPAL:
The query time window must include both yesterday and today for this to work.