KNOWLEDGE BASE

Filtering a Range Across Multiple Data Sources


Published: 17 Jul 2014
Last Modified Date: 23 May 2016

Question

How to filter a range of values across multiple data sources.

Environment

  • Tableau Desktop
  • Multiple Data Sources

Answer

Create a Start of Range parameter and an End of Range parameter to filter across the data sources.

 

  1. In the Data pane, right-click and select Create a parameter.
  2. Rename the parameter "Start of Range".
  3. In the Data Type drop-down menu, select Float, Integer or Date
  4. In the Current Value Field, input the Start Date or first number in range. 
  5. Select Range in the Allowable values. 
  6. Choose the different range of values of the data and click OK
  7. Repeat the above steps to create an End of Range parameter.
  8. Select Analysis > Create Calculated Field.
  9. In the Formula section of the Calculated Field dialog box, enter a formula similar to the following, where "Field to Filter" corresponds to the Date dimension in the data source: 
    [<Field to Filter>] <= [End of Range]
    AND
    [<Field to Filter>] >= [Start of Range]
  10. Name the field and click OK.
  11. Drag the calculated field to the Filters shelf and filter on True.
  12. Create an identical calculated field in every data source to be filtered.
  13. Right-click on the End of Range parameter in the Parameters pane and select Show Parameter Control.
  14. Right-click on the Start of Range parameter in the Parameters pane and select Show Parameter Control.

Additional Information

  • The result can be reviewed in the attached example workbook. 
  • It is not possible to display the filter as a slider. 
  • Each parameter must be configured individually. 
Did this article resolve the issue?