Aggregate by date

sql

SELECT CAST(created_at AS DATE) AS day, COUNT(*) AS total
FROM events
GROUP BY CAST(created_at AS DATE)
ORDER BY day;

Explanation

Very common for dashboards and time-series summaries.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Advanced Aggregation

Compute multiple categorized totals in one query.

Open In sheetsqlsame section

Count unique entries in a column.

Open In sheetsqlsame section

Return the current date and current timestamp.

Open In sheetsql1 tag match

Return year, month, day, and other pieces from a date or timestamp.

Open In sheetsql1 tag match

Shift a date or timestamp forward or backward.

Open In sheetsql1 tag match

Remove the time portion from a timestamp.

Open In sheetsql1 tag match