Loading

Filtering a Range Across Multiple Data Sources

Дата публикации: Apr 13, 2024
Задача
How to filter a range of values across multiple data sources.
Действия
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.
Дополнительные ресурсы
  • 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
Номер статьи базы знаний

001458290

Вложения

Filter Dates Across Data Sources.twbx

176 KB

 
Загрузка
Salesforce Help | Article