Contents x
    Raw Data Node
        Contents

        Raw Data Node

            Article summary

            Raw Data Node

            The Raw Data node can display all available data for a device or device label. You can use this node with both current and historical data.


            Each new value will appear on a new row.   



            Adding a Raw Data node to your workflow

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


            Configuring your Raw Data node

            1. 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. Enter a Widget Refresh Interval to set how often the table will update in seconds. 

            Adding and defining columns

            Raw 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 name of the field within the incoming JSON payload with the data you want the widget to display. 
            2. Choose a Display Name for the column on the widget.
            3. Select a Field Type to show the node where to get and how to format the data: 
              • Workflow: grabs data from the workflow.
              • Custom table: grabs data from a specified table. You will need to confirm the table syntax. 
              • Event date: produces a timestamp for the record.
              • Device: takes the device ID from an existing device table.
              • Multi choice: uses a CSV to present the end-user with table options. If a user changes the value for the tables showing devices, this column type will output the corresponding payload. 
              • File: will add two extra fields for configuration ('File name field' and 'Category'). 
                •  Under 'File Name Field', enter the field name in the JSON payload containing the relevant files.
                • Under 'Category', a comma-separated list of categories will appear. Choose which one you want to assign to the files.
            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.
              • Link your column to a configured dashboard using Dashboard to link to.
              • Use Aggregate to calculate average and sum options for the entire column.
              • Display a chosen symbol in front of or after every column value by configuring Pre Symbol or Post Symbol.
              • Specify the number of places for each value using Decimal Precision.

            File Display

            If you select 'File' as the column field type, you must configure the file display and input the necessary FTP details. Once configured, clicking on the file icon from the end-user widget will allow you to download the file. Supported file types include MP3, MP4, WAV, CSV, PDF, TXT, JPG, PNG, and GIF.

            1. Enter the FTP Address for the folder within the FTP server containing the files.
            2. Enter the User Name for the FTP server.
            3. Enter the Password for the FTP server.

            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. Enter the label you will be using to filter devices under Device Label Name.
            2. Select a method for grouping the widget on the dashboard from the drop-down options:
              • 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. Choose whether to ‘Show Devices’ or ‘Show Device Label Values’ on the raw data node by configuring Show on Table.
            4.  You can select a Calculation Interval for tabular data by specifying the Units of Measurement from the options in the drop-down list.

            See Also: Creating a dashboard, Creating device labels, Configuring nodes using labels

            As of Release: 10.02.2022

            What's Next