OK, I just undid the "Use as Filter" then rechecked it and am now getting the same results. After clicking the bar, if you switch to your pie chart sheet, you'll see a filter on DVF Count Range.
I think you need to add that to context.
Thanks for your help. unfortunately, when adding to 'Apply context' although the pie chart shows the 5 segmants, i actually expected it to show the 5 segmants of 28, 28, 9, 7, 6.
it doesnt look like it filters correctly based on the TPR Failure Filter - common, and then when selecting the bar.
what i want it to do, is match the pie chart and complete DVC breakdown to its right - it should have the same figures. below is a representation using the Membership status filter - Active. That works fine, just seems to be an issue on the TPR filter
I believe the numbers in the Complete DVC Breakdown chart are actually wrong. You're using a Top N filter on that sheet as well, so I think you probably need to add the remaining filters to context on that one.
The result will be that the pie matches.
Pie Chart Issue - After Filters.twbx 132.1 KB
Hi Ken,thanks for taking a look, the DVC breakdown figures are actually correct based on the TPR Failure Filter of Common and then selecting the middle bar graph.
What is a TOP N Filter? could it be that theres simply too many filters happening here?
Basically if you dont filter using the top filter - TPR failure =Common, and change that to 'All'. and then select the bar graph range 4-6.you can see that the results of the pie chart equals the same as the DVC breakdown,which is what i expected,but you will also notice the figures in the pie chart are the same as those when filtering using TPR Failure =Common,and selecting on the 4-6 range again.
Hope that makes sense, and thank you
We just need to make sure the filters on these two charts match.
What does this filter do?
The reason it concerns me is where it occurs in the order of operations, shown below (see Tableau's Order of Operations - Tableau for more information). Top N filters apply before dimension filters. So this filter, as well as the Top 5 filter on the pie chart, will first be applied, so they will grab the Top N first before any other filters occur. Then the regular dimension filters will be applied. My guess is that you want your regular dimension filters to apply first, so adding those dimension filters to context is critical. Otherwise, your results will not be correct.
Very much appreciated the explanation of the filters above. thats help me to understand.
So that first picture of the Top 1 filter - thats just for my data source filter purposes. Basically whats happening is, we do a number of 'Runs', and all that filter is doing, is picking the latest run - so it brings the latest data set needed.So its fine for this to be at the highest order of my filters.
I think the issue, is then my TOP 5 filter in the pie chart under the DVC CODE. Hence why the DVC breakdown table is correct, because it doesnt need to use a TOP 5 filter, as it just shows all.
I wonder if there is an alternative solution to this? will using some sort of ranking work instead? although im not quite sure how i will apply that as ive not yet used the RANK functionality on tableau yet.