Create Data Visualization

Contents

• Overview of Data Visualisation Controls

• How to create a Gauge Chart

• How to create a Table Chart

There are 4 types of charts you can use to display your data:

1. Value Charts

2. Gauge Charts

3. Table Charts

4. Bar Charts

The creation process for value charts and gauge charts are similar, while the creation process for table and bar charts are similar.

How to create a Gauge Chart

1. Ensure that you are in Planner mode

2. To add a new data visualisation, ensure that you have no objects currently selected, and click Data Visualisation

3. Give your data visualisation a label

4. Choose the data source that you wish to display in the live view. See Add Data Source if you have no data sources in your list yet

5. Choose the data source that you wish to display in the live view

6. For this example, we will be adding a gauge chart

7. Input the query to select the data you want from your data source

   1. If the data source is a REST API connection and returns JSON as its response, use a JSON path to select the data you want from your API endpoint. To learn how to choose the JSON path, see Specifying a JSON Path

   2. If the data source is a SQL connection, use a SQL query to select the data you want from the database.

8. Set the minimum and maximum values that this gauge can take

9. Set how frequently you want your API endpoint to be called

10. Choose whether the chart is folded into its label by default, or is expanded, displaying its value

• Default

  • stays closed, click to expand

• Expand

  • stays open, click to hide

11. To colour the values when they cross your thresholds, you can add a range to colour the chart

12. Set the minimum and maximum value of the range and its corresponding colour

13. These are the colours available

14. Save your chart once you have finished configuring it

15. Congratulations, your chart successfully appears in the environment.

How to create a Table Chart

For this example, we will create a table that shows us the total number of tasks that each type of robot in our factory completes.

Firstly, follow step 1-4 of How to create a Gauge Chart. Note that the data source you use must be a CSV data source. To learn more, see Add Data Source

In the Add Data Source dialog, ensure your payload is in CSV format

We will make a table chart

1. Choose the Label of the items you wish to see. It will be the first column. For this example, I want to see the tasks done for each category of robot.

2. To make it add the number of tasks for each type of robot, we will use the Aggregate feature, and scroll down to SUM the number of tasks for robots of each category

Note: you can use the Aggregate feature to group or combine data together. It is useful as it can summarise a large dataset, enable the identification of trends and patterns, enable comparisons, and support decision-making. The Function lets you decide how you wish to combine the data.

Additionally, you may sift out relevant data from a large dataset using the Label Filter.

3. Afterwards, pick the Value that you wish to monitor. I will be looking at the number of tasks done by the robots.

4. Set colour ranges for each value to warn you when you want to notice values above certain thresholds

5. To see the table expanded in viewer mode, select the expanded option. Otherwise, it will be folded into an icon by default.

6. Save your chart once you have finished configuring it

7. Congratulations, you have successfully created a table chart