Was this page helpful?
Yes No
Have a comment? Please leave it here. Thanks for your feedback!
All Tableau Help > Tableau Desktop and Web Authoring Help > 
Applies to: Tableau Online, Tableau Server

How View URLs Are Structured

To understand how Tableau structures view URLs, let's take a close look at an example in the browser address bar.

In this article

The structure of the base URL

Adding parameters to the base URL

Select an example view to work with

Filter the view

Exclusive filtering

Special considerations for date filtering

The structure of the base URL

Adding parameters to the base URL

To create a filtering URL, you append a query string to the base URL.

Within the query string, parameters (filters) are separated by ampersands (&), and multiple values per parameter are separated by commas. For example:

http://<servername>/#/views/<workbook>/sheet?param1=value1,value2&param2=value

In addition, any characters in your field or sheet names that cannot appear in URLs are URL encoded. For example, a space is converted to %20.

Note: Before you add URL parameters, remove :iid=[#] at the end of the URL. This is a temporary view counter for your current browser session.

Select an example view to work with

The examples in this article use the Performance view, in the Superstore sample data that comes with Tableau Server:

The example URL reflects the following attributes:

To follow along with the examples, you can look at a similar view from Superstore, or you can adjust the example URLs to use the field, sheet, and other names from your own environment. If you are using your own view, make sure you publish it to the server.

Filter the view

For the example view used in this article, the base URL is:

http:<servername>/#/views/Superstore/Performance

Furniture Only

To display only sales of furniture, at the end of the URL, add the following query string:

?Category=Furniture

For example:

http:<servername>/#/views/Superstore/Performance?Category=Furniture

Consumer Only

To limit the view to Consumer sales, change the URL to:

http:<servername>/#/views/Superstore/Performance?Segment=Consumer

Home Office and Consumer

To show both home office and consumer sales, change the URL to:

http:<servername>/#/views/Superstore/Performance?Segment=Home%20Office,Consumer

Notice that in the field name "Home Office," %20 represents the URL-encoded space character, as described in Adding parameters to the base URL.

Here multiple values are separated with a comma, but not a space.

Furniture in the Central

To show multiple field/value pairs, separate them with an ampersand.

http:<servername>/#/views/Superstore/Performance?Region=Central&Category=Furniture

Exclusive filtering

So far the examples shown in this article display all values for the fields in the resulting views. For more flexibility, you can specify multiple values for a specific filter, and include an additional parameter that displays only particular intersections of those values.

The following URL describes the base, unfiltered view used in this example, showing department sales by region.

http://<servername>/#/views/Superstore/Performance

Next, to show sales for only the Furniture and Technology departments in the Central and West regions, you would add the following query string to the base URL:

?Region=Central,West&Category=Furniture,Technology

To show only Furniture sales in the Central region and Technology sales in the West region, add the ~s0 parameter to the query string used in the previous step.

?Region~s0=Central,West&Category~s0=Furniture,Technology

The final URL looks like this:

http://<servername>/#/views/Superstore/Performance?Region~s0=Central,West&Category~s0=Furniture,Technology

Special considerations for date filtering

When you want to filter date fields, take into account how dates are formatted and behave in a database environment:

Example Date parameters

The following example query strings use a date field called Order Date. As in the previous examples of this article, you would add these to the base URL of your view.

Parameters as DATEPART filters

To filter by date part, use the same nomenclature as in the default Tableau Desktop date hierarchy. For more information, see Date Functions in the Tableau Help.

year(Order%20Date)

Integer

quarter(Order%20Date) Integer between 1 and 4
month(Order%20Date) Integer between 1 and 12
day(Order%20Date) Integer between 1 and 31
hour(Order%20Date) Integer 0–23
minute(Order%20Date) Integer 0–59
second(Order%20Date) Integer 0–59
week(Order%20Date) Integer 1–53
my(Order%20Date) Six-digit integer: YYYYMM
mdy(Order%20Date) Eight-digit integer: YYYYMMDD