Support for Rolling Time Windows
When querying datasets, you can now look up data for the "last 30 days" or "between 7 and 14 days ago". Simply specify a filter on a timestamp
or datetime
column with the newerThan
and/or olderThan
operators. Check out our docs here!
query {
eventsTableQuery(
filter: {
eventCreatedTime: {
newerThan: {days: 7},
olderThan: {days: 3}
}
}
orderBy: {eventCreatedTimeDate: desc}
groupBy: [eventType, eventCreatedTimeDate]
) {
eventType
eventTypeCount
eventCreatedTimeDate
}
}