Time Series Table+

Overview

Time Series Table+ presents recorded or calculated values in rows with sorting, filtering, grouping, multi-state styling, and export.

When to use it

Use this symbol when you need to:

• Review several time-series sources in a precise tabular form.
• Filter, group, or export values for a selected period.

Before you begin

• Prepare the PI Points or AF attributes and choose a compatible retrieval method.
• Select a time range and interval that keep the row count manageable.

Add and set up the symbol

1. Select the symbol in the PI Vision symbol gallery.
2. Add the required data sources or asset context to the display.
3. Right-click the symbol and open its configuration pane.
4. Configure the minimum data, range, and display settings for a useful result.
5. Confirm that the symbol shows the expected data.

Use the symbol

Sort, filter, group, or select rows to investigate values. Export creates a file from the currently configured table data.

Time grouping

Data can be grouped by timestamp using the following intervals: Year, Month, Week, Day, Hour, or Minute. Multiple intervals can be combined to create an expandable tree view.

For example, grouping by Year, Month, and Day of Month creates the following expandable data tree:

Note: The datetime format in this example is set to Hour.

Time bar

The time bar provides independent time control for the symbol without affecting the display's global time range. Enable it from the configuration pane:

Once enabled, the time bar lets users shift or resize the symbol's time range directly. The following configuration options are available:

• Enabled: Enable or disable the time bar.
• Ignore Display Time: When enabled, the symbol’s time range is unaffected by changes to the display’s global time. This setting can also be toggled by clicking the lock icon in the time bar.
• Duration: Configure fpreset time durations, available as a dropdown between the navigation arrows.
• Style: Adjust the text color, background color, border color, and font size.

Exporting data

To export table data, right-click the symbol and select Export Data.

Choose from CSV, JSON, XLSX, or PDF export formats.

Configure the symbol

Overview and behavior

The Time Series Table+ symbol displays time-series data from the PI data archive in a tabular format. It supports filtering, grouping, multi-state coloring, and data export.

General configuration

Use the Configuration pane to customize the symbol's visual styles, columns, interactivity, and multi-state settings.

1. Right-click the symbol and select Configure Table to open the configuration pane.
2. Under Table, configure the following basic table settings:

• Orientation: Choose between Horizontal and Vertical table orientation. In Horizontal mode, timestamps appear as columns; in Vertical mode, timestamps appear as rows.

Vertical Horizontal

• Max. Rows / Max. Columns: Limits the number of time rows or columns displayed. The sort order is controlled by the Sort By and Descending settings.
• Sort By / Descending: Choose the property by which to sort the table data. By default, data is sorted by time and returned chronologically. Selecting a different property sorts by that value instead - for example, sorting by a numeric property with Descending enabled returns the largest values first.
• Layout

Select from three column-width layout modes:

• Wrap Text: Wraps long cell text to the next line rather than truncating it.

Wrap Text ON Wrap Text OFF

• Right to Left: Displays all table text in right-to-left reading order.
• Paging: Choose between paging and scrolling when the number of rows exceeds the table height. Not available when Wrap Text is enabled.

1. Under Header, configure the following column header settings:

• Show: Show or hide the column headers.
• Units: Display units of measure (UOM) in column headers.
• Wrap Text: Wrap or truncate column header text.
• Vertical: Display column header text vertically.
• Column Filters: Show or hide per-column filter controls, allowing users to filter table data interactively.

1. Under Group, configure how data columns and rows are grouped:

• Enabled: Enable or disable data grouping.
• By: Choose the property to group by: Custom, Asset, Category, or Description. The Custom option lets you set a unique grouping value for each data source.
• Auto Expand: Start groups expanded or collapsed on load.

1. Under Totals, configure row and column total calculations:

When column totals are enabled, choose between two modes: Single displays one calculation row at the top or bottom of the table, and Multiple lets you select which calculation rows to show. Note: In Multiple mode, calculation rows can only appear at the top.

1. Under Auto Scroll, you can configure the table to automatically scroll through the data, or select the next page if pagination is enabled

Multiple

Selecting a calculation type adds a corresponding row at the top of the table.

Single

In this mode, the table displays a single calculated value row at the top or bottom:

Values are calculated from the data currently displayed in the table. Six calculation functions are available: Average, Sum, Min, Max, Count, and Count Specific.

Count Specific counts occurrences matching a defined condition. Once enabled, open the column settings and set the operator and value to match. The following example counts all values less than 10:

The result appears in the column header as follows:

1. Under Time, configure the time columns and rows:

• Datetime Format: Choose between Default (milliseconds excluded) and Exact (milliseconds included) timestamp format.
• Pin Time Column: When the table content exceeds the visible width and a horizontal scrollbar appears, keep the first time column fixed while scrolling.

Data can also be grouped by timestamp using the following intervals: Year, Month, Week, Day, Hour, or Minute.

• Enabled: Enable or disable timestamp grouping.
• Auto Expand: Start timestamp groups expanded or collapsed on load.
• Count: Show or hide the row count for each timestamp group.

• Style: Configure colors and font styles for the time column. Only available in Vertical orientation.

1. Under Interactivity, enable or disable the following settings:

• Ad Hoc Chart: Allow users to generate an ad hoc chart by clicking a row or column header.

Data source configuration

Under Columns, configure the data sources to display in the symbol. The following properties are available for each data source:

• Label: Control how the data source is identified in the column header. Choose from attribute name, asset name, and/or PI point name.
• Show Units: Show or hide the unit of measure (UOM) in table cells.
• Alignment: Set the horizontal alignment of cell values: Left, Right, or Center.
• Filter: Define conditions to pre-filter data at the source. This server-side filter is recommended over the table column filter, as it reduces the data transferred and improves load performance.

Data retrieval configuration

• Mode

• Start- and End times

Configure style

The following built-in themes are available for the table:

	The default theme: gray backgrounds with white text.
	The light theme: white and gray backgrounds with black text.
	The dark theme: white text on black backgrounds.
	The transparent theme: removes all borders and backgrounds, showing only the raw text.
	The custom theme: build a fully customized theme.

• Custom Styles: Customize every aspect of the table's appearance, including background colors, foreground colors, font sizes, and element order.
• Copy/Paste Custom Style: Copy a custom style from one table and paste it onto another. Click Copy on the source table, select the target table, then click Paste. This works across all table types and symbol types.

Filtering

When column filters are enabled in the configuration menu, a filter control appears in each column header.

The control displayed depends on the column's data type:

• Enumeration sets and Boolean values: dropdown selector.
• Strings: text input field.
• Numeric values: two input fields - one for the minimum value and one for the maximum.

Note: Column filters are applied client-side, meaning the full dataset is loaded from the server before filtering. For large datasets, use the data source filter instead, which filters server-side and improves performance.

Time column

The following configuration options are available for the time column:

• Pin Time Column: Keep the time column fixed at the left edge regardless of horizontal scroll position.
• Background / Text / Border: Adjust the background color, text color, and border style of the time column.
• Mode: Where to apply the column style to. Choose between all timestamps, or weekends only.

The displayed timestamp format can also be customized, as described in the Changing the Displayed Timestamp section below.

Changing the displayed timestamp

The Time Series Table+ allows you to customize the displayed timestamp format. In the General configuration section, select from the available timestamp formats.

Adjust the format to match your selected time range and interval. For daily values, the Short Date or Date format is recommended.

All formats are localized to the user’s browser language settings.

Multi-State

Multi-state coloring applies colors to values based on limits defined in Asset Framework or configured directly in PI Vision. To enable multi-state:

1. Right-click the symbol and select Add Multi-State.
2. In the Rows section, select a data row and check Enable Multi-State.
3. Choose the coloring mode:

Fill		Colors the cell background according to the state.
Text		Colors the cell text according to the state.
Progress		Displays a colored progress bar scaled to the data source's configured min/max (span/zero) limits.
Progress & Value		Displays both the current value and the colored progress bar.

1. If the data source is an attribute with configured traits, limits are populated automatically. Otherwise, define static limits manually.

Split strings into columns

Some systems send data as a delimited string, with values separated by a character such as ";" or "|". The Time Series Table+ can split these strings into individual columns.

To use this feature, ensure the attribute or tag value is of type String. Then enable Split String and define a Delimiter:

The string is split into values at each delimiter occurrence. To display a specific value in the table, create a column and set its Index (zero-based) to the position of that value in the split result. The following additional options are available:

• Name: The display name for the new column.
• Index: The zero-based position of the value in the split result.
• Data Type: Select String or Number. This affects filtering behavior and column calculations.

The following additional options apply when Data Type is set to Number:

• Decimal Separator: The character used to parse the decimal part of the number.
• Display Digits: The numeric format used when displaying the value.

Troubleshooting and limitations

• Check: If rows are missing, check the retrieval mode, interval, filters, and time range.
• Check: Large ranges and small intervals can create high row counts and slow rendering.