Time Series Table+

Overview

When to use it

Use Time Series Table+ when you need to:

• Read the exact values of several data sources side by side, for example every 15 minutes.
• Show one summary value for each hour or day, such as the maximum or the average.
• Color cells by limits or by digital states.
• Group rows by day, show totals, and filter out the rows that do not matter.
• Export the table to CSV, JSON, XLSX or PDF.

Choose Combo Chart+ when the shape of a trend matters more than the exact values. Choose Asset Comparison Table+ to compare attributes across several assets.

Before you begin

• Use PI Points or AF attributes with numeric, digital (state) or text values. Summaries and totals need numeric data sources.
• Plan the row count. A 15-minute interval over a day is 96 rows; the table loads up to 1000 rows by default.
• Historical data comes through PI Web API. Ask your administrator to configure it for Vision Library+, see the installation guide.

Add and set up the symbol

1. Select Time Series Table+ in the PI Vision symbol gallery.
2. Drag the PI Points or AF attributes you want to compare onto the display. The table shows one column for each data source and the newest recorded values first.
3. Right-click the table and select Configure Table....
4. Under Data Retrieval, set Mode to Interpolated (1).
5. Set Interval to 15 and Minute (2).
6. Close the pane. The table shows one row for every 15 minutes of the display time range.

The table follows the display time range, so change the range with the PI Vision time controls. To give the table its own range, use Start- and Endtimes in the same group.

Common tasks

Show one summary value for each hour

Use this when you read a period as one number, such as the highest tank level of each hour.

1. Right-click the table and select Configure Table....
2. Under Columns, select each digital or text data source in the list and select Delete. Summaries are calculated for numeric data sources only.
3. Under Data Retrieval, set Mode to Summary (1).
4. Set Interval to 1 and Hour (2).
5. Select the calculation in Type (3), for example Maximum.
6. Leave Basis on Time Weighted to weight each value by how long it lasted, or select Event Weighted to count each recorded event once.

Each row is now one hour, and each cell is the maximum of that hour for its data source. For a shift or a day, enter a different interval, such as 8 Hour or 1 Day.

Group rows by day and show a daily average

Use this when the table covers several days and you want one average for each day.

1. Right-click the table and select Configure Table....
2. Under General, open Totals. Set Enabled to ON (1).
3. Set Type to Single (2), Function to Average (3) and Position to Bottom.
4. Under General, open Time. In the Group list, select Day (1).
5. Select Show calculations when closed (2) and Count (3). The first of these appears only while Totals is on with Type Single.

The rows fold into one header for each day, with the number of values in its title, and an Average row under each day. Select a day header to open or close the day. You can select more than one Group entry, for example Month and Day, to build a tree.

Color a column by limits

Use this when readers must see at a glance whether a value is low, normal or high.

1. Right-click the table and select Add Multi-State.... When a data source already has one, the command reads Configure Multi-State....
2. Select the data source in the list (1).
3. Select Enable Multi-State (2).
4. Under Property, select a style (3), for example Soft Fill.
5. In the Status list, select a color swatch (2) and pick a color for each limit. Type a value in the box and select Add (1) to add a limit. Select the cross (3) to remove one.

Each cell takes the color of the limit its value falls under. Values up to 25 are red, up to 45 orange, up to 65 green, up to 85 orange and up to 105 red. If the data source has limits in AF, the list starts with them. For a digital data source, the list holds one color for each state.

Filter the rows you see

Use this when you look for the rows that match a condition, for example automatic mode with a high level.

1. Right-click the table and select Configure Table....
2. Under General, open Header and set Column Filters to ON. A filter box appears under each column header.
3. In the filter box of a digital column, select the states to keep (1).
4. In the Min or Max box of a numeric column, type a limit (2).

Only the rows that match every filter remain. Column filters work on data that is already loaded. To reduce what the table requests, add a condition to a data source instead:

1. Under Columns, select the data source.
2. Set Filter to ON (1).
3. Select + Add Condition (3), choose the operator, and enter the value (2).

The condition is applied in the data source's own unit. In Interpolated mode, the rows stay and the cells of that column that do not meet the condition are empty. A new condition without a value empties the column until you enter one.

Put the times across the top

Use this when you compare a few time points for many data sources, as in a shift report.

1. Right-click the table and select Configure Table....
2. Under General, open Table. Set Orientation to Horizontal (1).
3. Set Layout to Fit Data (2) so the first column shows the full data source names.
4. Under General, open Time. In Datetime Format, select a short format such as the time of day.

Each data source is now a row, and each time is a column. Max. Columns limits how many times load.

Export the table to a file

Use this when you share the values or keep a record of a shift.

1. Right-click the table and select Export Data....
2. Select the File Format (1): CSV, JSON, XLSX or PDF.
3. For PDF, set Style, Title, Orientation, Font Size and Padding. Colors (2) keeps the table colors.
4. Select Download (3).

Your browser saves a file named DataExport_, the date and the time. CSV, JSON and XLSX hold the table values, and the CSV header names carry the units. Every format includes the totals the table shows, with total rows after the data rows. In JSON, each row uses the keys DisplayTime and datasource_0, datasource_1 and so on, in column order. Nothing is written to PI.

Use the symbol

• Sort: Select a column header to sort by that column, and select it again to reverse the order. Sorting needs Sorting under Header.
• Filter: Type in a filter box. A text column shows the rows that contain your text, and * and ? match any characters.
• Group: Select a group header to open or close it.
• Quick Trend: Open the header menu of a data source and select Quick Trend to trend it for the table's time range, or Add to active Quick Trend to add it to a trend that is open.
• Hover: Hover a column header to see the path of its data source.
• Pages and scrolling: With Paging on, use the page buttons under the table. With Auto Scroll on, the table moves by itself and pauses while you hover it.
• Bad data: A cell with a bad value or no value is empty or shows the error text. A Bad data color in the multi-state list colors it.
• Changes you make: Sorting, filtering and resizing a column count as display changes and are saved with the display if you save it. Export and Quick Trend change nothing.

Configure the symbol

Right-click the table and select Configure Table.... The pane has the sections General, Columns, Data Retrieval, Time Bar, Style, Export Data and Numbers. Configure Multi-State... and Export Data... open their own panes.

General: Table

General: Header

General: Group

Column groups put a shared header above several data source headers.

General: Totals

Count Specific counts the cells that match a condition. Set the operator and value for each data source under Columns, in the Count row. It appears while Function is Count Specific, and in Multiple or horizontal mode while Count Specific is on. The per-time and grand totals use the same conditions, also for digital and Boolean data sources.

General: Time

General: Interactivity and Auto Scroll

Columns

Select a data source in the list. The buttons move it up, down, to the top or to the bottom, delete it, or show its PI Point attributes.

Split String. Available for a text data source in Recorded mode. It splits each value at a Delimiter into columns. Additional delimiters also split at other characters, and a longer delimiter wins over a shorter one. Select the scan button next to the column list (Detect columns) to add one column for each position in the loaded values. For each column set Name, Index (zero-based position), and Data Type (String or Number). A Number column adds Decimal Separator and Display Digits, and it can have its own multi-state. A text column's multi-state limits are text patterns matched in order, and the first match wins.

Display unit

Default shows the unit stored in AF, for example Default (kg/s). A unit from the list converts the values and is saved with the display. The list offers units of the same kind only.

• A PI Point cannot be converted, because it has no unit of measure in AF. An AF attribute that reads a PI Point can.
• Values you type are read in the displayed unit: Count Specific, multi-state limits and column filters. Enter them again after you change the unit. A Filter condition is read in the data source's own unit, and the pane names it under the condition.
• Totals use the displayed values. Limitation: The Time totals and the Grand Total add the displayed values of all data sources, so data sources in different units give a mixed total. Give them the same Display unit.
• A value that is much smaller in the new unit can need more decimals. Choose a format under Numbers.

Data Retrieval

Time Bar

Enabled adds the shared Time Bar, which gives the table its own range. Its duration options can also set the interval.

Style

Export Data

Numbers

Format sets how numbers are shown: Database, General, Number or Scientific.

Multi-State

Troubleshooting and limitations

Limitation: Column filters apply to loaded data only. Use a data source Filter to reduce what is requested.

Limitation: Summary mode works for numeric data sources. Filter and Split String are not available in it.

Limitation: Split String works for text data sources in Recorded mode.

Limitation: A PI Point cannot be shown in another unit.