Column Chart

The column chart visualizes data about event types for a single asset.

Note: This section describes the column chart content item in the Event Visualization category. For details on the column chart content item in the Visualization category, see Column Chart in the Visualization section.

Configure the following properties for this content item:

• In the Basic tab:

  • Follow asset context - When this is enabled:

    • If this content is in a dashboard, it uses the dashboard's asset context as its data source. For details, see Create a new dashboard.

    • If this content is in an experience, it uses the navigation item's asset reference as its data source. For details, see the Add content to a pane section in Add content to panes in your navigation items.

  • Asset - If Follow asset context is disabled, select the asset to represent with this content item. To display data, the selected asset must have events.

    You can search for assets by name, by filter, or both.

    • To search by asset name, enter a value in the Asset field.

    • To apply filters, select the Asset field, then select to view and select filters. Select to accept your selected filters and return to the previous search panel.

    • Select an asset from the search results to add it.

  • Follow time context - When this is enabled:

    • If this content is in a dashboard, it uses the dashboard's time context as the time range for the data it displays. For details, see Create a new dashboard.

    • If this content is in an experience, it uses the time selected in the time selector content item as the time range for the data it displays. For details, see Add a time selector.

  • Time - If Follow time context is disabled, select the time range for the data displayed in the content item.

  • Event Type - The type of event to chart. Only event types associated with the selected asset are displayed.

  • Aggregation Type - The calculation method for the data displayed in the chart. Default is Sum.

  • Group By - How the events are organized. The values in this list are based on the selected event type. They are non-numeric values including string type, reference data type, and assets of selected event type.

  • Field To Chart - The fields to display. The fields in this list are based on the selected event type.They are numeric and timespan field. Each field is aggregated based on the selected aggregation type and displayed on the y-axis.

• In the Advanced tab:

  • Title - The title that displays for this content item. This property is only available in grid dashboards; content items do not display titles in canvas dashboards or experiences.

  • Show legend - Display the legend.

  • Show Label - Display data labels.

    If the chart has too much data and labels would be unreadable, labels are not displayed. If the period is adjusted to display less data, the labels display.

  • Select Chart Style - The style and orientation of the chart. The options are:

    • Vertical Bar Chart - A set of vertical bars based on the selected field organized according to the Group by setting.

    • Horizontal Bar Chart - A set of horizontal bars based on the selected field organized according to the Group by setting.

    • Vertical Stacked Graph - A set of vertical bars stacked based on the Stack By property, where each bar corresponds to the selected fields with their respective color definitions and values based on the Group by setting.

    • Horizontal Stacked Graph - A series of horizontal bars stacked based on the Stack By property, where each bar corresponds to the selected fields with their respective color definitions and values based on the Group By setting.

  • Stack By - If you select the horizontal or vertical stacked graph chart style, choose how to stack data.

  • Show Pareto Line - Displays a cumulative percentage as a Pareto line on the bar chart. To view the cumulative percentage, hover on the Pareto line. By default, this is disabled.

  • Pareto Line on - If Show Pareto Line is enabled, select a field from the dropdown. The dropdown lists the fields selected in Field to Chart.

Configure, hide, or remove a field

After a field has been added, use its controls to configure how it appears in the chart.

• To change the assigned color, select the color picker and select a color.

• To hide the field, select Hide .

• To remove the field, select Remove .

Video Tutorial: Configure a field in the column chart in CONNECT Visualization

Video transcript (Select to expand)