Thursday, 7 July 2016

A Quick way to display decades on a continuous axis without a calculation

During #Zensontour we did #Makeovermonday using the Global Temperature data from week 20. This has the median temperatures per month. Plotting it as a line chart gives something like this 


But what i wanted was to have the decades displayed on the axis. I could use a calculated field to create the decades

STR((INT((Year([Date]))/10))*10)+ "'s"

This then gives you a decade dimension that you can add which then gives you this


But what i really want is the label of decades on the axis, but with a continuous line. Well you can do that, without a calculation, by editing the axis labels.

So first, get rid of the decade, change the year to a green pill, a continuous year.


Now right click on the Year of Date axis and click on the tick marks tab


We then change it to be fixed, every 10 years, and then set the tick origin to be 1/1/1840


Click ok and you then get this


And whats really cool is that if we drill down, we still get the decades on the axis. 


Quick, easy and no calculations. 









Matt

Author & Editor

Tableau Zen Master, Social Ambassador, Wrangler of Data, Vizzer of Data

3 comments :

  1. Nice. I've always just created groups and a custom date hierarchy for decades.

    ReplyDelete


  2. Great explanation to given on this post .The given information very impressed for me really so nice content.

    Dot Net Training in Chennai ECR

    ReplyDelete

  3. Thank you for such a sweet tutorial - all this time later, I've found it and love the end result. I appreciate the time you spent sharing your skills.
    Deer Hunting Tips Camping Trips Guide DEER HUNTING TIPS travel touring tips

    ReplyDelete

 
biz.