Displaying an Output Table in a Dashboard
Introduction
Functions
The output table calculated from Data Factory can be displayed in a dashboard, which is convenient for enterprise members to view statistical data.
Application Scenarios
- The summary statistics of the curriculum can be displayed on Dashboards for students to view.
- Compute sales data, present it on a dashboard, establish target benchmarks, and track progress towards meeting performance goals.
- Calculate the latest data and display it on a dashboard.
- …
Preview
You can display a class schedule, which is obtained from Data Factory, in a dashboard.
Case
Take designing and displaying a class schedule as an example.
Designing a Form
Create a Class Schedule form and fill in relevant information.
Note: If no course is arranged in a time range, you also need to enter data. All you need to fill in are Day, Start Time, and End Time fields.
The following are the records you enter:
Calculation in Data Factory
You can make calculations in Data Factory after entering all data.
1. Set procedure
Go to App Management > Data Factory > New Data Stream.
2. Set a data stream
Design:
a. Add an input node. For example, you need to display the class schedule on Monday.
b. Select Course Information Entry as the data source for the input node.
c. Add a Data Filter node for the input node to filter the records on Monday.
d. Then add a Field Settings node to remove all the fields that you do not need.
e. After that, connect the Field Settings node to the output node to finish the data stream.
Effect:
Click the output node to preview the effect of the output table, and modify the name of the output node. Note that the output node name equals that of the output table.
Setting Dashboard Permissions
Go to the App Management page and click and then New Dashboard.
Click Detail Table and select the data stream you designed.
Click and then Select All to batch tick the fields you wish to display and untick unnecessary fields.
You can also set Conditional Formatting to set colors for different courses.
Preview
See the section "Preview".
Notes
When you display an output table from Data Factory in a dashboard, only the following components are supported.
- Detail Table
- Stats
- Gantt
Spreadsheet and Calendar are not supported.