1 2 Previous Next 21 Replies Latest reply on Jul 8, 2015 1:46 PM by Jay Chang

# 13 month axis

Hi,

I am looking for a 13 month axis which can show only Starting Month and Ending month and this should move dynamically with every month coming in.

Please throw some light on this.

TIA

Warm Regards,

Srinivas

• ###### 1. Re: 13 month axis

hi Srini,

Create [last n parameter]

data type integer and allowable values all.

create calculation

Last()<[last n parameter]

drag this into filter and true.

Show parameter control and type 13.

Drag the month in row or coumn.

now we can get only last 13 months.if new month added then it will end with new month

thanks

sankar

1 of 1 people found this helpful
• ###### 2. Re: 13 month axis

See attached

• ###### 3. Re: 13 month axis

Am not able to open the attachments as am using Version 9

Thanks for the quick help.

Warm Regards,

Srinivas

• ###### 4. Re: 13 month axis

Hey Srinivas,

Here is an 8.2 Version.

I used a similar method to Sankar, but without the Parameter.

LAST() < 13

Here is the attached workbook.

Regards,

Rody

• ###### 5. Re: 13 month axis

Also, if you want to exclude the current month and only show the previous 13 months, just modify the calc slightly

LAST() < 14 AND LAST() != 0

Regards,

Rody

• ###### 6. Re: 13 month axis

Thank you sankar

• ###### 7. Re: 13 month axis

Thank you Rody

• ###### 8. Re: 13 month axis

Hi Srini

It helps then happy, Please mark it as help or correct and end this discussion.

Thanks

sankar

• ###### 9. Re: 13 month axis

@Hi Sankar and Rody, Thank you both for the calculation at first.

How can I show the axis only May 14 and May 15 as my requirement from Excel (Which shows start month and end month 13 months on the axis).

But the tick marks in tableau has only tick origins and how can i give start month and end month for period of months like 13, 15 etc.. ?

Axis needed with start month and end month (attached Axis JPG) and Tick Origins FYI

TIA

Warm Regards,

Srinivas

• ###### 10. Re: 13 month axis

sure thing, i will. so far it just get started.

• ###### 11. Re: 13 month axis

You could try this...

I don't know if this will work for your exact requirement, but I hope it is a start.

Regards,

Rody

1 of 1 people found this helpful
• ###### 12. Re: 13 month axis

You set the Tick Origin to 12 months before your start date, the set it to every 13 months.

Regards,

Rody

• ###### 13. Re: 13 month axis

Scratch that, you don't have to set it 12 months back, but you do need to make suse the tick origin is the set to the first month

Rody

• ###### 14. Re: 13 month axis

Yes, I have set it to the start of the month as per the requirement. Good find. Thank you so much Rody.

1 2 Previous Next