Comment on page
Create Data Visualization
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.
- 1.Ensure that you are in
- 2.To add a new data visualisation, ensure that you have no objects currently selected, and click
- 3.Give your data visualisation a label
- 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
- stays closed, click to 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.
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.
In the Add Data Source dialog, ensure your payload is in CSV format
We will make a table chart
- 1.Choose the
Labelof 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
Aggregatefeature, and scroll down to
SUMthe number of tasks for robots of each category
Note: you can use the
Aggregatefeature 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
Functionlets you decide how you wish to combine the data.
Additionally, you may sift out relevant data from a large dataset using the
- 3.Afterwards, pick the
Valuethat 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