Tableau Tip Tuesday: How to Create a 45 Degree Reference Line

Nice! That's a pretty smart and simple to draw a 45-degree trendline :)

By the way, I think you're double counting the number of countries in the Literacy Rate viz, due to the data points situated on the trend line. It should be 22 countries where female literacy is higher than male literacy.

Very cool to see in the video how you applied the technique to three different datasets. That's crazy-helpful and useful to see it applied in different ways. :-)

Thanks for the example. It gave me some useful ideas for some comparisons I've been trying to figure out how best to visualize. Although not the primary purpose of this example, using an aggregate function for the calculated field to determine direction of change should fix the issue for the CPI and Sales datasets. For example: sum([First Year CPI])<sum([Second Year CPI]). You could also put this into an IF statement to set values of "Increased", "Decreased", or "No Change". Alternatively you could calculate the difference between the two values and use it as a continuous measure with a diverging color scheme so the color represents direction of change and the shade/density represents how much of a change occurred between the two years.

That is very cool! Very elegant to use a trend line for this.

Great post, Andy - a very clever solution. I've posted an extension to this that allows matched axis ranges on X and Y that are dynamic. See here: https://blog.databender.net/2016/03/21/45-degree-reference-line-with-dynamic-axes/

Thanks Andy for figuring out these cool stuffs for us.

thank you...thank you!!!