Dashboard Example - Chart

In the quick start, we use templates GettingStartedEN.cpt As an example, this paper describes the implementation method of this template. Then how to use the dashboard to achieve such an effect? The following is a detailed introduction.

Click File > New Dashboard to create a new dashboard, as shown in the following figure:

From GettingStartedEN.cpt We can see that you need to use widget component (in parameter pane), report component and chart component. First drag into parameter pane, then drag label widget (setting the widget value of label as region), drop-down box widget and query button into parameter pane, and then drag report block and chart into the main body of dashboard Block, as shown in the figure below:

The purpose of this dashboard is to query the sales volume of products in different regions, so the new data set DS1: select * from sales_volume where Region = '${region}', the default value of region parameter is East China, as shown in the figure below:

Next, you need to add data for each component.

1. drop down box widget

Select the drop-down box widget, click the data dictionary, select the region field of the sales table in FRDemo database, and modify the name of the widget in the drop-down box to region, and set the value to East China, as shown in the following figure:

Note: it's better to set the default value of the filter control, because if there is a chart component below, you need to load the default value of the control to filter during initialization. If there is no default value, the chart component will have no data and display as blank.

2. Report components

Click the stylus in the middle of the report block to switch to the edit interface of the report block, and drag in the fields as shown in the figure below

3. chart components

After editing the report block, click the dashboard button below the body to return to the dashboard body design interface, select the chart > data for the chart component in the chart attribute table data on the right, as shown in the following figure:

For other property settings of chart components, please check chart styles and chart special effects.

Save the template, click the Preview button and open it on the web side, as shown in the figure below. During initialization, click the query button to display the data of East China by default. Click the drop-down box widget and select North China. The data of report block and chart block will also be able to change to display the data of North China

For completed templates, please refer to:

%fr_HOME%\webapps\webroot\WEB-INF\reportlets\doc-EN\Dashbaord\DashboardStarted.frm

Click to download the template: 

DashboardStarted.frm