Pie Chart
  • 10 Mar 2023
  • 1 Minute to read
  • Dark
    Light

Pie Chart

  • Dark
    Light

Article Summary

The pie chart is a classic visualization that represents proportions of a whole using slices of a circle. Here are two examples of the same pie chart, one rendered as a classic pie and one rendered as a donut.

Reference Content

The following articles may be useful resources as you build your chart:

Creating a Pie Chart

Pie Chart Using a Single Dimension

To create a Pie Chart, you need to define:

  • the Metric you want to visualize
  • the Dimension(s) you want the metric to be sliced by

Here's a simple example:

We set the Dimension to rideable_type and the Metric to COUNT_DISTINCT(ride_id)which resulted in the following SQL query:

SELECT rideable_type AS "rideable_type",
       count(DISTINCT ride_id) AS "COUNT_DISTINCT(ride_id)"
FROM dbt_smukherjee.citibike_trips
GROUP BY rideable_type
ORDER BY "COUNT_DISTINCT(ride_id)" DESC

Pie Chart Using Multiple Dimensions

You can also include multiple dimensions in your pie chart. The result will be a by n combination of pie slices used in the grouping. Here's an example where we have two dimensions:

Here's the query Preset generated:

SELECT rideable_type AS "rideable_type",
       member_casual AS "member_casual",
       count(DISTINCT ride_id) AS "COUNT_DISTINCT(ride_id)"
FROM dbt_smukherjee.citibike_trips
GROUP BY rideable_type,
         member_casual
ORDER BY "COUNT_DISTINCT(ride_id)" DESC

Customizing your Pie Chart

You can customize your pie chart with the options in the Customize tab. Here's an overview of some of the options:

  • Legend
    • Show Legend: shows legend if this checkbox is ticked
    • Type: specify if the legend should be scrollable or a default plain one
    • Orientation: location of the legend
    • Margin: extra padding to add around the legend (in pixels)
  • Labels
    • Show Labels: shows a label for each pie slice if this checkbox is ticked
    • Puts Labels Outside: places labels on the outside of the pie slices if this checkbox is ticked (otherwise inside the slices)
    • Label Line: adds connecting lines between the pie slice labels and the slices themselves if this checkbox is ticked
    • Show Total: shows total metric value count across all the groups
  • Pie Shape:
    • Outer Radius: slider for specifying the radius of the overall pie chart
    • Donut: switches pie chart to a donut pie chart if this checkbox is ticked
    • Donut > Inner Radius: slider for specifying the radius of the inner circle in a donut chart



Was this article helpful?

What's Next