Skip to main content

Pie chart

A pie chart shows the ratio between the values as slices of a circle (donut). Each slice shows a value fraction of the whole (of 100%).

Use a pie chart to show the proportion of data attribute values.

Case examples:

  • show the distribution of the mean area of buildings built in different periods of time:

    Pie chart showing distribution of buildings by mean area
  • show percentage distribution of buildings with different purposes:

    Pie chart with distribution of buildings by purpose

Main features

  • The grouping attribute defines what data slices are displayed. As a grouping attribute, you can select:

    • Text attributes: for example, firm category, building purpose, and others.
    • Numeric attributes: for example, number of reviews, building area, and others. You can specify the number of ranges and their limits (and set ranges of different sizes) when creating a widget or editing it. In all ranges except the last one, the specified upper (right) limit is not included in the range.
    • Attributes with the Date type for grouping data by time ranges.
  • The aggregation attribute defines the size of slices. Aggregation is performed within one group or range. As an aggregation attribute, you can select:

    • Number of objects: to count the number of values in a group or range.
    • Numeric attributes: to count the value of this attribute within each group using aggregation functions: total, mean, minimum, maximum value, median, and percentile.
  • A pie chart is suitable for displaying a small number of aggregation attribute values, e.g. for the top 5 values. If there are more attributes and some of them take up a small part of the pie, they will be displayed on the chart as narrow slices that are difficult to see in the widget.

  • A pie chart should contain all grouping attribute values from the sample to display the correct percentages. If you selected the top 5 or top 10 values as the text grouping attribute when creating a widget or editing it, group the remaining values that are not in the top by selecting the Show other checkbox.

  • To see percentages, when creating a widget or editing it, select the Values in percentage checkbox.

  • You can click the chart slices to filter data by the selected attribute without editing the data sample. For more information, see the Filtering through widgets section.

  • If the filtering by territories or data attributes is applied on a dashboard scene, only the values that match the filters are displayed in the widget. For more information, see the Filtering data on a dashboard instruction.

Creating a widget

Example of creating a pie chart
  1. Go to the Dashboards tab.

  2. Open the required dashboard.

  3. Open a scene using the arrows Left arrow and Right arrow. If there is only one scene in the dashboard, it opens automatically when you open the dashboard.

  4. In the top menu of the dashboard, click Widgets icon.

  5. Select the Pie chart widget type.

  6. Specify the required parameters:

    • Layer: data layer used to build a chart in the widget.

    • Grouping attribute: attribute used to group data.

    • Grouping attribute value:

      • If you select a text grouping attribute, specify its values. You can select particular values from the data sample in the drop-down list or generate the top 5 or top 10 values from the sample (the top values are automatically calculated based on the aggregation attribute).
      • If you select a numeric grouping attribute, specify the number of ranges and their limits.
      • If you select an attribute with the Date type, specify the step size and period.
    • Aggregation attribute: attribute used to aggregate data and calculate the values. If you want to display only the number of values, select Number of objects.

    • Aggregation type: function used to calculate aggregation attribute values. Aggregation is performed within each group or range of data.

  7. Set the remaining widget parameters if necessary.

  8. Click Create.

The new widget is automatically added to the selected dashboard scene.

Note

When working with the uploaded data, make sure it contains at least one attribute to build a chart.

Parameters

General widget settings

Parameter
Description
Widget nameWidget name.
LayerData layer used to build a chart in the widget.
Change widget typeClick to select another widget type from the list. The configured widget parameters are saved.

Circle slices

Parameter
Description
Grouping attributeAttribute used to group data on the chart. The grouping attribute defines what data slices of a circle are displayed.
Available settings depend on the attribute type: text, numeric, or Date.
Grouping attribute value
(for text attributes)
Slices on the chart.

As value, you can select:
  • Any attribute values ​​from the data sample. When you modify the sample, the available attribute values are also changed. You can change the order of the slices on the chart if necessary.
  • The top 5 or top 10 values ​​from the data sample that are automatically calculated based on the aggregation attribute. To display the sum of the last value in the top and the remaining values in the sample below this position in the last slice on the chart, select the Show other checkbox.
Number of ranges
(for numeric attributes)
The number of ranges (slices) on the chart.

The available number of ranges depends on the data, the maximum number is 10. Ranges are calculated automatically, but you can set them manually by entering the required range limits. Also, you can set up ranges of different sizes. In all ranges except the last one, the specified upper (right) limit is not included in the range.

To add a range, click Plus icon. To delete a range, click Trash icon. To recalculate ranges after configuration, click Recalculate ranges.only.
Period settings
(for attributes with the Date type)
Slices on the chart.

As values, you can select the following:
  • Period:
    • Step: size of the time range (day, week, month, or year).
    • Start: beginning of the period.
    • End: end of the period. The specified upper (right) limit is included in the range.
  • Last: period before the current date to display the data. For example, the last 4 weeks or 1 year.
The maximum number of ranges is 100. Additionally, you can sort the slices on the chart: from the latest date to the oldest and vice versa.
Aggregation attributeNumber of objects or a numeric attribute used to aggregate data on the chart. Aggregation is performed within each group or range of data. The aggregation attribute defines the size of circle slices.
Aggregation typeFunction used to calculate aggregation attribute values in each group or range of data:
  • Sum: the sum of the values.
  • Mean: the mean value.
  • Min: the minimum value.
  • Max: the maximum value.
  • Median: the median value that is equal to or greater than 50% of the values in the group.
  • 80th percentile: the value that is equal to or greater than 80% of the values in the group.
  • 95th percentile: the value that is equal to or greater than 95% of the values in the group.
  • 99th percentile: the value that is equal to or greater than 99% of the values in the group.
FormattingFormat of the aggregation attribute value displayed in the tooltip when hovering over a slice on the chart. Available formats:
  • Without formatting: thousands are separated by commas, and the fractional part is separated by a point.
    Example: 12345.6789 → 12,345.6789.
  • 1.2345 → 1.235: rounding to thousandths (by the rounding rule to the nearest integer).
    Example: 12345.6789 → 12,345.679.
  • 1.2345 → 1.23: rounding to hundredths (by the rounding rule to the nearest integer).
    Example: 12345.6789 → 12,345.68.
  • 1.2345 → 1.2: rounding to tenths (by the rounding rule to the nearest integer).
    Example: 12345.6789 → 12,345.7.
  • 1.2345 → 1: rounding to integers (by the rounding rule to the nearest integer).
    Example: 12345.6789 → 12,346.
  • 1,200 → 1K: compact number notation with indication of magnitude. Only for numbers from 1000.
    Examples: 12345 → 12K, 1234567 → 1M.
  • 1,256 → 1,260: smart rounding to tens. The integer part is rounded to tens, and the fractional part is discarded. Only for numbers from 10.
    Example: 12345.6789 → 12,350.
  • 1,256 → 1,300: smart rounding to hundreds. The integer part is rounded to hundreds, and the fractional part is discarded. Only for numbers from 100.
    Example: 12345.6789 → 12,300.
  • 1,257 → 1,000: smart rounding to thousands. The integer part is rounded to thousands, and the fractional part is discarded. Only for numbers from 1000.
    Example: 12345.6789 → 12,000.
  • 0.12345 → 12.345 %: converting to percentages. The maximum number of decimal places is 3.
    Examples: 0.12345 → 12.345%, 1 → 100%.
  • 1,200,000 → 1.2E6: scientific format (exponential notation).
    Examples: 12345 → 1.235E4, 1 → 1E0.

Description

Parameter
Description
TextText displayed in the widget above the chart. The maximum number of characters is 5000.
H1Title (heading 1).
H2Heading 2.
H3Heading 3.
BBold.
IItalic.
UUnderline.
LinkInserting a link.
ColorText color. Select a color from the palette or specify it in the HEX format.

Appearance of the graph

Parameter
Description
ColorColor of slices on the chart. Select a color palette (a set of prepared color samples).

To change the slice color for a particular value or range, click the color in the legend and select a new one from the palette or specify it in the HEX format. To reset the color, click Cross icon. The color is also reset to the original value when the number of ranges or the grouping attribute is changed, but is not reset when the range limits are changed. Example:
Selecting a color

Additional settings

Parameter
Description
Show legendShows the values of the grouping attribute and the corresponding values of the aggregation attribute.
Values in percentageShows the values of the aggregation attribute as a percentage. Displayed in the tooltip when hovering over a slice on the chart.
Show sourceShows the name of the data layer, the grouping attribute and the aggregation attribute, and also the aggregation type.
Show empty rangesShows on the chart the ranges of values without data.

For numeric grouping attributes only.
Split sectorsShows gaps between slices of a circle.
Inner radiusThe radius of an empty circle inside the chart as a percentage from its size. A value of 0% corresponds to a pie chart without the empty circle in the center, 100% corresponds to a donut chart with the maximum radius of the empty circle in the center and narrow sectors.
Total valueShows the sum of the values of the aggregation attribute in the sample.
Mean valueShows the mean value of the aggregation attribute in the sample.
Minimum valueShows the minimum value of the aggregation attribute in the sample.
Maximum valueShows the maximum value of the aggregation attribute in the sample.
Median valueShows the median value of the aggregation attribute in the sample.
80th percentileShows the 80th percentile value of the aggregation attribute in the sample.
95th percentileShows the 95th percentile value of the aggregation attribute in the sample.
99th percentileShows the 99th percentile value of the aggregation attribute in the sample.
Total objects in the assetShows the number of objects in the sample used to calculate the values.

What's next?