Last Modified Date: 26 Oct 2022
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.- In the Data pane, right-click and select Create a parameter.
- Rename the parameter "Start of Range".
- In the Data Type drop-down menu, select Float, Integer or Date.
- In the Current Value Field, input the Start Date or first number in range.
- Select Range in the Allowable values.
- Choose the different range of values of the data and click OK.
- Repeat the above steps to create an End of Range parameter.
- Select Analysis > Create Calculated Field.
- 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]
- Name the field and click OK.
- Drag the calculated field to the Filters shelf and filter on True.
- Create an identical calculated field in every data source to be filtered.
- Right-click on the End of Range parameter in the Parameters pane and select Show Parameter Control.
- 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.
Creating a Filter for Start and End Dates Using Parameters
Filtering Across Multiple Data Sources Using a Parameter
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials