Sets are custom fields that are used to define a subset of data. The defined subset can be dynamic or static and can be used to create different visuals. We can also combine multiple sets. Sets have the advantage of being reusable across all worksheets, and they get added to the dataset's metadata too.
Dynamic sets: These are sets based on certain conditions that can lead to different results as the data changes. Top n or Bottom n sets are common use cases of this. For example, what percentage of the total sales came from the top 10 countries?
To solve this, we will create a set for the top 10 countries by sales first. Right-click Country, select Create and then Set. Then, under Create | Set, rename the set Top 10, and go to the Top ...
