Filtering or Highlighting Using Histogram Bins
Graham Bortz May 23, 2012 3:53 AMHi All
I have a single set of data , each item having 2 dimensions (X and Y )
I have two different sheets , a sheet with a histogram of X , and a sheet with a histogram of the Y Value.
I want to filter the 2nd histogram , based a a bin selection of the first histogram either at sheet level , but eventually at Dashboard level.
I can 1/2 achieve this only by making the level of detail at the item level, that means I can only filter at the item level and not the bin level. What I really want to do is make the level of detail of the first sheet ( X) , the bin , and the level of detail of the second sheet , the item , so when I sellect a bin at the first sheet , it shows me where all the items are in the second sheet ie using Tableau to animate conditional distributions.
I have attached a workbook , with the sheets and the dashboard.
If you click on the left histogram it will show you the corresponding item in the right histogram, , if you try and select the whole bar say the middle bar , by dragging a rectangle over it , it shows a selection of 41 items in the right , where there are only 4 items in that bar , it will only work if I choose the whole bar item for item ( X) , but this is not realistic, if pou have 10 K items. See image attached
Therefore :
1) Is what I am doing possible ?
2) If so how? ie have I done the Highlight action correctly , and are my levels of detail in each sheet appropriate , I should have the level of detail in the first sheet at the bin category , and the second sheet should be at the Y measure
3) If not , how can I do this differently for the same effect ... I can probably do it by quick filtering , but its not as visually appealing
I have attched an image where you see the selection on the left ( 4 items ) highlights 42 items on the right , while there are only 4 items on the left ( see count on the left graph y Axis.
Any Takers for this one !!!
A solution will bed much appreciated.
The Tableau Apprentice
-
fuiltering using histograms.png 110.7 KB