Tableau: Filter with context

I had to apply a filter on a Top N chart; select a Region, then display Top N States. When I added Region to the filter section. it showed me from the Top N states overall, only the states in the selected region. However I needed to reset the filter top Top N within the selected region.

Notice that Top N filters are applied before regular quick filters, so this just shows of the top N states, which are in the east region. Notice as well that the Region pill is colored in dimensional blue.

Solution: Click the drop down on the region pill on the filter shelf and select ‘add to context’. Context filters are applied before Top N filters, so this then shows the top N states within the context of the selected region. Notice that the Region pill is now colored in grey.

Recent Related Posts
Femke Kooij is a dashboard and report designer, developer and educator specializing in SAP | BusinessObjects Dashboards (better known as Xcelsius) and Crystal Reports. She has also a lot of experience with other SAP | BusinessObjects toolings like, Web Intelligence (WebI), Information Design Tool (Universe Designer), BusinessObjects Data Services (BODS) and the overall server platform BusinessObjects Enterprise (Launchpad, CMC). She spends a lot of her time thinking about and sharing her knowledge of Xcelsius to others through her own blog. Lately she is exploring other visualization tools like Qlikview and Tableau. On the later she is also posting some experiences. Currently she is in the employment of Cognizant Technology Solutions. Her blog only contains her personal views, thoughts and opinions. It is not endorsed by Cognizant Technology Solutions nor does it constitute any official communication of Cognizant Technology Solutions.

This entry was posted in Tableau and tagged , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>