SET ANALYSIS:
- SET Analysis helps end users focus on specific data groups, allowing us to use it in expressions for charts, measures, and calculated fields. This enables dynamic data analysis for comparisons and complex calculations without changing overall selections.
- Using SET Analysis improves performance and enhances our insights, making our dashboards more effective.
Component of SET Analysis : Identifiers, Operators, and Modifiers
IDENTIFIERS:
- {$} = Current Identifier
- {1} = Full Dataset
- {$1} = Previous Selections
- {$_1} = Next Selection
- {BMK} = Bookmark Selection
- {State} = Alternate State
Example: Sum({Identifiers}Sales)
MODIFIERS:
Example: Sum({Identifiers<Modifiers>}Sales)
OPERATORS:
- Union (+) : Returns all records that are part of the combined sets.
- Exclusion (-) : Returns records that are in the first set but not in the second set.
- Intersection (*) : Returns records that are in both sets.
- Symmetric Difference (/) : Returns a set that belongs to one of the sets, but not both.