Multi Axes Chart Node

Multi-Axes Chart Node

The multi-axes chart node displays multiple metrics using bars, lines, or stacked columns. It illustrates the relationships between two variables with different magnitudes and scales of measurement. This node can ingest files from an FTP directory and overlay a file icon onto the chart according to the timestamp of the received file. Clicking this icon allows you to download the file.

Adding a Multi Axes Chart 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 Multi Axes Chart node and drag it onto the canvas. 
4. Connect the Multi Axes Chart node to your desired input node.
5. Double click on the Multi Axes Chart node to open its configuration window. 

Configuring your Multi Axes Chart node

1. First, give your node a Name. Choose something simple that clearly explains its purpose.
2. If you want, you can add a Widget Subtitle. This additional text helps explain the data presented in the node. Anything added here will appear directly under the Widget Name in a smaller font.
3. Select the Device/Device Label Name checkbox if you want the device or label name displayed on the widget.
4. Select a Chart Type from the dropdown menu: 
   1. Default (multi-axes) will display a combination of bars and lines.
   2. Stacked columns will display all metrics as bars stacked on a single column.
5. If you have chosen the stacked columns chart type, enter the name of your desired Y-axis Label.
6. Enter an integer to represent your desired X-axis Time Interval. 
7. Select a Unit of Measurement for the x-axis time interval from the dropdown menu. These range from minutes to years.
   • For example, if you configure the following:
     • x-axis time interval = 1
     • units of measurement = Hour
   • The x-axis would use hourly intervals.

Configuring columns (Default chart type)

If you select the Default (multi-axes) chart type (a chart using a combination of bars and lines for each metric), you must configure the following column settings:

1. First, enter your Y-axis Field Name: the field within the incoming JSON payload that contains the data you want to display on the widget.
2. Next, enter the name you want to appear on the Y-axis Legend.
3. If you want, you can add a Y-axis Group Name to use a single label for y-axis metrics with matching units of measurement.
   • For example, you might have a field called Minimum Temperature and a field called Maximum Temperature. Since both have the same unit of measurement, you could enter Temperature as the Group Name for both metrics. Doing so would consolidate multiple y-axis labels into one.
4. Select one of the following Display As options from the dropdown menu:
   • Bar,
   • Line,
   • Dot Plot.
5. Choose a Function to apply to your data from the dropdown list: 
   • Last value received,
   • Sum,
   • Average,
   • Minimum,
   • Maximum,
   • Last value from each device with common label,
   • File. This option is only available for the Dot Plot graph. If you select this function, you must configure the File Display (see below).
6. You are able to set a Minimum and Maximum value on the Y-axis for each field. If you have entered a Y-axis Group Name, each field must have the same minimum and maximum values.
7. We recommend entering the number of decimal places to display in each field using Decimal Precision. 
8. You can also select a color for each field using a hex or RGB code. If you don't make a selection, a range of default colors will automatically be applied.

Configuring columns (Stacked Columns chart type)

The Stacked Columns chart type will create a chart where each x-axis interval contains a single stacked column and where a different color represents each metric. If you select the Stacked Columns chart type, you must configure the following:

1. First, under Sub-column Field, enter the field name from the incoming payload that contains the data you want to display on the widget. 
2. Next, enter the name you wish to appear on the legend under Sub-column Legend Name.
3. You will then need to select your desired Functionfrom the dropdown menu options:
   • Last value received,
   • Sum,
   • Average,
   • Minimum,
   • Maximum,
   • Last value from each device with common label,
   • File.
4. If you want, you can add a Y-axis Group Name to use a single label for y-axis metrics with matching units of measurement.
   •  For example, you might have a field called Minimum Temperature and a field called Maximum Temperature. Since both have the same unit of measurement, you could enter Temperature as the Group Name for both metrics. Doing so would consolidate multiple y-axis labels into one.
5. We recommend entering the number of decimal places to display in each field using Decimal Precision.
6. You can also select a color for each field using a hex or RGB code. If you don't make a selection, a range of default colors will automatically be applied.
7. Select Show Column Values if you want to display the value of each individual column on your chart.
8. Select Show Column Total if you want to display the total for each column on your chart.

Advanced features

You have the option to configure the following advanced features:

• Choose how often the chart widget will refresh using the Widget Refresh Interval. The unit of measurement is seconds, with a default of every sixty. 
• Enable Display of Future Data will show data with future timestamps on the chart. This display is useful if you have implemented forecasting logic. 
• Select Consolidate and Auto-scale Axes to merge all y-axis ranges into a single range. The minimum and maximum values will automatically adjust based on the payload values.
• You can also configure the date format that displays on the x-axis (X-axis Date Format) or when hovering over data points from the chart (Tooltip Date Format). Select either default (DD-MMM-YYYY, HH:MM:SS), Date Only, or Time Only.

File Display

If you have selected the 'File' function to apply to a default (multi-axes) chart type, you must configure the file icon display. To do so, input the FTP details so the node can fetch the files.

Once configured, clicking on the file icon from the end-user widget will allow you to download the file. Supported file types are MP3, MP4, WAV, CSV, PDF, TXT, JPG, PNG, and GIF.

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

Grouping by Device Label

You need to select how data should be grouped and displayed on the widget. To group data by device label, you must first create at least one label in the Device Labels section of the Workspace. See Creating Device Labels and Configuring Nodes Using Labels for more information.

1. Enter your chosen device label under Device Label Name.
2. Select a method for grouping dashboard data from the dropdown options:
   • No Grouping (widget per device): one Multi Axes Chart widget will appear for each device.
   • Group by device label value (widget per label value): one Multi Axes Chart widget will appear for each unique value label. For example, if the device label is ‘Color’ and the label values are ‘Green’ and ‘Gold’, the dashboard will display two widgets. One will show data for devices labeled ‘Green’, and the other for devices labeled ‘Gold’.
   • Group by device label name (one widget): only one Multi Axes Chart widget will be displayed. It will contain data from all devices that have the device label specified.

See Also: Creating a dashboard, Creating device labels, Configuring nodes using labels
As of Release: 10.02.2022