GraphQL Data APIs: Support for rollups by Week
When querying time series datasets, you can now easily group data by week. A new derived field <columnName>WeekDate
will return the first day of the week the time value falls within. With an ISO-standard default of MONDAY, the firstDayOfWeek
is configurable with an options configuration parameter.
query {
<tableName>Query(
groupBy: [eventCreatedTimeWeekDate]
orderBy: {eventCreatedTimeWeekDate:desc}
options: {firstDayOfWeek: SUNDAY}
) {
eventCount
eventCreatedTimeWeekDate
}
}