6 Replies Latest reply on Feb 15, 2012 9:44 AM by jeffhedberg

# How do I put multiple measures on the secondary axis of a dual axis plot?

I'm trying to figure out how to put 2 measures on the secondary axis of a dual axis plot (4 measures on primary y-axis, and 2 meausres on secondary y-axis).  I'm sure that there is an easy way to acomplish this, and that I'm just missing something.

The reason that I need/want to do this is that for 2 of the 6 measures the values are quite a bit different.

Jeff

• ###### 1. Re: How do I put multiple measures on the secondary axis of a dual axis plot?

I don't think there is an easy way.  I was asking the same thing,

and I referenced an earlier post asking the same thing.

1 of 1 people found this helpful
• ###### 2. Re: How do I put multiple measures on the secondary axis of a dual axis plot?

I just can't believe that soemthing so simple is not possible - especially when there is not a limitation placed on the number of measures plotted on the promary Axis.

Can someone from Tableau confirm that this is the case.  Thanks.

Jeff

• ###### 3. Re: How do I put multiple measures on the secondary axis of a dual axis plot?

I got some guidance on this from somebody pretty smart.  He says you can't use multiple measure values pills.  But you can have multiple measures on a dual axis, you just need to reshape your data.

Let's say you have data like this:

Date                  "A" type  "B" type  "C" type  "D" type

1/1/2010               10              20          30          40

and you want A and B to be on the left axis, and C and D on the right axis.  You need to end up with a dataset like this:

Date                 Axis one type     Axis one count     Axis two type       Axis two count

1/1/2010                  A                         10                    null                         null

1/1/2010                  B                         20                    null                         null

1/1/2010                 null                      null                    C                             30

1/1/2010                 null                      null                    D                             40

Then you put sum(axis one count) and sum(axis two count) on rows, set dual axis, and then put Axis one type on the Color for axis one, and Axis two type on Color for Axis two, and then set marks to multiple and set each axis, if you want say, a stacked bar chart on the left and lines on the right.

I just rattled that off quick, not sure if it makes sense, but it works.

• ###### 4. Re: How do I put multiple measures on the secondary axis of a dual axis plot?

What a workaround Ernesto!

I can confirm, Jeff, that it is not currently possible to place multiple measures on both the primary and secondary Y-axis. I would recommend putting a request under Ideas in the Community, as I know you're not the only person to request this!

1 of 1 people found this helpful
• ###### 5. Re: How do I put multiple measures on the secondary axis of a dual axis plot?

Ernesto, I agree with Tracy, nice workaround!

I have already created a version of this idea here:

http://community.tableau.com/ideas/1087

Vote away.

--Shawn

1 of 1 people found this helpful
• ###### 6. Re: How do I put multiple measures on the secondary axis of a dual axis plot?

Thanks for the confirmation Tracy.

Ernesto - You get a gold star for that nice workaround!! That will prove to be very useful until the functionality is added in Tableau to plot multiple measurement pills on the secondary axis.

Jeff