Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

COUNTIF with Dates Ranges

gposton
5 - Atom

Hello all,

 

I have a list of products and dates of when they were purchased (similar to below). I would like to create a report that lists all 12 months as rows, products as columns, and do a count of the number of orders in each month. I've created the list of months using the Generate Rows tool, but I'm having trouble figuring out a way to do a "Countif" style formula to accomplish the ideal output. Thanks.

 

Current Dataset:

Product Order Date
A1/15/2017
B4/1/2017
A1/17/2017
F12/3/2017
C6/8/2017
C6/10/2017
C8/30/2017

 

Ideal Output:

MonthABCDEF
1/1/2017100000
2/1/2017000000
3/1/2017000000
4/1/2017010000
5/1/2017000000
6/1/2017002000
7/1/2017100000
8/1/2017001000
9/1/2017000000
10/1/2017000000
11/1/2017000000
12/1/2017000001
2 REPLIES 2
alex
11 - Bolide

Here you go.

order1.JPG

I changed the 3rd row in your current data set to read 7/17/2017 so that it matches the output in your example.

 

order2.JPG

 

Take a look at the attached workbook. Hope this solves your issue.

order3.JPG

gposton
5 - Atom

Thank you alex!!!!

Labels