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.
Discuss this article... Feedback Forum
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