Column chart

A column chart displays the data values ​​as vertical columns.

Use a column chart to compare the values ​​of a certain data attribute in different groups or ranges.

Case example: compare the mean values ​​of number of floors in buildings with different purposes:

Main features

• The X-axis displays groups of data values. You can select one grouping attribute or select two attributes to create a chart with grouping by two levels. For both levels, you can use the following types as grouping attributes:

  • 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 when creating a widget or editing it. If you need to use a continuous scale and automatically set equal ranges of values ​​(set a step size), use a histogram.

• To compare values ​​of a certain attribute by two parameters, use grouping by two levels. For example, you can compare the number of firms with different legal forms that belong to different categories:

  

  When grouping by two levels:

  • Data is grouped on the chart based on the first grouping attribute. Each group contains multiple columns that show aggregated values ​​based on the second grouping attribute.
  • The X-axis shows the values ​​of the first grouping attribute.
  • The widget legend shows the values ​​of the second grouping attribute.
  • When you hover over the chart columns, the tooltip shows aggregated values ​​based on the second grouping attribute for each group of values.

• The Y-axis displays aggregated values ​​for each group. The column length depends on the value. Aggregation is performed within one group or range. If you select two grouping attributes, values ​​are calculated for each column in the group. As an aggregation attribute, you can select:

  • Number of objects: to count the number of values ​​in a group or a range.
  • Numeric attribute: to count the value of the attribute within each group using aggregation functions: total, mean, minimum, maximum value, median, and percentile.

• Instead of a column chart, you can use a bar chart: they differ only in the orientation of the axes.

• You can click the columns to filter data by the selected attribute without editing the data sample. For more information, see the Filtering data through widget instruction.

Creating a widget

1. Go to the Dashboards tab.

2. Open the required dashboard.

3. To open a scene, use the arrows and . 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 icon.

5. Select the Column chart widget type.

6. Specify the required parameters:

   • Layer: data layer that is used to build a graph on the widget.

   • Grouping attribute of the first level: attribute that is used to group data.

   • Grouping attribute value of the first level:

     • If you select a text grouping attribute, specify its values. You can select particular values ​​from the 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.

   • Aggregation attribute: attribute that is 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 that is 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.

A new widget is created and automatically added to the selected dashboard scene.

Note

When working with the uploaded data, make sure that at least one attribute is specified in it to build a graph on the widget.

Parameters

General widget settings

Parameter	Description
Widget name	Widget name.
Layer	Data layer that is used to build a graph on the widget.
Description	Text description of the widget. You can format the text: customize headings; make the text bold, italic, or underline the text; add a link; select the text color from the palette or specify it in HEX format.
Change widget type	Click to select another widget type from the list. The configured widget parameters are saved.

X-axis

Parameter	Description
Grouping attribute (first level)	Attribute that is used to group data on the graph. Attribute values are displayed on the X-axis.
Grouping attribute value (first level)	If you select only one grouping level: vertical columns that are displayed on the graph. If you select a second grouping level: the attribute that is used to form groups of the columns on the chart. As value, you can select: Any attribute values ​​from the sample in the drop-down list. You can change the order of the columns on the graph if necessary. The top 5 or top 10 values ​​from the 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 column on the graph, select the Show other checkbox (can be used only when you select one grouping level). For text grouping attributes only.
Number of ranges (first level)	If you select only one grouping level: the number of ranges (vertical columns) that are displayed on the graph. If you select a second grouping level: the ranges that are used to form groups of the columns 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. The specified upper (right) limit is not included in the range. To add a range, click icon. To delete a range, click icon. To recalculate ranges after configuration, click . For numeric grouping attributes only.
Grouping attribute (second level)	Attribute that is used to build vertical columns within each group on the graph. To add a second grouping attribute, click Add second grouping level.
Grouping attribute value (second level)	Vertical columns that are displayed within each group on the graph. As value, you can select: Any attribute values ​​from the sample in the drop-down list. You can change the order of the columns on the graph if necessary. The top 5 or top 10 values ​​from the 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 column on the graph, select the Show other checkbox. For text grouping attributes only.
Number of ranges (second level)	Number of ranges (vertical columns) that are displayed within each group on the graph. 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. The specified upper (right) limit is not included in the range. To add a range, click icon. To delete a range, click icon. To recalculate ranges after configuration, click . For numeric grouping attributes only.

Y-Axis

Parameter	Description
Aggregation attribute	Number of objects or a numeric attribute that is used to aggregate data on the graph. Aggregation is performed within each group or range of data. Attribute values are displayed on the Y-axis.
Aggregation type	Function that is 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.

Color

Parameter

Description

Color

Color according to which columns on the graph are colored. If you select two grouping levels, you can only select a color scale. Columns are colored based on the second grouping attribute. If you select only one grouping level, different color settings are available, depending on the type of grouping attribute (text or numeric): For text grouping attributes: selecting a color scale (a set of prepared color samples). For numeric grouping attributes: you can select a single color for all columns from the palette or specify it in HEX format.

Appearance of the graph

Parameter	Description
Show axis titles	Shows the labels of the X and the Y axes on the graph. By default, names of the selected attribute values ​​are shown. To change the axes labels on the graph, enter new values in the X-axis and the Y-axis fields. The maximum number of characters is 50.
Labels	Shows the attribute values ​​on the X and the Y axes.
Axes	Shows the axes on the graph.
Grid	Shows a grid on the graph.

Additional settings

Parameter	Description
Show legend	If you select one grouping attribute: shows the values ​​of the grouping attribute and the corresponding values ​​of the aggregation attribute. If you select two grouping attributes: shows the values ​​of the second grouping attribute and the corresponding values ​​of the aggregation attribute. For text grouping attributes only.
Values ​​in percentage	Shows the values ​​of the aggregation attribute as a percentage. For text grouping attributes only.
Show source	Shows the name of the data layer, the grouping attributes and the aggregation attribute with the corresponding axes, and also the aggregation type.
Show empty ranges	Shows on the graph the ranges of values ​without data. For numeric grouping attributes only.
Total value	Shows the sum of the values ​​of the aggregation attribute in the sample.
Mean value	Shows the mean value of the aggregation attribute in the sample.
Minimum value	Shows the minimum value of the aggregation attribute in the sample.
Maximum value	Shows the maximum value of the aggregation attribute in the sample.
Median value	Shows the median value of the aggregation attribute in the sample.
80th percentile	Shows the 80th percentile value of the aggregation attribute in the sample.
95th percentile	Shows the 95th percentile value of the aggregation attribute in the sample.
99th percentile	Shows the 99th percentile value of the aggregation attribute in the sample.
Total objects in the asset	Shows the number of objects in the sample that is used to calculate the values.

What's next?

• Get to know more about other Widgets types.
• See available Operations with widgets.
• Quick start.
• Get to know how to work with Data and Data visualization.
• Get to know more about Layers, Dashboards, and Scenes.
• Get to know prepared Analytics presets.