Measure Names & Values in Tableau

Data

Measure Names & Values in Tableau

by Rob Austin
//

The Value of Measures?

What are Measure Names and Measure Values and how do they work? These are built in Tableau fields and they have 2 main uses or strictly speaking two variations of the same functionality. The first is a Combined Axis Chart and the second is a Crosstab with multiple measures.

Combined axis chart.

A combined axis chart can be used if your measures are similar e.g. if Sales and Profit are both in the same ball park then they could feasibly be put on the same axis without one of them appearing to be permanently zero.

Screen Shot 2014-03-18 at 18.48.44  

The combined axis chart shows Measure Values once in the rows shelf, whilst Measure Names appears three times. I should also point out that a new shelf has appeared called Measure Values.

If we look at the numbers we can see that we have 2 measures in the chart above, Sales and Profit.  This means that the Measure Values are the numbers which correspond to those Measure Names (Sales and Profit). It is the 2 Measure Values which we are plotting on the axis hence that appears in Rows.

Screen Shot 2014-03-18 at 19.11.59

It is the Measure Names which are dividing the colour (Orange for Sales, Blue for Profit) hence that is on the marks card (I have also added it as a label). Finally Measure Names appears on the filters shelf because we have more than 2 measures in our dataset but we only want to display Sales and Profit.

Shortcut: How to create a combined axis chart in 3 steps.

  1. Order Date to Columns
  2. Sales to Rows
  3. Profit to Axis.

When performing step 3 you need to make sure that you drag the profit field on to the existing axis such that a faint green double-ruler appears.

Screen Shot 2014-03-19 at 07.29.09


CrossTab (Table) with Multiple Measures

Shortcut: How to create a Crosstab from Multiple measures in 3 steps

  1. Order Date to Rows
  2. Sales to Workspace, where it says ‘abc’ in the pane
  3. Profit to Workspace, where the Sales figures now are. (or you can double click Profit)

Let’s consider a table with a set of dimensions (Quarter of Order Date) and one measure per column. Measure Names / Measures Values are essentially data reshaping tools.

Screen Shot 2014-03-19 at 07.39.51

To look at it another way what we have are two dimensions and some values. The first dimension contains: Q1,Q2,Q3,Q4.

The second contains the headers (Measure Names): Profit, Sales and Discount.

The table to the right is what is effectively happening in the background when we use Measure Names & Measure Values to create a Crosstab from multiple measures.

The Rows are Quarter of Order Date and the Columns are Measure Names. It is this data reshaping that makes it so effortless to create the table below.

Screen Shot 2014-03-19 at 08.13.15

Screen Shot 2014-03-21 at 09.08.21

 


 

More About the Author

Rob Austin

Consultant
Using Tableau on your Mobile I have been using Tableau since version 4, initially as a Tableau customer. One of the first things I wanted was to be able to see my ...
Tableau Level of Detail Calculated Fields v9 In this tutorial I talk about the Tableau Level of Detail calculations  {fixed}, {include} and {exclude} which are new in Tableau ...

See more from this author →

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072

×

Love our blog? You should see our emails. Sign up for our newsletter!