1 of 1 people found this helpful
Deepak Rai and I just worked with this issue on another thread - it is a bigger problem than it first appears and I would suggest that you look at the thread listed below
Deepak finally broke it so he would be your first go to with questions
Thanks for your response, Jim. I ended up going a slightly different way. I created a data scaffold in Alteryx with the fields month_year, month_start, and month_end. I then appended the fields offer_exp_dt and offer_apr_dt. Using the formula below in Alteryx I added the field active_offer_in...
IF [offer_apr_dt]<=[month_end] AND [offer_exp_dt]>=[month_start] THEN 1 ELSE 0 ENDIF
The end result looks like this...
month_year month_start month_end OFFER_APR_DT OFFER_EXP_DT active_offer_in 3/1/2016 3/1/2016 3/31/2016 3/18/2016 5/17/2016 1
with many more rows, but ultimately allowed me to pick a month and sum active_offer_in to get the number of offers within that month.
Glad you found something that would work