3 Replies Latest reply on Nov 9, 2016 3:27 AM by Luciano Vasconcelos

Bar Charts with Multiple Measure (Part of Whole)

Mark Smith Nov 9, 2016 2:34 AM

I have two measures, one of which form part of the other one. I want to show this on a stacked bar chart but without unstacking marks (to show the parts of the whole), any ideas?

Basically I want to create this bar chart but without the need for unstacking marks and changing the transparency. Does it require reshaping the data?

Thanks

Mark

unstacked with transparency.PNG 13.0 KB

1. Re: Bar Charts with Multiple Measure (Part of Whole)

Luciano Vasconcelos Nov 9, 2016 2:59 AM (in response to Mark Smith)
Hi.
See this one.

thread-220037.twbx 354.1 KB
Like Show 0 Likes(0)

Actions
2. Re: Bar Charts with Multiple Measure (Part of Whole)

Mark Smith Nov 9, 2016 3:23 AM (in response to Luciano Vasconcelos)

Hi Luciano

Thanks for the reply, on this example the sales and profit are additive. What I'm looking for is one measure forming part of the other, without having to reshape the data. So I would want the graph to look like the attached, where the total is sales and profit forms part of those sales

Mark
Like Show 0 Likes(0)

Actions
3. Re: Bar Charts with Multiple Measure (Part of Whole)

Luciano Vasconcelos Nov 9, 2016 3:27 AM (in response to Mark Smith)

Mark, it doesn't matter.
You calculate the parts and build using the same mechanism.
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community

Bar Charts with Multiple Measure (Part of Whole)

1. Re: Bar Charts with Multiple Measure (Part of Whole)

2. Re: Bar Charts with Multiple Measure (Part of Whole)

3. Re: Bar Charts with Multiple Measure (Part of Whole)

Actions

More Like This