Course Content
1.2 Create and manage data model
Manage data model with Relationships and Joins
0/4
1.3 Manage metadata properties
Metadata is data about data.
0/1
2.2 Organize data and apply filters
2.2.1 Create groups by using marks, headers, and the data pane 2.2.2 Create sets by using marks and the data pane 2.2.3 Organize dimensions into a hierarchy 2.2.4 Add a filter to a view 2.2.5 Add a date filter
0/6
Protected: Tableau Specialist Certification
About Lesson

Filter quantitative data (measures)

Measures contain quantitative data, so filtering this type of field generally involves selecting a range of values that you want to include.

When you drag a measure from the Data pane to the Filters shelf in Tableau Desktop, the following dialog box appears:

Select how you want to aggregate the field, and then click Next.

In the subsequent dialog box, you’re given the option to create four types of quantitative filters:

Range of Values: Select the Range of Values option to specify the minimum and maximum values of the range to include in the view. The values you specify are included in the range.

At Least: Select the At Least option to include all values that are greater than or equal to a specified minimum value. This type of filter is useful when the data changes often so specifying an upper limit may not be possible.

At Most: Select the At Most option to include all values that are less than or equal to a specified maximum value. This type of filter is useful when the data changes often so specifying a lower limit may not be possible.

Special: Select the Special option to filter on Null values. Include only Null values, Non-null values, or All Values.

Note: If you have a large data source, filtering measures can lead to a significant degradation in performance. It is sometimes much more efficient to filter by creating a set containing the measure and then apply a filter to the set. For more information about creating sets, see Create Sets(Link opens in a new window).


Exercise Files
No Attachment Found
No Attachment Found

Fans of data should know how to have fun with data.

Links

Copyright© 2022 Dance Sing with Data | All rights reserved.