Creating a Grafana dashboard and panel

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

Start by creating a new dashboard.

Grafana time-series panels include a tool that lets you filter on a given time range, called a time filter. Grafana allows you to link the user interface construct in a Grafana panel with the query itself using the $__timefilter() function.

This example of a modified query uses the $__timefilter() function to set the pickup_datetime column as the filtering range for your visualizations:

SELECT
  --1--
  time_bucket('1 day', pickup_datetime) AS "time",
  --2--
  COUNT(*)
FROM rides
WHERE $__timeFilter(pickup_datetime)

Copy

You can group your visualizations by the time buckets you've selected, and order the results by the time buckets as well. So, the GROUP BY and ORDER BY statements reference time.

For example:

SELECT
  --1--
  time_bucket('1 day', pickup_datetime) AS time,
  --2--
  COUNT(*)
FROM rides
WHERE $__timeFilter(pickup_datetime)
GROUP BY time
ORDER BY time

Copy

When you visualize this query in Grafana, you see this:

Expand image

You can adjust the time_bucket function and compare the graphs, like this:

SELECT
  --1--
  time_bucket('5m', pickup_datetime) AS time,
  --2--
  COUNT(*)
FROM rides
WHERE $__timeFilter(pickup_datetime)
GROUP BY time
ORDER BY time

Copy

When you visualize this query, it looks like this:

Expand image