I’m using the aggregate function in the API and it looks like the query requires a group by . But I don’t want any groupings. How do I accomplish that?
Hello @RobertG You’re right that it can feel a bit odd. In monday.com’s API, aggregate queries currently require a group by field. There isn’t a true “no grouping” option yet.
The usual workaround is to group by something that results in a single bucket, for example the board ID or another field that’s the same for all items you’re querying. That way you still get a single aggregated result without meaningful segmentation.
If your use case is blocked by this, it’s also worth submitting it as a feature request so the API team can track demand for ungrouped aggregates.
Dr. Tanvi Sachar
Monday Certified Partner, Tuesday Wizard