Search results

Change the Dashboard Parameter value in URL

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>

Dashboard parameter used in URL filter

Dashboard parameter in URl update before

Dashboard parameter in URl update after

Passing Stored Procedure parameter with URL using the Dashboard Parameter

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}}>

Supported Functions

• IN

• NOTIN

IN and NOTIN operators are supported for URL Filter in dashboard parameter.

NOTE: Parameter name is case sensitive.

Supported Data types

• 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>

Stored procedure URL parameter

Using the dashboard parameter syntax, you can pass the dashboard parameter value in URL as follows.

Dashboard parametr in URL parameter

Default parameters

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

• Email

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}}

Default parameter in custom query

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.

Use default parameter in custom query

Default parameter in web URL

You can include the default parameter in the web URL with live connection using the following syntax.

Use default parameter in web URL

Here, Sales Analysis Dashboard is rendered for two users with full name ALFKI and BERGS. The default parameter is applied as follows.

Use default parameter in Sales Analysis Dashboard

For the user ALFKI, the dashboard will be rendered as follows.

Default parameter in Sales Analysis for ALFKI user

For the user BERGS, the dashboard will be rendered as follows.

Default parameter in Sales Analysis for BERGS user