Filters are used in Tableau to restrict the number of records in a said dataset.

There are 5 types of Filters that are used for various purposes.

  • Extract Filters: This type of filter is used to extract data from a specific data source and creates a copy in the local Tableau Repository. The extract filter is on the top right corner of the data source tab.
  • Data Source Filter: This kind of filter is used to filter data at the source level. Its main function is to restrict the number of records in the dataset. It has the same features of Extract Filter on securing data.
  • Context Filter: This is a type of an independent filter which is able to create a separate datasheet out of a data set, compute and display the selections made in a worksheet.
  • Dimension Filter: This type of filter is used to segregate data on the basis of dimensions. It’s a type of non-aggregated filter in which multiple dimensions, groups, sets, and bins can be added. This type of filter can be applied through the top or bottom conditions, wildcard match and formula.
  • Measure Filters: A type of aggregated filter is used to filter on the basis of calculations applied on specific measures. While you may use data values in a Dimension Filter, Measure Filter allows users to segregate measures on the basis of calculations subjected to it.
BY Best Interview Question ON 01 Mar 2020