Creating Combined Sets 

Combined sets in Tableau allow you to create sophisticated data segments by merging two or more existing sets using set operations. You can combine sets using three logical operations: Union (members in either set), Intersection (members in both sets), or Difference (members in one set but not the other).

When working with Kyvos semantic models, combined sets operate on semantic model data, ensuring fast performance even with complex multi-criteria conditions across large datasets. Combined sets maintain the dynamic nature of their component sets, automatically updating when the underlying model data refreshes or when dynamic set conditions change. They are particularly powerful for creating layered segmentation logic, such as identifying customers who are both high-value AND recent purchasers, or products that are top sellers BUT not in a specific category.

Combined sets enable complex comparative analysis, advanced filtering scenarios, and sophisticated audience segmentation while leveraging Kyvos' intelligent query optimization and aggregation capabilities for responsive analytics.

To create combined sets, perform the following steps.

1. Connect Tableau to the OrderDate Kyvos semantic model.

2. Click CustomerName > Create > Set.

   Open

   

3. Create a set to obtain the top 10 customers by sales.

   Open

   

4. Create another set on the Customer Name to obtain the bottom 10 customers by sales. 

   Open

   

5. Right-click any of the created sets and select Create Combined Set.

   Open

   

6. Select two sets you want to combine. Also, choose any one logic like Union (OR logic), Intersection (AND logic), Difference (exclusion logic), and click Ok.  

   Open

   

7. Drag the combined set into the filter shelf to retrieve values based on the underlying logic. Here, you get the top and bottom 10 values combinedly as you choose Union logic while creating a set. 

   Open