Hi,
I am exploring context filters and I am seeing that when I try to select multiple options in the context filter, it is not showing correctly for me.
For example, in the attached sheet, if I apply route type="BRTS" and put it in context and then filter for top 5 routes by km, it works.
Similarly it works individually when I select route type as "Non-BRTS".
However when I try putting a filter on route as top 5 by km and try to view it by route type, then I am only getting the top 5 routes and not top 5 in each category BRTS and Non-BRTS, even though I put route type in context.
Ideally I should see 5 entries in BRTS and 5 in Non-BRTS, yet it shows me only the top 5 by route, so the context filter does not work as expected when I select more than one option in it.
Can you help me understand why this is happening and how to fix this please?
I am attaching the notebook with the sheets.
#Tableau Desktop & Web Authoring
You need to create a table calculation to filter the data as shown below: