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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Analysis Workspace: Compare dates

Avatar

Avatar
Give Back 10
Level 6
psvlin
Level 6

Likes

152 likes

Total Posts

66 posts

Correct reply

1 solution
Top badges earned
Give Back 10
Ignite 10
Give Back 5
Ignite 5
Ignite 3
View profile

Avatar
Give Back 10
Level 6
psvlin
Level 6

Likes

152 likes

Total Posts

66 posts

Correct reply

1 solution
Top badges earned
Give Back 10
Ignite 10
Give Back 5
Ignite 5
Ignite 3
View profile
psvlin
Level 6

03-12-2015

It would be great if we could compare dates (WoW, YoY, etc.) in Analysis Workspace. Almost every person at my company who uses Analysis Workspace have asked for it.

33 Comments

Avatar

Avatar
Boost 50
Employee
benjamingaines2
Employee

Likes

271 likes

Total Posts

874 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile

Avatar
Boost 50
Employee
benjamingaines2
Employee

Likes

271 likes

Total Posts

874 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile
benjamingaines2
Employee

03-12-2015

We very much appreciate the feedback, @viclin. (Also great to hear that so many people at your company are using Analysis Workspace.) This is something we definitely want to do; ease of comparison should be one of the core benefits of Analysis Workspace. I don't have an ETA, but our engineers are actively working on definining how this should work and getting it done.

 

Please continue to add comments and votes here! 

Avatar

Avatar
Boost 5
Level 3
michelleg997808
Level 3

Likes

41 likes

Total Posts

15 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 3
michelleg997808
Level 3

Likes

41 likes

Total Posts

15 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
michelleg997808
Level 3

14-12-2015

So glad to see your update on this, Ben! I'm looking for this feature too. I would be able to replace a lot of manual reporting with Analysis Workspace if I could do YoY, MoM, WoW. Keep us updated! Thanks.

Avatar

Avatar
Give Back
Level 2
fvisani
Level 2

Likes

2 likes

Total Posts

16 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
Validate 1
Boost 1
Applaud 5
View profile

Avatar
Give Back
Level 2
fvisani
Level 2

Likes

2 likes

Total Posts

16 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
Validate 1
Boost 1
Applaud 5
View profile
fvisani
Level 2

26-01-2016

Agree with @viclin, would be awesome to have this feature and be able to compare YoY, MoM, etc, side by side in a table/chart, like what we can do in Key Metrics reports like Visits and see Current Month, 4 Weeks Prior and 52 Weeks Prior, but with more flexibility.

Avatar

Avatar
Boost 50
Employee
benjamingaines2
Employee

Likes

271 likes

Total Posts

874 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile

Avatar
Boost 50
Employee
benjamingaines2
Employee

Likes

271 likes

Total Posts

874 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile
benjamingaines2
Employee

27-01-2016

@FeFinotto: Thanks for commenting! This continues to be one of our top priorities for Analysis Workspace. 

Avatar

Avatar
Boost 5
Level 2
jakewinterbb
Level 2

Likes

17 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile

Avatar
Boost 5
Level 2
jakewinterbb
Level 2

Likes

17 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile
jakewinterbb
Level 2

18-02-2016

Just another vote for this, as it's been the primary blocker in migrating business users/reports into Analysis Workspace.

 

My preferred approach for this is to allow for rolling date ranges to be applied in Segments, so that a "Last Year" or "Last Week" segment could be created and either directly applied to a column in Analysis Workspace, or applied to a "Last Week Average-Visits" calculated metric. That flexibility would be ideal.

Avatar

Avatar
Give Back 5
Level 3
eric_matisoff
Level 3

Likes

39 likes

Total Posts

26 posts

Correct reply

1 solution
Top badges earned
Give Back 5
Give Back 3
Give Back
Boost 5
Boost 3
View profile

Avatar
Give Back 5
Level 3
eric_matisoff
Level 3

Likes

39 likes

Total Posts

26 posts

Correct reply

1 solution
Top badges earned
Give Back 5
Give Back 3
Give Back
Boost 5
Boost 3
View profile
eric_matisoff
Level 3

21-02-2016

The closest thing that AW has to this feature right now is by:

1 - set your dates to expand from the beginning of the first date comparison to the end of the second date. (for example, if you're comparing December to January, set your date to December 1-January 31.

2 - Pull in the metric you want to compare. In our example, use Month as your dimension rather than using the default: Day

3 - Use the built-in Time dimensions to "segment" each metric. (For example, pull the "Month" Time dimension above or below the metric in your report). 

 

Ouilah! You know have date comparison! Obviously it's not as flexible as a true date comparison via the Calendar module, but it's a step in the right direction. Note that you can use the other built-in Time dimensions like Day, Year, etc and you can also create your own! Just open the Segment Manager, drag in one of the Time dimensions, and adjust to your needs.

 

Looking forward to all the product updates!

Avatar

Avatar
Give Back 5
Level 3
eric_matisoff
Level 3

Likes

39 likes

Total Posts

26 posts

Correct reply

1 solution
Top badges earned
Give Back 5
Give Back 3
Give Back
Boost 5
Boost 3
View profile

Avatar
Give Back 5
Level 3
eric_matisoff
Level 3

Likes

39 likes

Total Posts

26 posts

Correct reply

1 solution
Top badges earned
Give Back 5
Give Back 3
Give Back
Boost 5
Boost 3
View profile
eric_matisoff
Level 3

21-02-2016

Again - not ideal, but a step in the right direction

Avatar

Avatar
Boost 50
Employee
benjamingaines2
Employee

Likes

271 likes

Total Posts

874 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile

Avatar
Boost 50
Employee
benjamingaines2
Employee

Likes

271 likes

Total Posts

874 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile
benjamingaines2
Employee

25-02-2016

@jake_winter: Good to know that this is preventing widespread adoption. It's one of our top priorities on our product backlog. Stay tuned.

Avatar

Avatar
Boost 50
Level 4
monicas9
Level 4

Likes

50 likes

Total Posts

14 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Boost 50
Level 4
monicas9
Level 4

Likes

50 likes

Total Posts

14 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile
monicas9
Level 4

14-04-2016

Another vote for the YOY, MOM, WOW date ranges. 

Also want to add, that these should be in a way that I should be able to plot them on a line graph as seperate lines, so to see the trends of this year v/s last year at a day granularity. 

 

- the custom date feature that is currently in place, does not sort by time range. So if I add '2 weeks ago, 3 weeks ago, Today, Yesterday', mycustomdaterange'  in the rows, and Visits in the column, it will sort alphanumerically. I want to be able to say Today, Yesterday, mycustomdaterange, 2 weeks ago, 3 weeks ago, etc. 

Avatar

Avatar
Boost 50
Employee
benjamingaines2
Employee

Likes

271 likes

Total Posts

874 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile

Avatar
Boost 50
Employee
benjamingaines2
Employee

Likes

271 likes

Total Posts

874 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile
benjamingaines2
Employee

14-04-2016

@MonicaS: Thanks for commenting and voting! We're committed to getting this done.