Asset Comparison Table+

Asset Comparison Table+ is a custom symbol for PI Vision that lets you compare AF Assets and their data side-by-side in a pivot-like, interactive table. Group, filter, and multistate your way to insight; drill into child assets in a tree; and even enter or edit data directly—then export your results to Excel, PDF, or CSV. It’s part of the Vision Library+ symbol collection.

Features

• Pivot-like Asset Comparison: Arrange assets as rows or columns and pivot attributes, KPIs, or rollups for fast benchmarking across units, lines, or sites.
• Hierarchy & Drilldown: Expand tree views to reveal child assets and navigate from enterprise → site → area → unit with collapsible groups.
• Grouping & Filtering: Group by any attribute or metadata and apply quick filters, search, and sorting to focus on what matters.
• Multistate: Apply conditional formatting across cells, rows, or groups to highlight limits, statuses, and anomalies at a glance.
• Data Entry & Editing: Inline edit cells (e.g., setpoints, targets, comments) with optional validation and audit notes.
• Export Data:
  • Download current view or full dataset to Excel, CSV, or PDF.
  • Client-side export—no server round-trip required.
• Performance at Scale: Virtualized scrolling and paging for large asset fleets.
• Custom Themes: Match your dashboard with light/dark and accent color themes.
• Flexible Data Sources: Compare values from AF Attributes and Calculations
• Extras:
  • Column totals/subtotals and rollups.
  • Per-column units and engineering notation.
  • Optional per-user column layouts and saved views.

Screenshots

Transpose Table: Horizontal or Vertical Format

Multistate & Conditional Formatting

Export to Excel, CSV, PDF

Hierarchy & Child Assets

Data Entry Capabilities

Select Different Themes

Totals, Subtotals & Rollups

Demo