Grid

Use this content item to display event details for a single asset.

The properties for this content item are:

• In the Basic tab:

  • Follow asset context - When this is enabled:

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

    • 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 visualization, it uses the visualization's time context as the time range for the data it displays. For details, see Create a new visualization.

    • 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 - Set the type of event to display in the grid. When this property is set, the grid appears with the default column headers associated with the event type based on the selected asset. The grid data is sorted by startTime if it is included in the selected fields; otherwise, data is sorted by the first column header.

  • Field - Define the column fields to include in the grid.

    This property displays a hierarchical tree view of the first- and second-level event fields. Fields at each level are displayed in alphabetical order. For detailed steps in configuring the columns, see Configure column fields in the grid.

  • Period - Set the period for filtering event data. This property only appears when you select a metric event type and its period field is not empty.

• In the Advanced tab:

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

  • Enable export - Export grid data to CSV and Excel formats. The content item saves the exported data as a file (Event visualization data <YYYYMMDD_HHMMSS>.<extension>) in the Downloads folder.

Configure column fields in the grid

1. Select Field. A hierarchical tree view of the available fields appears.

2. Select the column fields to include or exclude in the grid. The selected fields appear as inline chips above the tree. By default, a maximum of two chips display, with the rest hidden. To view or hide the additional selected fields, select Show <> more or Hide filters as needed. To deselect column fields, clear them individually by selecting the X button in each chip, or select Clear all.

   

3. When you finish configuring the column fields, select Select to apply the configuration to the grid and display data. The column fields appear in the order you selected them. To reorder, drag and drop the column to a new location. When you save the configuration, the content item retains the order. Adjust the time period if there is no data to display.

   Note: By default, the content item sorts displayed data by the start time field in descending order. If this field is unavailable, it uses the first selected column.

   To add or remove fields to your initial column configuration:

   1. Click the current value of the Field property to open the hierarchical tree view with your previous selection.

   2. Select or deselect a column field, then select Select.

Export data

• On the Properties pane, select the Content Settings tab, and then select Enable export to display the export options.

  Note: The content item converts field values in HH:MM:SS format to seconds in the exported file. If you apply data grouping or any other settings, the content item exports the data as is.

  

Filter data

• Use the filter menu to refine the displayed data. Click the filter icon to open a filter dialogue box. The available filter options in each filter type are based on the CONNECT data services supported filter settings. You can filter only columns supported by CONNECT data services.

  To remove filter, select the filter icon and select CLEAR.

  Note: The filter icon changes its color to indicate that a filter has been applied and the number that appears represent the number of filters applied. You can apply filtering to one or more columns.

  Example: Checkbox filter

  

Group data by columns

• Drag and drop a column header to the grouping area above the columns. You can group data using multiple column headers, creating a hierarchical structure.

  The sequence in which you select column headers for grouping determines their hierarchical level. The first column header you drag and drop represents the top level, the second represents the next level within the top level, and so on. The number of items at each level shows the count of records associated with each column header value.

  Select the x button next to the column header to ungroup.

  Note: You can use most column headers for grouping, but the last available header is restricted.

  

Reorder column

• Drag the column header you want to move and drop it to its new location within the grid.

  

Resize column

• You can do either of the following to resize the grid column:

  • Hover over the right border of a column header to see the resize column icon , then click and drag in either direction to resize the column.

  • Double-click the right border of a column header to auto-fit the column width.

  

Sort data

• Click a column header to sort the data. The gird sorts the data by the selected column in ascending or descending order, indicated by an up or down arrow.

  By default, the grid sorts the data based on the start time, if start time does not exist, it sorts by the first column.

  

  The grid supports multi-column sorting. To sort by multiple columns:

  1. Select a column header.

  2. Press Ctrl, then select the next column header. A number appears before the arrow based on the sequence in which you select the column headers. This sequence also determines the sorting priority of the columns.