Alteryx Designer Desktop Discussions

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

Trying to get a month over month analysis pivot table, but struggling.

WishIKnewHowToCode
8 - Asteroid

I'm trying to get an output like this below example out of alteryx.

WishIKnewHowToCode_0-1686258691262.png

WishIKnewHowToCode_1-1686258705354.png


It's such a simple pivot in Excel, but I'm struggling a lot to get this out of Alteryx. I have millions of rows of data, so just moving it into Excel and pivoting it manually is not going to work. Does anyone know how to help with this?


I've attached a sample sheet if that helps.

5 REPLIES 5
WishIKnewHowToCode
8 - Asteroid

Also I should say in the full dataset there are multiple years. So if months could be broken out by year that is what I am aiming for.

Something Like this

Payer 1
2023
Jan
Feb
etc

 

Payer 2
2022
Jan
Feb

etc

 

Payer 3

2021

Jan

Feb

etc

 

Or if anyone feels there's a better way to do that, I'm all ears. I'm just really frustrated Alteryx seems to struggle performing a simple task and lacks the functionality of a much older program.

Yoshiro_Fujimori
15 - Aurora

Hi @WishIKnewHowToCode ,

 

Here is one way of doing this. I hope this fits your needs.

Workflow

 

Yoshiro_Fujimori_0-1686266510717.png

Formula

Year = DateTimeFormat([Medicaid RA Date],"%Y")

Month = DateTimeFormat([Medicaid RA Date],"%m")

 

Pivot Table

Yoshiro_Fujimori_1-1686266595676.png

 

Output

Yoshiro_Fujimori_2-1686266625703.png

 

Qiu
21 - Polaris
21 - Polaris

@WishIKnewHowToCode 
I think you may have jumped to conclusion too fast?😂

Excel is good for sure, but Alteryx excels Excel in many ways/
For your pupose, we can do thing like this and note that this process is repeatable, meaning you have to only update the input file, then click the "Run".
No more copy and paste and update....

0609-WishIKnewHowToCode.PNG

Qiu
21 - Polaris
21 - Polaris

@Yoshiro_Fujimori 
Much better!

WishIKnewHowToCode
8 - Asteroid

This worked. I needed an output to go to excel, so I modified the flow a bit, but I never thought to just split my dates into month/year to make the summarize tool work better.

Labels