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.

Was this information helpful?
Yes
NoNo
Need more help? Contact support