You can achieve this using Dashboard action in tableau where parent dashboard will be considered as source dashboard and target as child.
You can select action type as filter or Hover.
Hope it helps:
It is a sequence of hierarchies on different dimensions on both the donut sectors. Donut must update with the labels related to the particulate dimension filtered on the other.
first pie or donut Chart:-
first Hierarchy on first pie:-
Second Pie or Donut Chart:-
Second Hierarchy on second pie:-
If i click on first pie sector (consumer) then the second pie sectors has to change to next level of hierarchy as taken in the second pie as ship mode but it is showing the top region hierarchy only it is not drill down to the next one.
Please help me with the work around till the last level of hierarchy.
It will be a level of hierarchy should apply on the sheets till the lower level in the hierarchy we mentioned.
Manoj Reddy Yaram
Ohk, So it will not drill down further as per your hierarchy. Basically there are two workaround to achieve this:
1: Create a parameter for which will define your hierarchy region- ship mode ---
Then create a calculate which will act as column selector (Refer below link) for your Pie:
Option 2: Create individual pie chart for each hierarchy item. Then apply sheet selector dashboard action to navigate(Menu action) to required chart.
But if your requirement to expand your target pie as per parent child relationship then you can click on expand option to get that.
Hope this helps.