Skip to main content

Comparison

A Comparison widget displays a summary table with the values of the selected data attributes in different groups.

Use the widget to compare multiple values from different categories within a single widget. For example, you can compare the average bill in restaurants from different areas of the city.

Case example: compare the average number of floors in buildings from different administrative districts:

Comparison widget

Main features

  • The values of comparison attributes are grouped in the widget by columns. As groups, you can select:

    • Territories:

      • Standard territories: regions, districts, settlements, and others.
      • Custom territories: first upload your own dataset with polygons and create a territory filter.
      • Territories specified in geofilters for the current dashboard scene.

      For more information on territory types, see the Geofilters section.

    • Data visualization elements in layers: H3, Contour, or Polygon. You can select elements by clicking them on the map. Example:

      Selecting a group by clicking on the map

    • Time ranges.

  • Each column contains the values of the selected comparison attributes (aggregation attributes). The attributes can belong to different data layers. As comparison attributes, you can select:

    • Numeric attributes: to count the number of values in the sample or to count values of the attributes using aggregation functions: total, mean, minimum, maximum value, median, and percentile.
    • Text attributes, logical attributes, or number of objects: to count the number of values in the sample.
  • The maximum number of groups (columns) in the widget is 100. The maximum number of comparison attributes is 100.

  • If necessary, you can edit the names of the comparison attributes displayed in the widget. The attribute names in the dataset will not change.

  • Changes in layer data are automatically reflected in the widget.

  • 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 Comparison widget
  1. Go to the Dashboards tab.

  2. Open the required dashboard.

  3. Open the scene using the arrows Left arrow and Right arrow. If the dashboard has only one scene, it will open automatically.

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

  5. Select the Comparison widget type.

  6. Specify the required parameters:

    • Groups: territories, visualization elements, or time ranges for which attribute values are calculated.
    • Comparison attributes: values displayed in the widget:
      • Layer: data layer containing the required attributes.
      • Aggregation attribute: attribute used to aggregate data and calculate the values.
      • Aggregation type: function used to calculate aggregation attribute values.
  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 display a value in the widget.

Parameters

General widget settings

Parameter
Description
Widget nameWidget name.

Groups

Parameter
Description
TerritorySelecting territories as groups for comparison. You can select:
  • Standard territories: regions, districts, settlements, and others. In the Find the territory field, search by names. You can specify search filters (for example, search only for regions).
  • Custom territories: first upload your own dataset with polygons and create a territory filter. In the Find the territory field, search by territory names that you specified in the properties when uploading the dataset.
  • Territories specified in geofilters for the current dashboard scene. To use them, click Synchronously with geofilters. When geofilters in the scene are changed, the groups in the widget are also changed automatically.
On the mapSelecting data visualization elements (H3, Contour, or Polygon) as groups for comparison. Select a layer with data visualization (the layer must be shown on the scene) and click the required elements on the map.
By timeSelecting time ranges as groups for comparison. Available only for layers from datasets containing attributes with the Date type.

To configure the period, specify the following:
  • 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.
The maximum number of ranges is 100.
GroupsTo change the order of groups (columns) in the widget, hold Drag and drop icon for the required group and drag it.

The feature is not available if you use the Synchronously with geofilters option or if you select the By time grouping.

Comparison attributes

Parameter
Description
LayerData layer containing the required comparison attributes:
  • For the Territory grouping, you can select any layer.
  • For the On the map grouping, the previously selected layer with the data visualization is used.
  • For the By time grouping, you can only select layers from datasets containing attributes with the Date type. Additionally, specify the attribute with the Date type that will be used for grouping.

To add another data layer, click Add layer. The feature is not available if you use the On the map grouping.

To change the order of layers and the corresponding attributes in the widget, hold Drag and drop icon for the required layer and drag it. To delete a layer, click Cross icon.

The maximum number of layers is 100.
Aggregation attributeAttribute, which value is aggregated and displayed in the widget:
  • Text attribute. You can select any attribute values from the data sample. When you modify the sample, the available attribute values are also changed.
  • Numeric attribute.
  • Logical attribute. Available values are Yes and No/Unknown.
  • Number of objects.

When the data value changes, the value in the widget is also updated automatically.

To add another data attribute, click Add attribute. To change the order of attributes (rows) of one layer in the widget, hold Drag and drop icon for the required attribute and drag it. To delete an attribute, click Trash icon.

The maximum number of attributes for each layer is 100.
Aggregation typeFunction used to calculate values of the comparison attribute (aggregation attribute) in each group.

For numeric attributes:
  • 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.
  • Quantity: number of objects in the sample.

For text attributes, logical attributes, and number of objects:
  • Quantity: number of objects in the sample.
FormattingFormat of the comparison attribute (aggregation attribute) value displayed in the widget. To change the format, click Edit icon and and select a format:
  • 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.
Attribute nameTo rename a comparison attribute (aggregation attribute) displayed in the widget, click Edit icon and enter a new value. The comparison attribute name in the dataset will not change.

What's next?