Parameter Function

Version

Functions

Parameters can be added and bound in the component settings. You can also bind parameters in filter components of a dashboard, which can pass values to the target components.

Currently, filter components that can bind parameters for value passing include: Time Filter Component, Text Filter Component, and Numeric Drop-down Filter Component.

Using Parameters in Calculation Fields

Use parameters in calculation fields to participate in calculations, and bind parameters in filter components to dynamically control the result values of calculation fields.

For example, you can use filter components to bind parameters for value passing and dynamically changing the measurement standards of large and small orders. When the value of the Numerical Drop-down Filter Component is 2,500,000, 2,500,000 is passed as a parameter to the component for calculation and comparison. Orders with contract amounts greater than 2,500,000 are considered as large orders, with a quantity of 17.

Binding Parameters When Filtering Fields

Bind parameters during the process of filtering fields in the component editing interface and bind parameters for the filtering component to pass parameters for fields filtered.

For example, enter the value 5 in Numerical Drop-down Filter Component to filter out the top five store names by sales. Enter the value 9 to filter out the top nine store names by sales.

Binding Parameters in Detail Filter

Bind parameters, set filter conditions in detail filter of indicators, and bind parameters in the filtering component to dynamically filter.

For example, set conditions for Time Filter Component, and you can see data before certain year and month.

Set filter condition as 2013 Y 8 M, then you can see data before August 2013.

Add a parameter in a component. You can modify the name of it. The parameter types include value, text, and Time. After creating the parameter, you cannot modify its type. There are two ways to create a parameter:

One:

Two:

Parameter is temporarily not supported to be dragged into a component as a separate field.

Field detail filter and binding parameters need to have matching relationships: the corresponding setting content which belongs to text can only be bound to text parameters. Value-oriented content can only be bound to value parameters. Time-oriented content can only be bound to Time parameters. If the filter condition of a text field is set to top N, then the type of the parameter field is value.

A filter component allows binding multiple parameter fields. The same component parameter in the same dashboard can only be bound once by a filter component, and it will be grayed out after binding.

When you bind parameters for a filter component in a dashboard, the system will display corresponding component parameters according to the corresponding filter component type. For example, the system will only display Time parameters for Time Filter Component.

In the filter component editing interface, you can bind SQL parameters.

Supported filter components that can be bound with SQL parameters include Numeric Drop-down Filter Component, Text Filter Component, and Time Filter Component.

The date interval and year-month interval only allow binding parameters according to the start time and end time. Binding according to Year Month Interval will prompt: Binding SQL parameters is not supported.