7 Replies Latest reply on Jun 19, 2019 11:42 AM by Ken Flerlage

Sorting segments with stacked bars by value breaking the filter

Alyssa Rong Jun 19, 2019 9:05 AM

Hey guys. I followed the steps on this post https://kb.tableau.com/articles/howto/sorting-segments-within-stacked-bars-by-value

So my goal is to create a sorting / top N filter for each bar in my stacked bar chart and this post solved the problem.

In this sample worksheet I created. The first tab "Stacked Bars" - using Region as attribute shows the ideal results of sorting the largest components of each bar on the top and smallest at the bottom. The second one is the normal sorting which didn't give back the "correct" sorting in my opinion.

But making the dimension I put on the color details into an attributes breaks my hover over filter. I hope to hover over the segments and filter my 3rd sheets to give the details of sales for each specific colored segments.

Is there anyway to solve the problem to sort the bar without breaking other things?

Any thoughts will be greatly appreciated!!

sorting stacked bar SAMPLE.twbx 1.2 MB

1. Re: Sorting segments with stacked bars by value breaking the filter

Ken Flerlage Jun 19, 2019 8:47 AM (in response to Alyssa Rong)

Can you attach your packaged workbook so we can take a look?
Like Show 0 Likes(0)

Actions
2. Re: Sorting segments with stacked bars by value breaking the filter

Alyssa Rong Jun 19, 2019 9:13 AM (in response to Ken Flerlage)

Hey Ken,

Thanks for your message. I have attached a sample in my question description. Please let me know if I didn't make it clear.

Thanks!

Alyssa
Like Show 0 Likes(0)

Actions
3. Re: Sorting segments with stacked bars by value breaking the filter

Ken Flerlage Jun 19, 2019 9:15 AM (in response to Alyssa Rong)

If you drag Region to the detail card, it should work.
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
4. Re: Sorting segments with stacked bars by value breaking the filter

Alyssa Rong Jun 19, 2019 9:30 AM (in response to Ken Flerlage)

Hey Ken,

Thanks!!! This is quite amazing! I'm new to tableau and still learning and improving. Can you kindly elaborate more on how this detail mark works?

Thanks, I will mark this as correct answer and close the question.

Alyssa
Like Show 1 Likes(1)

Actions
5. Re: Sorting segments with stacked bars by value breaking the filter

Ken Flerlage Jun 19, 2019 10:54 AM (in response to Alyssa Rong)

The detail card defines your level of detail. So, for example, if I have a bar chart like this:
The level of detail for this is Region so we only have one "mark" (in this case, a bar) for each region.

But, if we drop State on Detail, it will change the level of detail to Region/State and will break each bar up by State.
You can see it more clearly if I also color by State.
That, at a high level, is what the Detail card does. But other things, such as what's on Rows and Columns and what's on Color, also define your level of detail (not just the Detail card). In the case above, the problem is that your viz-in-tooltip was trying to filter on ATTR(Region), which it can't do, so by dropping Region on the detail card, I made region available for filtering. Hope that helps a bit.
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
6. Re: Sorting segments with stacked bars by value breaking the filter

Alyssa Rong Jun 19, 2019 11:36 AM (in response to Ken Flerlage)

Thanks for your detailed explanation Ken! So although the region was a layer of LOD but it wasn't available and specifically defined as detail. Dragging it to the detail mark basically specify that this is also a level of detail. Got you! This is very helpful !!! Appreciated!
Like Show 0 Likes(0)

Actions
7. Re: Sorting segments with stacked bars by value breaking the filter

Ken Flerlage Jun 19, 2019 11:42 AM (in response to Alyssa Rong)

Any time!
Like Show 0 Likes(0)

Actions