Asset Comparison Table+ for AVEVA PI Vision

PI Vision asset comparison table with grouping, totals and editing

See the same AF attributes for many assets side by side, with the exact values. Asset Comparison Table+ groups, totals, sorts and colours the table in your PI Vision display, and can let users edit the values.

Request a trial Explore Vision Library+

Read the Asset Comparison Table+ documentation →

Asset Comparison Table+ in PI Vision listing six centrifugal pumps as rows with flow rate, discharge and suction pressure, shaft speed, vibration and bearing temperature with units, average, minimum and maximum rows on top and the two warmest bearing temperatures highlighted, next to the Table settings with orientation, columns, right to left and the asset column
Asset Comparison Table+ v2.0 in PI Vision: six pumps, one row each, with column totals and multi-state colours on bearing temperature. Demo data. Select the image to enlarge.

PI Vision asset comparison table for AF assets

Choose the assets and attributes once, then decide whether the assets run down the rows or across the columns.

Assets as rows or as columns

Use the familiar layout with one row per asset, or turn the table round when you compare a few assets across many attributes.

  • Vertical: assets as rows and attributes as columns; horizontal swaps them.
  • Column widths that fit the data, fit the table width or are set by hand.
  • A custom label per attribute and for the asset column, with units and alignment.
  • Right-to-left reading order for right-to-left languages.
Asset Comparison Table+ in horizontal orientation with the six pumps as columns and the attributes as rows, next to the Table settings with the orientation set to Horizontal and the Attribute column switched on
The same pumps with the table turned round. Demo data. Select the image to enlarge.

From an AF search, as current values or summaries

Let PI Vision search criteria fill the table, so new assets of the same type appear without editing the display.

  • Search by database, search root with all descendants, asset name, type and category.
  • Attributes picked from one list of the attributes the assets share.
  • Current value, or total, average, minimum, maximum, range, standard deviation, count or per cent good, time or event weighted.
  • PI Vision number formats with a fixed number of decimal places.
Asset Comparison Table+ Attributes settings with the current attribute list, Flow Rate selected, Hidden Measure off, Units on, an empty label, right alignment, Value set to Average and Basis Time Weighted
Per-attribute units, label, alignment and value type. Select the image to enlarge.

Group, total and sort asset data

Structure a long asset list so readers find the assets that matter and see the overall figures.

Grouping and totals

Group the assets by an attribute value and add totals for every attribute or every asset.

  • Group by an attribute, sorted ascending or descending, expanded or collapsed, with an asset count.
  • Total rows per attribute and total columns per asset: sum, average, minimum, maximum and count.
  • A grand total where the two meet.
Asset Comparison Table+ with the six pumps grouped by manufacturer, Flowserve, Goulds and Sulzer with two assets each, below average, minimum and maximum rows for every attribute, next to the Group settings with Group By Manufacturer, Sort, Sort Order, Auto Expand and Count and the Totals settings
Pumps grouped by manufacturer, with average, minimum and maximum per attribute. Demo data. Select the image to enlarge.

Asset hierarchy as a tree

Show parent and child assets as collapsible tree nodes, so readers move from a line to its sub-lines in one table.

  • Child assets nested under their parent assets.
  • Auto expand on load, down to a chosen level.
  • Expand all and collapse all from the toolbar.
  • Works with an AF search that returns all descendants.
Asset Comparison Table+ with Line 1 as an expanded tree node and its sub-lines Line 1.1 to Line 1.5 and Line 1.1.1 to Line 1.1.4 nested below, speed shown as multi-state progress bars, next to the Tree settings with Enabled and Auto Expand on and Level 99
A production line and its sub-lines as a tree. Demo data. Select the image to enlarge.

Sorting, multi-state colours, themes and download

Sort with a click on a column header, let colours show which assets need attention, and give readers the data in the format they need.

  • Sort by any column; a row click or the column menu can open a quick trend.
  • Multi-state colours per attribute as text, border, soft fill, accent and tint, status dot, value badge, solid fill or progress bar, optionally on the asset name too.
  • Built-in themes such as PI Vision, Light and Software Athlete, container styles and a comfortable row spacing.
  • A download button for CSV, JSON, Excel (XLSX) or PDF.
Asset Comparison Table+ in view mode sorted by flow rate in descending order, with soft-fill multi-state colours marking the two warmest bearing temperatures
Sorted by flow rate, with multi-state colours on bearing temperature. Demo data. Select the image to enlarge.

Edit AF attribute values in PI Vision

Switch the table to Edit mode and use it as an input form for many assets at once.

Edit values in the table and save them

Let users correct or update values for many assets in one place; Save writes the new values to their data sources.

  • Edit mode with Allow Edit per attribute, so only the intended columns can be changed.
  • Save at the current time or a custom time, with an optional timestamp box in the toolbar.
  • Undo and redo before saving, reload, and import values from a CSV file.
  • Optionally delete existing values, and ask users to confirm before saving.
Asset Comparison Table+ in Edit mode with the row of pump P-101A selected and its editable flow rate cell, and the toolbar with expand, collapse, undo and redo on the left and CSV import, download, reload, the timestamp box and Save on the right
Edit mode with the save toolbar; nothing was saved. Demo data. Select the image to enlarge.

Validation limits for entered values

Catch typing errors before they reach the PI System with limits per attribute.

  • Limits from the database or a custom minimum and maximum.
  • Hard limits block the value; soft limits warn first.
  • A custom message for out-of-range values.
  • Edits use each user’s existing PI write permissions.
Asset Comparison Table+ Attributes settings in Edit mode with Units, Label, Alignment, Allow Edit on, Limits on, Hard Limit on, Limit Mode Custom, Max 250, Min 0 and the message Allowed range: 0 to 250 m3/h
Allow Edit, custom hard limits and a message for one attribute. Select the image to enlarge.

PI Vision asset comparison table examples

Four common ways teams use Asset Comparison Table+ on their displays.

Pump fleet overview

Data
Flow, pressures, vibration and bearing temperature of every pump from one AF template
Settings
AF search on the pump type, multi-state colours on bearing temperature, sorting
Shows
Every pump’s current values, with out-of-range temperatures highlighted

Shift figures per line

Data
Production and speed per production line
Settings
Value Total and Average, total rows per attribute
Shows
Each line’s result next to the plant total and average

Target and setpoint entry

Data
Target attributes on many units
Settings
Edit mode, Allow Edit on the target columns only, custom limits, Require Confirmation
Shows
Planners update the targets for all units in one table

Line drill-down

Data
The same attributes on lines and their sub-lines
Settings
AF search with all descendants, tree view with auto expand
Shows
Line values first, with each line’s sub-lines one click away

Related symbols: Asset Comparison Bar Chart+ to rank the same assets as bars, Asset Filter+ to choose the assets on the display, Time Series Table+ for values over time, and Manual Input Table+ to edit archived values of one data source.

Asset Comparison Table+ FAQ

Questions we are asked most often. Read the Asset Comparison Table+ documentation or ask a technical question.

How is it different from the PI Vision asset comparison table?

Asset Comparison Table+ keeps the familiar layout of assets and attributes and adds a horizontal orientation, grouping, a tree view of child assets, totals, multi-state cell styles, editing with limits, downloads, themes and click actions. You can use it next to the native table on the same display.

When should I use the table instead of a bar chart?

Use Asset Comparison Table+ when readers need the exact values side by side, totals or editing. Use Asset Comparison Bar Chart+ to rank many assets by one or a few attributes at a glance.

Can users edit values in the table?

Yes. Switch the table to Edit mode and turn on Allow Edit for the attributes users may change. Save writes the values at the current time or a custom time, optionally after a confirmation, and limits can block or warn about out-of-range entries. Writes use each user’s existing PI permissions.

Can new assets appear in the table automatically?

Yes. Add search criteria and the table is filled from an AF search by search root, asset name, asset type and category. If assets are missing, check Return All Descendants and the number of results.

What do we need to run it?

PI Vision 2021 or later with PI Web API, and PI AF Server 2018 SP2 or later. Asset Comparison Table+ runs in PI Vision and uses each user’s existing PI permissions.

How do we get Asset Comparison Table+?

Asset Comparison Table+ is part of Vision Library+, together with the other Vision Library+ symbols. Request a trial to test it in your own PI Vision environment.

Try Asset Comparison Table+ in your PI Vision

Asset Comparison Table+ is included in Vision Library+, the PI Vision custom symbol library from Software Athlete. Test it on your own displays and data.

Request a trialBook a live demo

Browse all Vision Library+ symbols · Asset Comparison Table+ documentation