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

Workspace: Easier custom date range creator

Avatar

Avatar
Give Back 25
Level 4
frankd55973318
Level 4

Likes

54 likes

Total Posts

57 posts

Correct reply

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

Avatar
Give Back 25
Level 4
frankd55973318
Level 4

Likes

54 likes

Total Posts

57 posts

Correct reply

1 solution
Top badges earned
Give Back 25
Ignite 10
Give Back 10
Ignite 5
Ignite 3
View profile
frankd55973318
Level 4

29-01-2019

I had a request from a colleague to create a Workspace project that would allow them to compare two date ranges for specific metrics. The two date ranges weren't set in stone, they could be any two set of dates, so I couldn't pre-set the date ranges. I created a report that looks like this:

1678838_pastedImage_0.png

It would be nice if I could right click on each of the date ranges and change them. This would make it quicker to alter the date ranges I want to compare.

8 Comments

Avatar

Avatar
Coach
Community Advisor
Andrey_Osadchuk
Community Advisor

Likes

550 likes

Total Posts

990 posts

Correct reply

269 solutions
Top badges earned
Coach
Originator
Shape 25
Bedrock
Boost 500
View profile

Avatar
Coach
Community Advisor
Andrey_Osadchuk
Community Advisor

Likes

550 likes

Total Posts

990 posts

Correct reply

269 solutions
Top badges earned
Coach
Originator
Shape 25
Bedrock
Boost 500
View profile
Andrey_Osadchuk
Community Advisor

30-01-2019

frankd55973318,

Just a tip on how you can quickly compare metrics Day over Day, Week over Week, Month over Month, etc.

Advise your colleagues to use Day/Week/Month dimensions as shown in the screenshot:

quick-date-comparison.png

Let me know if it works as a workaround in the meantime?

Avatar

Avatar
Give Back 25
Level 4
frankd55973318
Level 4

Likes

54 likes

Total Posts

57 posts

Correct reply

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

Avatar
Give Back 25
Level 4
frankd55973318
Level 4

Likes

54 likes

Total Posts

57 posts

Correct reply

1 solution
Top badges earned
Give Back 25
Ignite 10
Give Back 10
Ignite 5
Ignite 3
View profile
frankd55973318
Level 4

30-01-2019

Thanks Andrey.

That is very useful if I am comparing specific weeks but if I want a more custom date range, like 10 days, I would still need to do it another way

Avatar

Avatar
Coach
Community Advisor
Andrey_Osadchuk
Community Advisor

Likes

550 likes

Total Posts

990 posts

Correct reply

269 solutions
Top badges earned
Coach
Originator
Shape 25
Bedrock
Boost 500
View profile

Avatar
Coach
Community Advisor
Andrey_Osadchuk
Community Advisor

Likes

550 likes

Total Posts

990 posts

Correct reply

269 solutions
Top badges earned
Coach
Originator
Shape 25
Bedrock
Boost 500
View profile
Andrey_Osadchuk
Community Advisor

30-01-2019

That's right. You may want to make a survey to find out what the most frequently comparison periods are. This may give you an idea about what custom date ranges to set up to cover 80-95% of use cases. Hope, it will be a great step forward.

Avatar

Avatar
Employee
Brandon_George_
Employee

Likes

0 likes

Total Posts

179 posts

Correct reply

0 solutions
View profile

Avatar
Employee
Brandon_George_
Employee

Likes

0 likes

Total Posts

179 posts

Correct reply

0 solutions
View profile
Brandon_George_
Employee

14-02-2019

You should be able to hover over the custom date range, click on the , and then edit from there.  Perhaps you are asking for something different, though.

Avatar

Avatar
Give Back 25
Level 4
frankd55973318
Level 4

Likes

54 likes

Total Posts

57 posts

Correct reply

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

Avatar
Give Back 25
Level 4
frankd55973318
Level 4

Likes

54 likes

Total Posts

57 posts

Correct reply

1 solution
Top badges earned
Give Back 25
Ignite 10
Give Back 10
Ignite 5
Ignite 3
View profile
frankd55973318
Level 4

15-02-2019

Hi Brandon,

The issue with this is it requires me to create a custom date range in the first place (the edit option isn't available for the preset date ranges like 'last month' and 'last 7 days') and I am not a fan of creating custom date ranges because it clogs up the 'Time' list.

If there was a way to create custom date ranges that then wouldn't be saved in the list, that would be helpful.

Thanks,

Frank

Avatar

Avatar
Coach
Community Advisor
Andrey_Osadchuk
Community Advisor

Likes

550 likes

Total Posts

990 posts

Correct reply

269 solutions
Top badges earned
Coach
Originator
Shape 25
Bedrock
Boost 500
View profile

Avatar
Coach
Community Advisor
Andrey_Osadchuk
Community Advisor

Likes

550 likes

Total Posts

990 posts

Correct reply

269 solutions
Top badges earned
Coach
Originator
Shape 25
Bedrock
Boost 500
View profile
Andrey_Osadchuk
Community Advisor

15-02-2019

Hi Frank,

Right click on the column with the desired metric, select Add time period column > Custom date range...

This will add another column with the specified data range and metric you began with.

Avatar

Avatar
Give Back 25
Level 4
frankd55973318
Level 4

Likes

54 likes

Total Posts

57 posts

Correct reply

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

Avatar
Give Back 25
Level 4
frankd55973318
Level 4

Likes

54 likes

Total Posts

57 posts

Correct reply

1 solution
Top badges earned
Give Back 25
Ignite 10
Give Back 10
Ignite 5
Ignite 3
View profile
frankd55973318
Level 4

15-02-2019

Thanks Andrey, that is helpful and is what I'm looking for.

I still think the it would be nice that when you did this, you didn't have to go to a separate page to create your data range. It would be good if a calendar pop up appeared and you could create the data range right there.

Thanks.

Avatar

Avatar
Give Back 1000
Community Manager
jantzen_belliston-Adobe
Community Manager

Likes

350 likes

Total Posts

2,366 posts

Correct reply

822 solutions
Top badges earned
Give Back 1000
Give back 900
Give Back 800
Give Back 700
Give back 600
View profile

Avatar
Give Back 1000
Community Manager
jantzen_belliston-Adobe
Community Manager

Likes

350 likes

Total Posts

2,366 posts

Correct reply

822 solutions
Top badges earned
Give Back 1000
Give back 900
Give Back 800
Give Back 700
Give back 600
View profile
jantzen_belliston-Adobe
Community Manager

27-10-2020

 
Status changed to: Archived