Cohort Formula: Conditional Statements Quick question

Hello,

I am working on a cohort analysis. I would like to group things by our fiscal quarters. I extracted the month and year from the date column. I am trying to create a new column that has the fiscal year quarters listed. But when I run this formula it only assigns the quarter to the first month in each quarter if statement. What am I doing wrong?

Screen Shot 2020-10-27 at 3.08.48 PM.png

Parse

Preparation

Accepted answers

jmorris24

Nevermind. I figured it out. I had to write out the [Start Date Year Month] = for every or statement as shown here.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Writing-an-If-statement-with-multiple-OR/td-p/20834

All comments

jmorris24

Nevermind. I figured it out. I had to write out the [Start Date Year Month] = for every or statement as shown here.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Writing-an-If-statement-with-multiple-OR/td-p/20834

Emil_Kos

Hi @jmorris24,

Glad you have solved it.

Just one question. Wouldn't be easier for you to have a text input file with a proper mapping which could be populated with the find-replace tool?

Thanks to that you wouldn't need to write so complicated formulas in the future:

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703