Oct 04, 2022

You can now explore and analyze time series data in Tinybird

Visualize and analyze in real time any data source with a timestamp using SQL WHERE, GROUP BY, and HAVING filters.
Mariana Racasan
Product Marketing Lead

Time series data is everywhere, from weather forecasts to stock prices, shopping transactions, or usage logs. In fact, events data basically always carry a timestamp. And when you’re developing new data products or maintaining existing ones on top of time series data, you find yourself wanting a way to explore it, understand its patterns, and investigate problems.

Visual interfaces - like a simple line or bar chart - give you the power to understand the shape of a time series curve and how variables are influenced by time. Does my web traffic change at different times or dates? When does my infrastructure usage surge? Where do these anomalies in my IoT data originate? What is the average P99 latency of my endpoints requests throughout the day? All of these questions have answers that can be discovered through visual time series exploration.

Introducing the Time Series UI

We want to help Tinybird users get more out of their time series data, and so we’re thrilled to introduce the Time Series UI in Tinybird. Time Series lets you visually explore and analyze data sources with a date/time column, filter and group them by selected columns, or simply monitor changes every second, so you can better understand what’s going on in real time.

The beauty of the Time Series UI is that it leverages the power of SQL - and all of the filtering, grouping, and aggregating that comes with it - while giving you a visual, even beautiful, representation of the result.

And it updates in real time, as soon as new data hits your Tinybird data sources.

An animation showing time series visualization using SQL filters
You can visually analyze any time series data source in Tinybird using SQL filters

What you can create with the Time Series UI

With the power of SQL and the beauty of time series charts at your fingertips, you can explore and analyze time series data in nearly countless ways. Here are a few ideas to help you get started.

Identify which of your endpoints consume more data

Data Source: tinybird.pipe_stats_rt

Visualize: sum(read_bytes)

Group by: pipe_name

Find errors in your APIs

Data Source: tinybird.pipe_stats_rt

Visualize: count()

Where: status_code >= 400

Group by: pipe_name

Monitor average ingestion duration

Data Source: tinybird.datasources_ops_log

Visualize: avg(elapsed_time)

Group by: datasource_name

See which blog articles people are reading right now

Note
The following uses the Web Analytics Starter Kit

Data Source: analytics_events

Visualize: count()

Where: JSONExtractString(payload,'href') like ‘%blog%

Group By: path(JSONExtractString(payload,'href'))

Time Series is available for all Tinybird users

When you create a new Time Series in your Tinybird workspace, the rest of your team will automatically gain access to it.

You can also generate a public URL to share the visualization outside your team. Those with access to the public URL can explore the chart but won’t be able to change the original data source, filters, or groupings.

An animation showing how to share a time series visualization with a public link
You can share your time series visualizations within your organization, or publicly.

Time Series is now available for all Tinybird users. We hope it helps you in your journey building real-time applications on top of time series data. Give it a try, and if you like it, share your experience wherever you scroll (We see you, lobste.rs). If you think it could be better, we’d love to hear about it in Slack.

Do you like this post?

Related posts

Tinybird is out of beta and open to everyone
How we processed 12 trillion rows during Black Friday
Using Tinybird for real-time marketing at Tinybird
$30M to lead the shift to real-time data
A new dashboard for Tinybird Analytics
Investigating Performance Bottlenecks With SQL & Statistics
Announcing Tinybird Charts: Fast Real-Time Charts, Even Faster

Tinybird

Team

Jun 12, 2024
Tinybird connects with Confluent for real-time streaming analytics at scale

Tinybird

Team

Jul 18, 2023
Best practices for timestamps and time zones in databases
Real-time Data Visualization: How to build faster dashboards

Build fast data products, faster.

Try Tinybird and bring your data sources together and enable engineers to build with data in minutes. No credit card required, free to get started.
Need more? Contact sales for Enterprise support.