Column chart | Urbi Pro | Urbi Documentation
Urbi Pro

Column chart

A column chart displays the values ​​of different metrics as vertical bars.

Use a column chart to compare the values ​​of a certain data attribute. Case examples: compare the number of firms from different categories of food service; compare the number of restaurants with different seating capacity values.

An example of a column chart comparing the number of firms from different categories:

Column chart
  • Suitable for text attributes that display data categories (e.g. building purpose).

  • Suitable for numeric attributes (e.g. building area). To display data as columns, specify the number of ranges and their limits in the Number of ranges field when creating a widget or editing it. You can set up ranges of different sizes. The specified upper limit is not included in the range.

    If you need to use a continuous scale and automatically set equal ranges of values ​​(set a step size), use a histogram.

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

Example of creating a column chart
  1. Go to the Dashboards tab.
  2. Select the required dashboard.
  3. Click Layers icon.
  4. Click Layer menu icon next to the required layer and select Create widget.
  5. Set the widget parameters.
  6. Click Create.

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.

  • Widget name: name of a new widget.

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

  • Attribute: data attribute that is used to build a graph on the widget.

  • Different graph settings are available, depending on the type of data attribute (text or numeric).

    • For text attributes:

      • Color: selecting a color scale (a set of prepared color samples) according to which elements on the graph are colored.
      • Number of values: number of attribute values that are displayed on the graph. The top 5 and top 10 values from the data sample are available.
      • Show other: shows the sum of the last value and the remaining values below this position at the last position in the top.
      • Values ​​in percentage: shows the percentage distribution of attribute values.
      • Show legend: shows the attribute values and the number of attribute data values.
    • For numeric attributes:

      • Color: selecting a color according to which elements on the graph are colored. You can select a color from the palette or specify it in HEX format.

      • Number of ranges: number of ranges with data that are displayed 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. The specified upper 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.

  • 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 RGB, HSL, or HEX format.

  • Appearance of the graph:

    • Labels: labels of the attribute values on the graph.
    • Axes: drawing axes on a graph.
    • Grid: drawing a grid on a graph.
  • Additional settings: additional settings of data display on the widget. Available options depend on the type of data attribute.

    • For text attributes:
      • Show source: shows the data layer name and the attribute name that the graph is based on.
      • Statistics: data aggregation in the data sample.
        • Total objects in the asset: number of objects in the data sample, which are used to calculate the values.
    • For numeric attributes:
      • Show source: shows the data layer name and the attribute name that the graph is based on.
      • Show empty ranges: shows on the graph ranges of values without data.
      • Statistics: data aggregation in the data sample.
        • Total value: total attribute value in the data sample.
        • Mean value: average attribute value in the data sample.
        • Minimum value: minimum attribute value in the data sample.
        • Maximum value: maximum attribute value in the data sample.
        • Total objects in the asset: number of objects in the data sample, which are used to calculate the values.
  • Change widget type: click to select another widget type from the list. The configured widget settings are saved.