Advanced addressing and partitioning

Let's take a look at a few other examples of what happens when you add additional dimensions. For example, if you check Quarter of Order Date, you'll see Tableau highlight a partition defined by Region and Year of Order Datewith Index incrementing by the addressing fields of Quarter of Order Date and then Department:

If you were to select Department and Year of Order Date as the addressing of Index, you'd see a single partition defined by Region and Quarter, like this:

You'll notice, in this view, that Index increments for every combination of Year and Department within the partition of Quarter and Region.

These are a few of the other things to consider when working with addressing and partitioning:

  • You can specify the sort order. For example, if you wanted Index to increment according to the value of the sum of sales, you could use the drop-down list at the bottom of the Table Calculation editor to define a custom sort.
  • The At the Level option in the edit Table Calculation dialog box allows you to specify a level at which the Table Calculations are performed. Most of the time, you'll leave this set at Deepest (which is the same as setting it to the bottom-most dimension), but occasionally, you might want to set it at a different level if you need to keep certain dimensions from defining the partition but need the Table Calculation to be applied at a higher level. You can also reorder the dimensions by dragging and dropping within the checkbox list of Specific Dimensions.
  • The Restarting Every... option effectively makes the field selected, and all dimensions in the addressing above that field selected, part of the partition, but allows you to maintain the fine-tuning of the ordering.
  • Dimensions are the only kinds of fields that can be used in addressing; however, a discrete (blue) measure can be used to partition Table Calculations. To enable this, use the drop-down menu on the field and uncheck Ignore in Table Calculations.

Take some time to experiment with various options and become comfortable with how addressing and partitioning works.

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

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