Videos / How to

Downsampling time series data with Plot.ly and ClickHouse

Mark Needham Principal Product Marketing Manager, ClickHouse

ClickHouse recently added support for the Largest Triangle Three Buckets (LTTB) algorithm, a powerful technique for downsampling time series data. And in this video, we'll learn how to use it with help from the SF Bay Area bike share dataset from Kaggle. Once we've imported the data, we'll learn how to visualise the number of free docks in Plot.ly for one of the bike stations using raw data, downsampling using the average function, and finally the Largest Triangle Three Buckets algorithm.

Follow us
X imageSlack imageGitHub image
Telegram imageMeetup imageRss image