3 Replies Latest reply on Mar 23, 2017 7:25 AM by Michael Someck

Highlighting trailing 3 months based on month selected

Padhumai Rathinavel Mar 16, 2017 12:58 PM

Hi,

I've been working on this issue for quiet some time now.I basically want the trailing 3 months from the month selected to be highlighted in a different color in the bar chart. For example - if I select Dec-16 then the months OCt-16,Nov-16 & Dec-16 should be highlighted in a different color compared to the other bars in the chart which remain the same.

Also Ive not been able to find a formula that would capture trailing 3 months based on month selected.

IT would be great if someone gave me any pointers on this.

Thanks,

Padhumai

Trialing 3 Months.twbx 26.8 KB

1. Re: Highlighting trailing 3 months based on month selected

Michael Someck Mar 16, 2017 1:06 PM (in response to Padhumai Rathinavel)
Hi Padhumai,

The following calculated field should do the trick. I've attached a workbook as well, but it is unfortunately 10.2. Hopefully the screenshot provides enough information.

Michael

Trialing 3 Months.twbx 39.3 KB
Like Show 0 Likes(0)

Actions
2. Re: Highlighting trailing 3 months based on month selected

Padhumai Rathinavel Mar 23, 2017 7:10 AM (in response to Padhumai Rathinavel)

Hi Michael,

Thank you so much for your help , I got the bars highlighted and working using your workbook.

Thanks,
Padhumai
Like Show 0 Likes(0)

Actions
3. Re: Highlighting trailing 3 months based on month selected

Michael Someck Mar 23, 2017 7:25 AM (in response to Padhumai Rathinavel)

Glad to help! If you wouldn't mind, could you please mark the answer as correct so this doesn't show up as unanswered anymore? Thanks
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community

Highlighting trailing 3 months based on month selected

1. Re: Highlighting trailing 3 months based on month selected

2. Re: Highlighting trailing 3 months based on month selected

3. Re: Highlighting trailing 3 months based on month selected

Actions

More Like This