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
To let the Parameter have the empty string ""
as Default Value, erase all text content :
Post your comment on this topic.