Grid

Use this content item to display event details for a single asset, showing up to 30,000 records. Use the filter menu options to refine results.

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 display in this content item. The selected asset must track equipment performance to display in the chart.

    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. Select from:

    • Utilization Events (Default)

    • Job Hourly History

    • Material Produced Events

  • 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. Some fields are automatically selected based on the event type and appear in the grid by default. Fields at each level appear in alphabetical order. For detailed steps in configuring the columns, see Configure column fields in the grid.

• 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 (Asset Efficiency 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, with some fields preselected based on the event type setting.

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.

Enable auto-refresh

• Toggle Auto-refresh to enable or disable the automated periodic refresh cycle. This toggle button is available within the grid and enabled by default.

  

  Auto-refresh is supported only when the grid tile is in full screen. Otherwise, the grid follows the usual visualization refresh cycle.

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 different types of 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 displayed shows total filters applied. You can apply filters 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. The content item displays aggregated values at each hierarchy level based on the selected event type. If the columns required for calculation are missing, the grid does not display values.

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

  Note: You can use all column headers for grouping, except for start time and duration.

  

Reorder column

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

  Note: You can save the state before reordering columns and changes to the column order only in edit mode, not during runtime.

  

Resize column

• You can do either of these 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 grid sorts the data by the selected column in ascending or descending order, indicated by an up or down arrow.

  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.