Measures and dimensions

The fields from the data source are visible in the data pane and are divided into Measures and Dimensions. The difference between measures and dimensions is a fundamental concept to understand when using Tableau:

  • Measures are values that are aggregated. For example, they are summed, averaged, counted, or have a minimum or a maximum.
  • Dimensions are values that determine the level of detail at which measures are aggregated. You can think of them as slicing the measures or creating groups into which the measures fit. The combination of dimensions used in the view define the view's basic level of detail.

As an example (which you can view in the Chapter 01 Starter workbook on the Measures and Dimensions sheet), consider a view created using the Region fields and Sales from the Superstore connection:

The Sales field is used as a measure in this view. Specifically, it is being aggregated as a sum. When you use a field as a measure in the view, the type aggregation (for example, SUM, MIN, MAX, and AVG) will be shown on the active field. Note that in the preceding example, the active field on rows clearly indicates the sum aggregation of Sales: SUM(Sales).

The Region field is a dimension with one of four values for each record of data: Central, East, South, or West. When the field is used as a dimension in the view, it slices the measure. So, instead of an overall sum of sales, the preceding view shows the sum of sales for each region.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset