Scenario 1: Creating combinations of fields
Let's say you want to filter out values where "Category = Furniture" and "Region = Central." You can create a set using "Category" and "Region", then filter the set based on that unique combination of values. An example of this is as follows:
- Create the set
|Set of Category and Region|
I'm not sure what affects the ordering of the fields in the set. I do know that dragging them around in the "Create Set" window has no effect on its display. If you don't initially get the ordering you want, keep creating sets until you get the ordering you want. Make sure to delete all of the extra sets. If anyone knows how to change the ordering, please comment. I'd love to find out why.
- Filter the value
|Filter on Category and Region|
|Sales by Category and Region (without Furniture, Central)|
Imagine that your data is quite complex and you only want to look at a particular subset. You could create a global filter for this, but that would affect all of your graphs. So, let's create a set which stores a particular subset of the data.
- Choose your fields.
- Apply the filter condition you want, e.g. "Top 10"
|Top 10 Products by Total Sales|
I hope you found this informative. Feel free to comment if you have any questions/suggestions. Thanks for reading.