By using dashboard parameters the user can change the value of the URLs dynamically.
You can pass the parameters to a dashboard by including them in a dashboard URL. Passing parameter values within the URL will apply a filter in the dashboard on the initial load itself.
To set a dashboard parameter within a URL, use the following syntax:
For single parameter:
<parameter1>=<value>
For multiple parameter:
<parameter1>=<value>&&<parameter>=<value>
Using the syntax, you can pass the dashboard parameter value in the URL as follows.
https://<servername>/dashboards/<dashboardid>/<category>/<dashboardname>?&&<parameter1>=<value1>&&<parameter2>=<value2>
You can pass the stored procedure parameters to a dashboard by including them in a dashboard URL. Passing parameter values within the URL will apply a filter in the dashboard on the initial load itself.
To set a dashboard parameter within a URL, use the following syntax:
For single parameter:
@<parameter>=<value>
For multiple parameter:
@<parameter1>=<value1>&&@<parameter2>=<value2>
For dashboard parameter:
@<parameter>=<@{{:DashboardParameterName}}>
• IN
• NOTIN
IN
and NOTIN
operators are supported for URL Filter in dashboard parameter.
NOTE: Parameter name is case sensitive.
• Character and String
• Numeric
• Date and time
• Binary
For date type parameter values, you can provide the server (where the query will be executed) supported date format as parameter value.
To append your query string with URL, add a prefix (?) to the query string. If (?) is already there in the URL, add a prefix (&&) to the query string.
https://<servername>/dashboards/<dashboardid>/<category>/<dashboardname>?@<parameter1>=<value1>&&@<parameter2>=<value2>
Using the dashboard parameter syntax, you can pass the dashboard parameter value in URL as follows.
Default parameters enhances to filter the data based on the current user. It can be passed in custom query and web URL. Currently, the default parameter is supported with,
• Full name
For the current user, use the following syntax to filter the data based on full name.
Syntax: @{{:CURRENTUSER.FULLNAME}}
For the current user, use the following syntax to filter the data based on email.
Syntax: @{{:CURRENTUSER.EMAIL}}
Include the default parameter by pressing the key Shift+2
, to list the default parameter along with the available user defined parameters. You can use it anywhere in query editor window.
Another way is, user can manually type the default parameter in code view using the following syntax.
You can include the default parameter in the web URL with live connection using the following syntax.
Here, Sales Analysis Dashboard is rendered for two users with full name ALFKI and BERGS. The default parameter is applied as follows.
For the user ALFKI, the dashboard will be rendered as follows.
For the user BERGS, the dashboard will be rendered as follows.