Hello All…
Here I am coming with new challenge. Its simple but interesting for me to solve. Have you ever asked or thought to implement metric drill down? Let’s see…
Long back someone asked me to drill down from summary to detail based on what ever metric they click on summary page. At that time I told it's not possible in tableau. This concept exists in OBIEE report.
Now metric specific drill down is possible in Tableau. See below scenario and try to solve this challenge.
If you see below image. If I click on Profit, I can see sheet 2 filtered for profit.
If you see below image. If I click on Sales, I can see sheet 2 filtered for Sales.
Similarly, If I click on central region for Profit, I can see sheet 2 filtered for Central and profit will show .
Similarly, If I click on East region for Sales, I can see sheet 2 filtered for East and Sales will show.
See here how metric action works in tableau. Now Try by your self...
If you see below image. If I click on Profit, I can see sheet 2 filtered for profit.
If you see below image. If I click on Sales, I can see sheet 2 filtered for Sales.
Similarly, If I click on central region for Profit, I can see sheet 2 filtered for Central and profit will show .
Similarly, If I click on East region for Sales, I can see sheet 2 filtered for East and Sales will show.
See here how metric action works in tableau. Now Try by your self...
For more challenges: Click Here
Experiment… Observe… Learn…