YoY and WoW calculation

[SDCI]

Can anybody recommend or have an efficient way to calculate Year over Year and Week over Week percent change?

thanks

[pcatterson]

This will depend greatly on what your data looks like.

Could you show some data as a example?

[SDCI]

I'm attaching an example file which contains calculations showing YoY and WoW calculations.  The YoY is based on date divided by 364 days prior and WoW is based on date divided 7 days prior.

[jdunkerley79]

Looking at you example, I would add a record id (using the RecordID tool) and then use a formula tool to create the id for 1 year and 1 week earlier

You can then self join twice to get the value at those points.

sample attached

[SDCI · Accepted solution]

Awesome...that works!  Thanks!