Expand my Community achievements bar.

SOLVED

WoW Comparison

Avatar

Level 1

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'.

1474040_pastedImage_2.png

Any and all suggestions welcome!

1 Accepted Solution

Avatar

Correct answer by
Level 2

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).

View solution in original post

1 Reply

Avatar

Correct answer by
Level 2

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).