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 a 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 the URL as follows.