-
1. Re: Hi all, I am working on Tableau 10.2. I need to have 2nd, 3rd, and 4th quarters from 2016 and 1st and 2nd quarters from 2017. When I try to exculde Q1 from 2016, it is excluding Q1 from 2017 as well. How to exclude Q1 from 2016 and Q3 from 2017?
Hi Purna,
Create a string field:
str(datename('quarter',[Date Bank Received])) + str(datename('year',[Date Bank Received]))
Bring this field to filters, and exclude '12016'
Galen -
2. Re: Hi all, I am working on Tableau 10.2. I need to have 2nd, 3rd, and 4th quarters from 2016 and 1st and 2nd quarters from 2017. When I try to exculde Q1 from 2016, it is excluding Q1 from 2017 as well. How to exclude Q1 from 2016 and Q3 from 2017?
Or switch the date dimension in your view from Date Parts to Date Values (Discrete) as depicted.
-
3. Re: Hi all, I am working on Tableau 10.2. I need to have 2nd, 3rd, and 4th quarters from 2016 and 1st and 2nd quarters from 2017. When I try to exculde Q1 from 2016, it is excluding Q1 from 2017 as well. How to exclude Q1 from 2016 and Q3 from 2017?
Thank you, Galen. I really appreciate your help.
