Tabular Data

Tabular Data Node

The Tabular Data node will display the most recent or current calculated value for a device or device label.

Each row within the node represents a different device or device label so you can quickly assess each status.

Adding a Tabular Data node to your workflow

1. First, select a solution and navigate to Rayven Workflow.
2. Select ‘Visualizations’ from the left-hand panel.
3. Find the Tabular Data node and drag it onto the canvas.
4. Connect the Tabular Data node to your input node.
5. Double click on the Tabular Data node to open its configuration window.

Configuring your Tabular Data node

1. You will need to give your node a Name. Choose something simple that clearly explains its purpose. You must pick a name that has three or more characters.
2. Your workflow must contain input data. Using ‘Column - Input Field Name’, enter the field in the incoming JSON payload that contains the data you want to display on the widget. 
3. If there’s a hierarchy within your JSON data load, you can choose to include a Parent Field. If you select a Parent Field, all other fields used within this configuration should be its children. 
4. If you want to set conditions for data to be shown or hidden, you can use If Input. The condition options are =, >, or <.
   • Select '=' if you want the condition to pass when incoming data equals the set value.
   • Select '>' if you want the condition to pass when incoming data is greater than the set value.
   • Select  '<' if you want the condition to pass when incoming data is less than the set value.
   • Select 'Exists' if you want the condition to pass if incoming data exists.
   • Set the action to ‘Show’ if you want the rest of the data visible when the condition passes.
   • Set the action to ‘Hide’ if you want the rest of the data hidden when the condition passes.
5. Finally, enter your desired Widget Refresh Interval. This figure determines how often the table updates in seconds.
6. Once you’re satisfied with your Tabular Data conditions, click ‘Save’ to confirm your configuration.

Adding and defining columns

Tabular data tables can have multiple columns but must contain at least one. The delete button (‘x’) at the end of the row will remove a column, and the ‘+Add Value’ button below the columns will add a new column. You can reorder the columns by dragging them into new positions.

To set up a column:

1. Enter the Data Field Name: the field within the incoming JSON payload containing the data you want the widget to display.
2. Choose a Display Name for the column. 
3. Select a Field Typeso the node knows where to obtain and how to format data:
   • Workflow: grabs data from the workflow.
   • Custom table: grabs data from a table. Requires syntax confirmation to identify which table to read.
   • Event date: produces a timestamp for the record.
   • Device: takes the device ID from an existing device table.
   • Multi choice: requires a CSV with options for users to select. If a value changes for tables showing devices, they will output the relevant payload with the selected multiple-choice option. Configure your node with this field type and set it to show devices if you want the table to resend the latest JSON for a device when a user selects a multi-choice option.
     
   • Workflow Date Field: can be used if the data is in a standard date format, which allows correct sorting of the dashboard.
   • Reference Field: allows the usage of other columns for aggregation with standard operators such as *, /, +, or -.
4. Select the Data Functionyou want to calculate or display for each column or device. You can choose from the following options:
   • Last value received,
   • Sum,
   • Average,
   • Min,
   • Max.
5.  Once you have specified the data field, field type, and data function, you then have the option of configuring more advanced processes.
   • You can link your column to a configured dashboard using Dashboard to link to.
   • The Aggregate field can calculate average and sum options for the entire column.
   • Pre Symbol can display a chosen symbol in front of every value within the column, and Post Symbol can add a chosen symbol at the end of every value within the column.
   • Finally, using Decimal Precision enables you to specify the number of decimal places to display when calculating each column value.

Grouping by device label

You will need to save at least one label in the Device Labels section of the Workspace before configuring this section. See Creating Device Labels and Configuring nodes using labels for more information.

1. Select the label you will be using to filter devices and enter it under Device Label Name.
2. Select a method for grouping widgets on the dashboard:
   • No Grouping (widget per device) will create a unique widget for each device.
   • Group by device label value (widget per label value) will create a unique widget for each unique label value. For example, if the device label is ‘Color’ and the label values are ‘Green’ and ‘Gold’ the dashboard will show two widgets. One will contain data for devices labeled ‘Green’ and the other for devices labeled ‘Gold’.
   • Group by device label name (one widget) will display only one widget. It will contain data from all devices with the device label specified.
3. You can choose whether to ‘Show Devices’ or ‘Show Device Label Values’ on the tabular data node by configuring Show on Table.
4. You can also select the Interval over which you want calculations performed. You will need to specify the Units of Measurement for the calculation interval from the options in the drop-down list.

For further instructions, see Creating a dashboard, Creating device labels, and Configuring nodes using labels.