Example – Editing Aliases

The Sample - Superstore data source contains a measure called Discount, which contains discount values from 0 to 0.25 or 25%. Suppose you want to analyze these data by categories: low discount, medium discount, and high discount.
To create the categories, you could first bin the measure so that when added to the view it create discrete headers instead of a continuous axis. In this example, define a bin size equal to 0.10, which produces three bins. The first bin contains the values 0 to 9%, the second bin contains the values 10% to 19%, and the third bin contains the values 20% and greater. The Create Bins dialog box for this field is shown below.

The new binned field is named Discount (bin) and appears in the Dimensions area of the Data window.

When you place Discount (bin) on the Rows or Columns shelf, the default aliases for the bins are given by the lower limit of the bin’s numerical range

To improve the readability of the bins when they are displayed in Tableau, you can define aliases such as “Low discount”, “Medium discount”, and “High discount.”
  1. Right-click the name of the dimension in the Data window and select Default Properties > Aliases.

  2. Assigning an alias to every member of the Discount (bin) fields. For example, the member originally labeled as 0.0% is now labeled as “Low Discount.”

You can change aliases at any time using the Edit Aliases dialog box. To do so, click on the alias you want to change and specify the new name. Use the Tab key to advance from one value to the next. To restore the original aliases, click the Clear Aliases button in the bottom right corner of the dialog box. You can also sort the members or their aliases by clicking the appropriate column header. After completing the Edit Aliases dialog box, Tableau automatically displays the aliases in the view.

No comments:

Post a Comment