WoW Comparison

[eloisep62912899]

Hi,

I'm trying to recreate the below table in the workspace but can't find a way to compare the two weeks that doesn't involve having hundreds of columns in a freeform table comparing to the 'prior 7 days'.

Any and all suggestions welcome!

[Issao_Shoji · Accepted solution]

Hello Eloise,

You can create segments with data ranges (last week, thisweek) then you can use this to build calculateds metrics (this week ÷ last week). In the workspace you can use this in dimensions that not include dates. (It will always displays the currently week and the last week)

I recommend you to use report builder, it's more flexible to compare any time period (week 13 vs 12, then 12 to 11).