Alteryx Designer Desktop Discussions

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

QoQ and YoY computation

satya04
8 - Asteroid

I would need to calculate YoY and QoQ change for data which is in the following format. Can you please guide me on how this can be done?

3 REPLIES 3
gautiergodard
13 - Pulsar

Hey @satya04 

You can do something like the attached if you want to keep the data structure unchanged.

I've done the calc using CapEx as an example.

satya04
8 - Asteroid

Hello @gautiergodard records till CQ122013 may not have YoY due to unavailability of prior period. Can you please help me understand the logic for obtaining the calculation here?

satya04
8 - Asteroid

@gautiergodard The result coming in the first row of YoY CapEx should come on the 5th row (Row+4). Can you please guide me on how it can be done?

Labels
Top Solution Authors