6 Replies Latest reply on Oct 3, 2016 2:55 PM by Ryan Slagle

# Two measures on the same row

I need to set the visual on the right (blue squares) like the visual on the left (green squares).

For reference, SA = Strongly Agree, and TA = Total Agree

I want both results (SA and TA) on the same square per category.

How can I leverage Tableau to reorganize the data to achieve the desirable outcome?

• ###### 1. Re: Two measures on the same row

Hi Diogo Braga,

Here i have solved as per your requirement. Kindly go through the attached workbook. May be this will helpful to you.

Regards,

Triveni.

• ###### 2. Re: Two measures on the same row

Thank you! That's one way to do it. I want to keep it all in one sheet though. It's easier to manage.

• ###### 3. Re: Two measures on the same row

Hi here i have made some changes into the attached workbook plz go through it.

• ###### 4. Re: Two measures on the same row

I need both numbers on a perfect square. Although you have an interesting solution, it's not what I am looking for. I need to have SA and TA in a square within a row.

• ###### 5. Re: Two measures on the same row

I think the biggest challenge is in how your data is structured. Tableau works best with "tall" data rather than "wide" data. You can pivot your data in the Data Source tab and slice it up a bit so that you've got a dimensions list that looks like this:

Parent or Staff

Percentage or School Code

SA, TA, or School Code

Once you've got your data restructured, this should be a much more accomplishable task. I'll keep working on it tomorrow (I've gotta head home now), but I've had better luck so far with it being restructured. Plus, these are restructures you can do at the Tableau level, so if you can't modify the data itself we'll still get you there!

1 of 1 people found this helpful
• ###### 6. Re: Two measures on the same row

Hi Diogo,

Take a look at the attached workbook. I restructured your data using Tableau's built in 'pivot' feature on the data source tab. Then I split one of your dimension columns into 3 parts. A couple calculated fields later and I had a solution.

-Ryan

1 of 1 people found this helpful