Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

WoW Comparison

eloisep62912899
Level 1
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
Issao_Shoji
Correct answer by
Level 2
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
Issao_Shoji
Correct answer by
Level 2
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