Aggregating by a column's median
When querying datasets, you've always been able to use common aggregations like avg
, sum
, max
, and min
. Now, you can also aggregate by any numeric column's median
. Check out our docs for more info.
query {
engagementTableQuery(
filter: {
videoViewStartTime: {
after: "2022-05-31T00:00:00"
before: "2022-11-01T00:00:00"
}
}
groupBy: [videoViewStartTimeYear, videoViewStartTimeMonth]
orderBy: [
{ videoViewStartTimeYear: asc }
{ videoViewStartTimeMonth: asc }
]
limit: 1000
offset: 0
) {
videoViewStartTimeYear
videoViewStartTimeMonth
videoViewDurationMedian
}
}