Dashboard parameters

You have the possibility to create parameters in the dashboard that will be filled in by the user when he consults the dashboard on the biwee.fr web portal.

These parameters can then be used in the dashboard:

• In a calculated field

• In the filter of a chart component

• In the general dashboard filter

• In the conditional formatting of grids

Create a parameter

To manage the parameters, click on "Dashboard parameters" in the "Settings" menu.

The parameter management window below opens. You can view the parameters (blue), modify them (yellow), delete them (red) and create them (black).

Below is an explanation of the different options when creating a parameter:

General

Field	Description
Visible	Yes: the parameter will be visible on the web and can be modified by the user. No: the parameter will not be visible and modifiable by the user.
Allow Null	Yes: the parameter is not mandatory. No: the parameter is mandatory.
Allow Multiselect	Yes: the user will be able to select several values for the parameter. No: the user can select only one value for the parameter.
Name	Name of the parameter that is used when calling this object in formulas or filters.

Data

Field	Description
Description	Text that appears on the screen when the user is asked to enter a value.
Look-up settings	No lookup : free entry by the user. Static list : combo box proposed to the user with values predefined at the time of the creation of the dashboard. Dynamic list : combo box proposed to the user based on the values of a field in a data source.
Type	Data type of the parameter: string, date, number, ...
Value	Valeur par défaut du paramètre. Peut-être vide, si l’option Autoriser Null est à Oui.

Setup of a parameter fed by a static list:

The user will have the choice to select one or more values from a list box defined at the time of the report creation.

To configure the list box displayed to the user, click on "(Collection)". This allows you to add the values that will be displayed in the combo box.

Setting up a parameter fed by a dynamic list:

When you select "Dynamic list" in search parameters, you will need to enter:

• Data source: name of the data source that is used to feed the different possible values of the parameter.

• Value member: name of the field that is used to feed the possible values of the parameter.

• Display member: name of the field that is displayed.

• Sort by: name of the field used to sort the combo box.

• Sort order: type of sort, ascending or descending.

Using a parameter in a calculated field

1. Create a calculated field either by right-clicking on the data source, or in the dashboard settings menu 🡪 Add calculated field.

2. In the expression editor, you can use a parameter in a calculated field, by double-clicking it in the list box of displayed parameters:

You can also type part of the parameter name directly into the formula, and Biwee will suggest the parameter in the list box:

Using a parameter in a dashboard filter or an element filter

1. Add a dashboard filter or a filter on the data of an item.

2. In the filter editor, choose your condition (And/Or/Not And/Not Or) by clicking on "And", then click on the "+", then choose your operation and finally click on the icon on the left (the little pencil by default) until you get a "?".

Using a parameter in conditional formats

Add a conditional format rule by right-clicking on the grid then Edit rules:

Add an expression type rule:

In the expression window, click on the icon on the right several times, until you get the "?" and select the parameter to be used in the condition evaluation:

Enter the value of a parameter on the WEB dashboard

A window opens to fill in the values of the different parameters.

Fill in the values and click on "Submit".