Advance with Assist: What You Need to Know About Aliases

Data

Advance with Assist: What You Need to Know About Aliases

Advance with Assist shares quick solutions to common challenges encountered by the InterWorks Assist on-demand team.

Question: I know I’m doing something wrong. When building views, my alias in one view overwrites my alias in another. I know I’m missing something here. Can you fill in what I’m missing?

When building reports, sometimes you need a different header name. Right-clicking the header will sometimes reveal a menu option for Edit Alias:

edit aliases in Tableau

This allows you to create an alias on the report tied to the data source. In this case, we are tying the alias to the measure Discount. We’ll call it Region Discount since I’m building a report for regions:

edit aliases in Tableau
editing aliases in Tableau

Now back to the question at hand. To show what she was seeing, I created another report where I needed the alias to be State Discount. However, when I try to edit the alias here, I see Region Discount in the Edit menu, and not just Discount. This is because you are only allowed to edit the alias once, as it’s tied to the measure here and not the report.

editing aliases in Tableau

If you needed different aliases for different reports, you have a couple options.

Option 1: Duplicating the Measure

Since you are creating another measure, you will have the ability to create a second alias:

editing aliases in Tableau edit aliases in Tableau

Option 2: Spaces in Aliases

Sometimes you need the same alias on multiple measures. Tableau will not allow you to have the same alias on multiple:

editing aliases in Tableau

The way around this message is to add a <space> at the end of the alias. As you can see below, the aliases are the same, but the data is different. The only difference is the space.

creating multiple aliases in Tableau

Want More Advance with Assist

  1. Advance with Assist: Filtering Select Dates with DATETRUNC
  2. Advance with Assist: Enhancing Dashboards with Custom Icons
  3. Advance with Assist: Tableau Power User Leaving the Company
  4. Advance with Assist: Context Filters and LOD Calculations
  5. Advance with Assist: Custom Subscriptions with Tableau Server Custom Views
  6. Advance with Assist: Blending with Dimension Not Utilized
  7. Advance with Assist: Creating a Sankey Diagram from Survey Data
  8. Advance with Assist: Multiple Dashboard Actions with a Single Click
  9. Advance with Assist: Refreshing Tableau Online Data with Tableau Bridge
  10. Advance with Assist: Parameter Performance Optimization
  11. Advance with Assist: Using Custom Backgrounds with Polygon Shapefiles
  12. Advance with Assist: Changing Default Properties on Data
  13. Advance with Assist: Options for Calculating Percentages
  14. Advance with Assist: Removing Options from Filter List
  15. Advance with Assist: Extracting Year from De-identified Text String
  16. Advance with Assist: Marking the Latest Date on Trend Line
  17. Advance with Assist: What You Need to Know About Aliases
  18. Advance with Assist: Function Compatibility
  19. Advance with Assist: Mass Parameter Replacement
  20. Advance with Assist: Sorting with MONTH in Reverse
  21. Advance with Assist: Ungroup Column Headers That Have Concatenated
  22. Advance with Assist: Connectionless Failure Error in Tableau Server
  23. Advance with Assist: How to Exceed Tableau’s Column or Row Limit
  24. Advance with Assist: Adding Email Links to Your Dashboard
  25. Advance with Assist: Saving User-Selected Filters on Tableau Server

More About the Author

Dustin Wyers

Analytics Consultant | Assist Lead - East
Advance with Assist: Saving User-Selected Filters on Tableau Server Question: Our users are finding themselves clicking the same filters when they log onto dashboards they have access to. They are ...
Advance with Assist: Adding Email Links to Your Dashboard Question: I’m building a public dashboard and want to get a “Contact Us” link on the screen. How do I make the email pop up? Adding the ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

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