Presenting data

The report editor provides a no-code environment for creating tables and charts based on queries. This section guides you through creating tables, charts and reports using the queries you created in Defining queries.

For more complex reporting requirements, you can create an HMI and call the reporting API to retrieve data to display.

Prerequisites

This section assumes that you have:

• Completed the steps in Logging to a database
• Completed the steps in User roles

• Completed the steps in Defining queries

Tables

After you have created some queries, you can define tables to present the results as part of a report. You will create a table to display the Parts and their location history across Process Areas.

1. Open the Tables section of the report editor to create a new table.

2. Name the table ProcessAreas and click Create. The table is added to the list of available tables.

   

3. Click Edit to open the table editor. Read the Defining Tables documentation to learn more about the table interface.

   

4. Select PartsInProcessArea from the Query... dropdown menu.

5. Click the plus button under Columns to add columns for Part, Process Area, the time the Part enters the Process Area, and the time the Part leaves the Process Area.

6. Change the format of the from and to columns to display the date and time.

7. You will notice that the ProcessAreaName parameter is available. Enter Storage to filter your results to only show Parts in Storage Area 1 or Storage Area 2.

8. Save your table.

Charts

Another way to display data from a query is using charts. The first chart you are going to create is a simple bar chart to display the number of times a Part has been in a Process Area.

1. Open the Charts section of the report editor, name the chart ProcessAreasCount and click Create. The chart is added to the list of available charts.

   

2. Click the Edit button next to your chart name to open the chart editor. Read the Defining Charts documentation to learn more about the chart interface.

   

3. Select discrete bar from the available chart types.

4. Add PartsSubquery to the chart and enter a title.

5. Assign parts to the X axis and CountOfProcessArea to the Y axis.

   As soon as the X and Y axis are set, the bar chart will appear at the bottom of the page.

   

It could also be useful to track the location history of each Part. The second chart you are going to create is a location history chart type.

1. Create a new chart called PartLocations.

2. Select location history from the chart type dropdown.

3. Add LocationQuery to the chart.

4. Add Part to the X column, Position to the Y column, and from to the Z column.

5. Select Part as the Category.

6. After you have selected your values, the chart will display at the bottom of the page.

   

7. Click on a Part to view its location details.

   

8. To change the date range, move the slider at the top of the chart.

   

9. Remove a Part from the chart by clicking on the corresponding Part in the legend. Double-click on the Part to select only that Part.

   

Refer to the Available chart types to learn more about all chart types.