How to find Filter names in Tableau

SPECIAL CHARACTERS HANDLING:
The following characters used in filter Names or in Tableau data cause NO issues : ! * ' ( ) ; : @ & = + $ , / ? # [ ] {}

NOTE: Values with a backslash (\) symbol in the Filter Names may be either returned without this symbol or not included in result set at all, so we recommend that you avoid using the backslash (\) symbol.

Filtering Tableau View Data

Most of the data displayed on the Tableau Views can be filtered by different criteria. You can choose to include all measurements or exclude information that is currently irrelevant for you.

On the example below, all available filters are located to the right of the Sales and Profit graph. They can also be located at the top or to the left of the View. The given example allows modifying the View by including or excluding values from the following filters:

  1. Channel
  2. Country
  3. Product Category
  4. Calendar Date

Adding Tableau Filters to Metric Insights

When setting up data collection for a Metric fetched from Tableau, after you define the respective Workbook and Worksheet that should serve as a Data Source at the Metric Editor > Data tab, you may pre-filter information that is going to be fetched.

To do that, click [+ Tableau Filter]. Next, you can choose whether you are going to define filters manually or via Dimension Values.

NOTE: Examples given below are taken from the Tableau View showed at the top of the page.

Enter Manually

  1. Tableau Filter Name: Copy the name of the filter from Tableau
  2. Filter Values: choose 'Enter Manually'
  3. Click [+ Add Value] and in the opened pop-up manually type in the name of the filter, for example, "Accessory". Save your entry. All the added values should appear in the Values list.

Save your entries.

Using Dimension Values

If you have already used Tableau filters to create Dimensions in Metric Insights, you can quickly choose which Dimension Values you want to use for pre-filtering.

  1. Tableau Filter Name: Copy the name of the filter from Tableau
  2. Filter Values: choose 'Use Dimension Values'
  3. Dimension: select a corresponding Dimension from the drop-down list and all its Dimension Values are going to be loaded to the Values list automatically.

Save your entry.

0 Comments

Add your comment

E-Mail me when someone replies to this comment