# ClickHouse® tips #1: calculating aggregations after a date

DevFeed: [ClickHouse® tips #1: calculating aggregations after a date](<https://devfeed.tech/articles/clickhouse-tips-1-calculating-aggregations-after-a-date-18713.md>)

Original publisher: [Read original article](<https://www.tinybird.co/blog/tinybird-tips-1-calculating-aggregations-after-and-before-a-date>)

Author: Javi Santana

Published: 2021-01-26T00:00:00Z

Content type: tutorial

Language: en

Sources: [Tinybird](<https://devfeed.tech/sources/tinybird.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>)

Tags: [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [the-data-base](<https://devfeed.tech/tags/the-data-base.md>), [tips](<https://devfeed.tech/tags/tips.md>)

## AI overview

A Tinybird team tip about calculating ClickHouse aggregations after a date.

## Source excerpt

Tips and recipes to learn how to make the most of ClickHouse®, curated weekly by the Tinybird team. Part 1.