Parameter Default Value

The value that the Parameter has by default is called the Default Value.
This is the value that the Parameter has before any manual filtering at runtime for example.

Setting Default Value from URL Parameters

URL Parameters actually replace the Default Value when the Dashboard loads.

Setting Default Value from Widgets

It is possible to set a Parameter Default Value by making a selection in the Widget Preview of one of its Master Widgets.

This is explained in the corresponding chapter.

Setting Default Value manually

Default Values can be set manually from the “Default Value” text box :

Text or number Default Values

Text or number default value can be set manually by writing the value in the text box.

Multiple Default Values

Multiple Default values can be set using a comma , as separator :

Date Default Values with Format

For Date type values, it is possible to use a date Format.
This will behave similarly as Data Source Filters on formatted date fields.

Example :

In the Listener Widget relationship, use format “Month” :

Set the Parameter as Integer and in the Default Value text box, you enter 2.

⇒ By default, the month of February (month number 2) is filtered.

Special Default Values

A Default Value with “no content” could actually have different meanings :

• don’t filter (select all items in the Listener Widgets)
• don’t select anything (select nothing in the Listener Widgets)
• select explicitly the NULL value
• select explicitly the empty string ""
  

Select All

If you want the Parameter by default to not filter anything (select all values in the Listener Widgets), click the button Empty/All :

Select None

If you want the Parameter by default to remove every value (select no corresponding value in the Listener Widgets), click the button Empty/None :

Select NULL

If you want the Parameter by default to select the NULL value (NULL in SQL-like Connections, empty cells in Excel, etc), click the button NULL Value :

Empty string

!Erasing the content of the Default Value text box does not remove the Default Value !
Actually it sets the Default Value to be the empty string "".

To let the Parameter have the empty string "" as Default Value, erase all text content :

*Note : the buttons for special values are all white (unselected)

Select a datasource field as default value

It is possible to get a default value from a datasource :

To get a default value, it is needed to :

• Choose a *datasource *from the
• Choose the *field *which will be used as source of the default value
• Select an *aggregation * to define the formation of value
• Some aggregation require an order by from a field (such as First or Last)
  

In this example, the parameter will get a default value from the first item in Value Field ordered by the eqpt field Ascending.

*The default value won’t change after the datasource is loaded even if the datasource content changes (i.e. Filtered by a parameter)

Code192 2020 All rights reserved