Loading

Filtering a Range Across Multiple Data Sources

Udgivelsesdato: Apr 13, 2024
Opgave
How to filter a range of values across multiple data sources.
Trin
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.
Yderligere ressourcer
  • 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
Vidensartikelnummer

001458290

Vedhæftede filer

Filter Dates Across Data Sources.twbx

176 KB

 
Indlæser
Salesforce Help | Article