Monitor performance over time

A Grafana dashboard represents a view into the performance of a system, and each dashboard consists of one or more panels, which represent information about a specific metric related to that system.

To visually monitor the volume of taxi rides over time:

1. Create the dashboard

2. On the Dashboards page, click New and select New dashboard.

3. Click Add visualization.

   1. Select the data source that connects to your Tiger Cloud service. The Time series visualization is chosen by default.
   2. In the Queries section, select Code, then select Time series in Format.
   3. Select the data range for your visualization: the data set is from 2016. Click the date range above the panel and set:
      • From:
      • To:

4. Combine TimescaleDB and Grafana functionality to analyze your data

Combine a TimescaleDB [time_bucket][use-time-buckets], with the Grafana _timefilter() function to set the pickup_datetime column as the filtering range for your visualizations.

This query groups the results by day and orders them by time.

1. Click Save dashboard