Alteryx Designer Desktop Discussions

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

Selecting output across multiple months

SCK
8 - Asteroid

I have the mentioned data. I want to select data in such a way that all months are covered atleast once. Please suggest

 

Input:

 

MonthValue
1400
250
360
470
580
690
7100
8155
9140
10455
11600
12700
1140
2455
3600
4400
53324
650
7700
8890
9140
10700
11910
12985
650
7700
8890
9140
10700
11910
12985
2 REPLIES 2
DavidP
17 - Castor
17 - Castor

Hi @SCK 

 

You can group the data by month, then you can manipulate it whichever way you wish.

 

DavidP_0-1607509827634.png

 

Qiu
20 - Arcturus
20 - Arcturus

@SCK 
Some thing like this?

1209-SCK.PNG

Labels