In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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