Skip to main content

Pie and Doughnut Charts

Carly Hammond avatar
Written by Carly Hammond
Updated over 2 months ago

Summary

  • Widget group: Share Charts

  • Displays current snapshot or data over time? Current snapshot

  • Source data: Field (or metric)

  • Description: Either a circle (for Pie Charts) or a ring (for Doughnut Charts) divided into segments, so you can easily see proportions that make up a whole

  • Use case example: Count of Companies, split by Owner

Who is this article for?

  • Planhat Users who are designing Dashboard and Presentation Pages (e.g. CS Ops)

What are Pie and Doughnut Charts?

You're no doubt already familiar with Pie Charts, as they are a very simple and standard type of chart! They consist of a circle divided into segments - so, for example, you could look at the Conversation model (object) and split it by Conversation Type, so you could see that 25% of your Conversations are emails, and 15% are tickets, and so on.

Doughnuts are exactly the same, but with a hole in the middle! This is just a different design option - and in Presentation Pages you can layer Widgets on top of each other, and it works well to place a KPI Widget in the middle, as shown in the example below.


Why use Pie and Doughnut Charts?

Pie and Doughnut Charts are part of the "Share Charts" category, and are great for giving you a quick view of:

  • A snapshot of current data

  • Splitting data up based on qualitative categories

  • Displaying relative proportions (with less focus on absolute values, although they can be displayed)

For example, you could use a Pie Chart or a Doughnut Chart to analyze and visualize:

  • Which CSM is managing the most Companies

  • Whether most of the Companies in a portfolio have high or low Health Scores

  • What proportions of ARR come from different geographical regions

  • ... and many more use cases!

If we think about it the language of the Widget setup steps (more on this in the next section!), use cases include:

  • Count of Conversations, split by Type

  • Count of Tasks, split by Status ("overdue" / "not yet due" etc.)

  • Count of Companies, split by Owner

  • Count of Companies, split by Health Score

  • Count of Churn, split by Reason

  • Company model - sum of ARR, split by Phase

  • Company model - average Health Score, split by Owner

We bet you can think of even more examples!


How to set up a Pie or Doughnut Chart

The main steps are:

  • Choose a data model (object) - e.g. Company

  • Choose what the "whole" represents - either:

    • Counting the number of records - e.g. number of Companies

    • Or a property (from a choice of metrics and fields) plus an operation (sum, average, max or min) - e.g. sum of ARR

  • Choose what category property defines the segments/wedges - e.g. Company Phase

  1. Within a Dashboard or Presentation Page, click on "Share Charts" and then "Pie" or "Doughnut"

    You'll see a form that looks like this:

  2. In the "Setup" tab

    • Choose an "Object" (i.e. data model), e.g. Company

    • In "Value", choose between "sum", "average", "count", "max" and "min"

      • If you select "count", this will count the number of records of your chosen model (e.g. the number of Companies)

      • For all other operations, once you select the "Value", you also need to select a "Property" (a suitable field or metric) on the model - so, for example, you could do "sum of ARR", or "average of Health Score"

        • πŸ“Œ Note: Health Score is called "Hlth" in the dropdown

    • "Limit results (max no. of items)" - here you can specify the maximum number of segments in your Pie/Doughnut

    • "Split by category" is where you define the segments by choosing a suitable property (such as a list field). For example, if you have selected to count the Company model, you could potentially split by Phase, Industry or Region

    • In "Name", you can optionally enter a title for your Widget, which will display within the Widget

      • An alternative, particularly relevant for Presentation Pages, is to use a separate simple Text Widget if you would like different formatting options

    • In "Description", you can optionally add a description for your Widget

      • This will show in the Widget as a tooltip on an "i" icon

      • An alternative could be to use a simple Text Widget alongside your Pie/Doughnut Chart

    • In "Chart Type", you can switch chart types if you like - so, for example, if you started configuring a Pie and then change your mind to a Doughnut, you can swap here, and because they are similar chart types, any configuration you started setting up will remain

  3. In the "Customization" tab

    • At the top you'll see a group of checkboxes that you can select or deselect:

      • "Show Legend" - select if you would like to show the legend (key)

      • "Show count" - this adds the numerical values to the segments in the legend

      • "Show Values" - this adds the numerical values to the segments of the Pie/Doughnut itself

      • "Hide 'other'" - this excludes the "other" segment if applicable

      • "Show percentage" - this adds the % share values to the segments of the Pie/Doughnut itself

      • "Hide null / undefined" - this excludes the "null / undefined" segment if applicable

    • "Custom Segments"

      • This optional feature allows you group results in a chart and give each group an appropriate label. For example, if you create a Pie Chart showing Health Score distribution, you could define custom segments based on good/okay/bad Health Score - see screenshot below

      • In order to define custom segments, "Limit results" (in the "Setup" tab) needs to be blank (empty)

      • To define custom segments:

        • Click "+ Custom Segments"

        • Choose a segment "Label", specify which values should be included in that segment via "Include" (using commas to separate the values), and select a "Color"

        • Repeat the above two steps for as many segments as you need

    Click the image to view it enlarged

  4. Click "Add filters" in the top right of the chart preview if you'd like to add a filter

    • Here you can select a filter so that the Pie or Doughnut Chart shows specific data. So, for example, if you're building a KPI Widget showing the sum of Company ARR split by Phase, here you can specify that you only want to include SMB Companies, or only Enterprise Companies, and so on

    • You can either select from an existing "Company Filter" ...

    • ... or build an "Advanced Filter" from scratch

  5. When you've finished configuring your Pie or Doughnut Chart, click the orange "Add widget" button in the bottom right

If you want to go back and edit your Pie or Doughnut Chart later on, it's easy to do so. While viewing the Page in Edit mode, mouse over the Widget (Chart), and click on the pencil icon to open up the Widget setup form again.


Pro tips

We've already covered these earlier in this article, but just to highlight them:

  • Select the "Show percentage" checkbox (in the "Customization" tab) to show percentages on the Pie/Doughnut Charts themselves and the legend if applicable

  • You can configure custom segments (in the "Customization" tab) - here you can define your own groupings, choosing which values belong in each group/segment, and what the segment color/names should be

    • Ensure the "Limit results (max no. of items)" (in the "Setup" tab) is blanked out before you begin configuring custom segments

    • See the "How to set up a Pie or Doughnut Chart" section above for further details and a screenshot

  • In Presentation Pages, you can layer widgets - so try positioning a KPI Widget in the hole of a Doughnut Chart

  • If you start configuring a Pie or Doughnut and then want to switch your Chart to the other type, you can easily do that in the setup form (using the "Chart Type" field), without losing the configuration you have already set


Comparison with other Widgets

As we've discussed in this article, Pie Charts and Doughnut Charts are almost identical to each other! The only difference is the hole in the middle of a Doughnut Chart.

Pie and Doughnut Charts have some similarities to Radar Charts, which are also part of the "Share Charts" category. Radar Charts display pretty much the same data, but visualise the proportions in a slightly different way: rather than wedges, the Radar is a web-like representation, with points representing each category's contribution to the total. Note that you can’t define custom segments on this type of chart.

Here is the same data displayed in a Pie, Doughnut and Radar.

Click the image to view it enlarged

Did this answer your question?