Dynamic Control of Result Values Through Parameters in Calculation Fields

Version

Application Scenario

You may need to dynamically control the result value of a calculation field. In this case, you can use parameters in the calculation field and bind parameters in filter components .

For example, you can bind parameters in filter components for value passing and dynamically change the measurement standards of large and small orders. If the value of the Value Drop-down Filter Component is 2000000, this value is passed as a parameter to the component for calculation and comparison. Orders with contract amounts greater than 2000000 are large orders, with a quantity of 41.

Implementation Method

1. Add a value parameter.

2. Add a calculation field with the value parameter involved in the calculation.

3. Create a chart, add a dashboard, and drag the component to the dashboard.

4. Add a value filter component, bind the value parameter, and add a custom value list.

Chart Creation

1. This document takes the table Regional Data Analysis as an example. Create an analysis subject and add a value parameter, as shown in the following figure.

2. Add a calculation field named Order Size and enter the formula, as shown in the following figure. When the order contract amount is greater than the value entered in the value drop-down filter component, the order is a large one.

Note:

The contract amount and filter component must be selected from the left field column and cannot be manually entered.

3. Create a column chart, drag Order Size to Horizontal Axis and Count to Vertical Axis, and drag Count to Size, as shown in the following figure.

4. Click the Add Dashboard icon and drag the created component to the dashboard, as shown in the following figure.

Filter Component Setting

Custom Value List Adding

After adding a custom list, you can select specific values as parameter values from the drop-down list of the filter component.

Add a Value-Drop-down Filter Component, select Custom Value List, click the  icon, enter 1000000, 2000000, 3000000, and click OK, as shown in the following figure.

Custom Value List Manually Entering

You can also manually enter a value. Only select Custom Value List and enter the needed value in the edit box, as shown in the following figure.

Filter Component Parameter Binding

Select Bind Parameter, click the  icon, select Value Parameter, and click OK, as shown in the following figure.

 

Effect Display

You can change the measurement standards of large orders and small orders as needed.

The following figure shows the effect of adding a custom value list.

The following figure shows the effect of manually entering a value. After entering, you can press the Enter key to view the effect.