2 Replies Latest reply on Aug 12, 2016 11:20 AM by Bob O'Connell

# Trying To Label X & Y Axis Using Alias Values (or any other approach)

### Desired Outcome

Our team has one particular chart required by the business that has been causing us problems. We hope that somebody else has run across this.

This ( Fig 1) is the example of the existing chart we need to replicate in Tableau

Looking at the X and Y axis one can see that they are not linear. For example, the Y axis shows percent but
even though the spacing between ticks are equal the labeled valued are not proportional to the spacing. The
underlying data for both X & Y axes is logarithmic but it is made to look linear for the sake of the chart.

Data

In its basic form it comes to us in a table  as numeric X, Y pairs with associated "mappings" to the associated label that should be shown on the X or y grid

Initially we thought that aliases could help us.  Here are the actual numeric values and our aliases (or values to be seen on the axis)

For X values (fig 2):

For Y Values (fig 3):

Sample Output

If one plots a the numeric (measure) data as a scatterplot one sees a nice 10 value  X 10 value

(on axis)  chart that looks very similar to the original chart we are trying to replicate. The overall

appearance and layout of the marks would be acceptable to the business

Fig 4

But  here we  need the axis values / labels themselves to show the aliased values we showed in Fig 2 & 3 above.

What We Have Tried

Initially we  thought we could use the alias approach we have alluded to above.  But it appears through trying it and

looking for examples that the alias functionality is not applicable to measures. We have tried other approaches such as

• making one or both variables dimensions and then use aliases
• using the right Y axis for measures and the left axis for aliased values but one needed both y axis to be numeric ( I think that is true)

So far the closest approaches gets us to a chart like below (fig 5)

Summary

• We have X,Y pairs that map to numeric values in a scatter plot.
• These X,Y pairs need alternative labels on the axis
• Using aliases with pure measures does not function in Tableau
• Alternative approaches using dimensions with alias values does not produce the desired output chart .
• Basically we need a chart that whose point locations are numeric but axis labels are some form of dimension value (at least on the X axis)

Request

We tried to have done our own due diligence and research but we are blocked. We may be just missing something obvious. Others we know who use Tableau in our company and at other companies have not come up with an approach. So we ask:

• Has anyone run into this problem and found a solution?
• Can anyone suggest a solution or approach?
• If I have not explained this clearly , let us know.

Thanks, Bob, Srilatha

• ###### 1. Re: Trying To Label X & Y Axis Using Alias Values (or any other approach)

Hi Bob,

Attached is the image of a solution. If I understand your request correctly, this might help you.

Create two Calculated Fields called X-Aliases and Y-Aliases and use the formula shown in the image to assign the value you want to see in the scatter plot.

Then drag these new fields on your chart to see the desired output.

Thanks,

Suraj.

• ###### 2. Re: Trying To Label X & Y Axis Using Alias Values (or any other approach)

Suraj,   Thanks for the response!  Something like this is exactly what we want to do ( and elegantly simple also).  I'll try it over the weekend and let you know how far it gets us...