Forum Discussion
Selective filters- Limiting interactions to specific fields?
I seem to have found a partial solution by accident, so sharing here (since Googling found no solution earlier):
Change the Table to a Matrix and click the arrow at the top to turn Drill Mode on.
Caveat: You have to have multiple fields set as the Rows, and you can't filter using the bottom layer.
For example, I have Category, Subcategory, and Item - I can click the Category or Subcategory, and the Line Chart will filter to only show that category/subcategory, but clicking Item will not filter the Line Chart to that item.
Fortunately, this is good enough for now, but if there's any recommendations on how to get it down to that bottom level, I'd still appreciate the help!
I seem to have found a partial solution by accident, so sharing here (since Googling found no solution earlier):
Change the Table to a Matrix and click the arrow at the top to turn Drill Mode on.
Caveat: You have to have multiple fields set as the Rows, and you can't filter using the bottom layer.
For example, I have Category, Subcategory, and Item - I can click the Category or Subcategory, and the Line Chart will filter to only show that category/subcategory, but clicking Item will not filter the Line Chart to that item.
Fortunately, this is good enough for now, but if there's any recommendations on how to get it down to that bottom level, I'd still appreciate the help!