<img height="1" width="1" style="display:none;" alt="" src="https://px.ads.linkedin.com/collect/?pid=2581828&amp;fmt=gif">
Skip to content
English
Rayven Website
  • There are no suggestions because the search field is empty.

Calculated Data Table Widget Node Configuration Guide

The Calculated Data Table Widget Node allows you to display tabular data where each column can contain calculated values. This widget supports conditional rendering, formatting, linking, and row-by-row evaluation based on incoming workflow data.



What Is a Calculated Data Table?

A Calculated Data Table displays structured data with custom logic per column. It supports:

  • Columns derived from workflow fields, data sources, or event dates

  • Conditional display of rows or values

  • Inline calculations and formatting

  • Optional visibility logic based on input conditions

 Step-by-Step: How to Configure the Calculated Data Table Widget Node

  1. Add the widget

    • Drag the Calculated Data Table Widget Node from the Visualizations panel to the canvas.

  2. Connect the widget to the data source

    • Link the widget to one or more upstream workflow nodes that emit the relevant fields for each table column.

    • Conditional display logic may also depend on input data fields.

  3. Open configuration

    • Double-click the widget to open the settings window.

 General Settings

Field Requirement Description
Widget Name* Required Title shown above the table.
Table Type Required Choose Regular (fixed structure).
Refresh Interval (seconds) Optional Update frequency for new data (default: 60 seconds).
Show Devices Optional Toggle to show or hide device names in the table.
Calculation Interval Optional Time window for value aggregation.
Time Units Optional Unit for interval: Seconds, Minutes, Hours, etc.
 

 Conditional Display Logic

Field Requirement Description
If Input Optional Add conditional display logic.
Input Data Field Required (if used) JSON key to evaluate.
Operator Required (if used) Example: =, >, <, etc.
Value Required (if used) Target value to compare against.
Visibility Optional Choose to Hide or show content when condition matches.
 

 Column Configuration

Each column can be configured independently using the following fields:

Field Requirement Description
JSON Key* Required The key in the JSON payload providing data for the column.
Column Name* Required Label shown in the table header.
Field Type* Required Choose one:
- Data Source
- Event Date
- Workflow Field
Function Optional Choose from:
- Last value received, Sum, Average, etc.
Time Range / Value Optional Set aggregation window for Event Date or Time Series fields.
Column Calculation Optional Perform additional logic: difference, percentage, etc.
Pre / Post Symbol Optional Display units before/after (e.g., $, %).
Decimal Places Optional Set precision for numeric fields.
Thousands Comma Optional Enable comma separators for large values.
Interface to Link To Optional Redirect users when clicking this column.
 

 Repeat column configuration as needed.

 Conditional Formatting

Field Requirement Description
Color Fill Optional Choose between:
- Value Background Only
- Entire Cell
Conditional Linking Optional Make cell values redirect conditionally based on logic.
 

Tooltip & Interface

Field Requirement Description
Enable Tooltip Optional Show additional details when hovering over a cell.
Tooltip Text Optional Custom tooltip message.
Add to Interface* Required Assign the table to one or more interfaces.
 

 Grouping & Display

Field Requirement Description
Select Label Required (if grouped) Use device label for filtering or grouping.
Grouped Display Mode Optional Choose:
- No Grouping
- Group by Label Value
- Group by Label Name
Number of Widgets to Display Optional Cap the number of grouped widgets rendered.
 

 Best Practices

  • Use pre/post symbols for clarity in units

  • Apply conditional formatting to emphasize critical metrics

  • Use workflow field when referencing computed fields or variables

  • Enable interface linking for drill-down exploration

  • Use input-based visibility to simplify data under certain conditions

 Use Cases

  • Compare calculated efficiency, performance, or error metrics

  • Display compliance status by site or device

  • Summarize workflow outputs and intermediate results

  • Create dynamic tables that adapt based on input criteria

❓ Frequently Asked Questions (FAQ)

Q: Can I calculate differences between two columns?

A: Yes. Use the Column Calculation setting to apply formulas like subtraction or ratio.

Q: Can I conditionally hide a column?

A: Not per-column—but you can use the Visibility setting at the widget or row level using input rules.

Q: Can I show only rows where a certain value is true?

A: Yes. Use the Input Data Field + Operator logic to control when rows or values appear.