Thanks for you reply. Unfortunately that does not solve my issue. The SINCE statement defines a time interval that specifically operate on the event timestamp afaik, not on arbitrary attributes.
Lets say our orderevent looks like this
OrderEvent{
timestamp
ordercode(unique)
eventtype(confirmed,picked,shipped,completed)
deliverydate(can be 8 days forward)
ordervalue
}
I can easily find orders created today by: SELECT UniqueCount(ordercode) WHERE eventtype = ‘confirmed’ SINCE today
But for finding what orders are due for delivery tomorrow I’d need something like:
SELECT UniqueCount(ordercode) WHERE dateOf(deliverydate) = tomorrow SINCE 8 days ago
(How many orders have been placed since last 8 days towards delivery tomorrow)
So in order to set up a dashboard that for instance display the amount of orders due for delivery ‘tomorrow’ would require the WHERE statement to allow similar date functions as SINCE. That way, we can do comparisons, test for equality etc. on epoch timestamps for arbitrary attributes.
Does that make any sense? If yes, would be happy if you could make it a feature request. Maybe others think it would be a good idea to be able to use conditional statements based on time or date.