This content has been marked as final.
Show 3 replies
-
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?
Galen Busch Sep 25, 2017 12:16 PM (in response to Purna Bishwakarma)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?
Zach Leber Sep 25, 2017 12:22 PM (in response to Purna Bishwakarma) -
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?
Purna Bishwakarma Sep 25, 2017 12:29 PM (in response to Galen Busch)Thank you, Galen. I really appreciate your help.