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

Dynamic 'Last Year' time option

Avatar

Avatar
Boost 3
Level 1
FrankieBlue-uEP
Level 1

Likes

4 likes

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Boost 3
Boost 1
View profile

Avatar
Boost 3
Level 1
FrankieBlue-uEP
Level 1

Likes

4 likes

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Boost 3
Boost 1
View profile
FrankieBlue-uEP
Level 1

27-02-2019

We have fairly static time filters such as Last 3 full months, Last 13 full weeks, Last Week, etc. And I also understand I can go into Date Range Builder and build my own timeframe.

However in building reports and having more agility in analytics, a dynamic Last Year (LY) option would be great.  For example, if I want to look at Black Friday TY over LY, it would be easier to just drag in an “LY” filter to compare instead of creating a date filter which is then saved and static.

A more use case scenario would be looking at a promo from Oct 25 – Oct 28, if I want to compare TY/LY for this random date it would be easier, as well as usually in a meeting someone would ask “ok what about just Oct 26 – Oct 28”, I need to more agile than building a new date filter.

Another scenario is building reports and dashboards, having an LY column (which is the number one question we’re asked) to change as each individual changes the date range they want to see would be huge.

8 Comments

Avatar

Avatar
Coach
Community Advisor
Urs_Boller
Community Advisor

Likes

530 likes

Total Posts

1,024 posts

Correct reply

257 solutions
Top badges earned
Coach
Bedrock
Contributor 2
Originator
View profile

Avatar
Coach
Community Advisor
Urs_Boller
Community Advisor

Likes

530 likes

Total Posts

1,024 posts

Correct reply

257 solutions
Top badges earned
Coach
Bedrock
Contributor 2
Originator
View profile
Urs_Boller
Community Advisor

28-02-2019

you can use the "dynamic date ranges" and define whatever dynamic date ranges you need: Calendar and Date Ranges

here are some examples of date ranges we offer our users:

- last month 1 year ago

- last week 1 year ago

there are more date ranges just created for our analyst, which all can be used to compare to some common date ranges.

remark: dynamic date ranges are always based to the day/date you use them. that means whatever date range is set for the report, the "date range" judt overwrites by calculating for current day...

I don't know if this already solves your idea, let me know if there is a date range you can't create dynamic or if you are looking for something else.

Avatar

Avatar
Boost 3
Level 1
FrankieBlue-uEP
Level 1

Likes

4 likes

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Boost 3
Boost 1
View profile

Avatar
Boost 3
Level 1
FrankieBlue-uEP
Level 1

Likes

4 likes

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Boost 3
Boost 1
View profile
FrankieBlue-uEP
Level 1

28-02-2019

Yes, and I used dynamic date ranges to create my “Today LY” date range as seen below which takes whatever date I specify and subtracts 364 days:

But if I’m currently selecting 3 days, or 4, or 2 weeks, etc, this won’t change to show the equivalent last year numbers. I can’t just change the ‘End’ component to be ‘minus 363’, ‘minus 362’, etc because we don’t know what end date the user will be choosing

If the ‘End:’ component could read

“End: End of last day/ending day minus 364 days”

I believe that would solve it.

Avatar

Avatar
Coach
Community Advisor
Urs_Boller
Community Advisor

Likes

530 likes

Total Posts

1,024 posts

Correct reply

257 solutions
Top badges earned
Coach
Bedrock
Contributor 2
Originator
View profile

Avatar
Coach
Community Advisor
Urs_Boller
Community Advisor

Likes

530 likes

Total Posts

1,024 posts

Correct reply

257 solutions
Top badges earned
Coach
Bedrock
Contributor 2
Originator
View profile
Urs_Boller
Community Advisor

28-02-2019

maybe similar to this? Dynamic date ranges

Avatar

Avatar
Boost 3
Level 1
FrankieBlue-uEP
Level 1

Likes

4 likes

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Boost 3
Boost 1
View profile

Avatar
Boost 3
Level 1
FrankieBlue-uEP
Level 1

Likes

4 likes

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Boost 3
Boost 1
View profile
FrankieBlue-uEP
Level 1

01-03-2019

Similar in that this describes a time range that moves as real time moves. But mine is more customizable on an as need basis.

Avatar

Avatar
Coach
Community Advisor
Urs_Boller
Community Advisor

Likes

530 likes

Total Posts

1,024 posts

Correct reply

257 solutions
Top badges earned
Coach
Bedrock
Contributor 2
Originator
View profile

Avatar
Coach
Community Advisor
Urs_Boller
Community Advisor

Likes

530 likes

Total Posts

1,024 posts

Correct reply

257 solutions
Top badges earned
Coach
Bedrock
Contributor 2
Originator
View profile
Urs_Boller
Community Advisor

01-03-2019

and what is you "calculation date" if it is not the "report date range"?

I think what we need is the possibility to have a date range relativ to the report date range AND more options to set start and end point of the date range.

example: if I select a date range like 25-28.19.2018 I want a dynamic date range LY = "start of report date minus one year to end of report date minus one year"

that means if Inchange the report date manually, the date range LY changes accordingly.

would that meet your expectation?

jen.lasser​ are there any plans for such dynamic date ranges?

Avatar

Avatar
Boost 3
Level 1
FrankieBlue-uEP
Level 1

Likes

4 likes

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Boost 3
Boost 1
View profile

Avatar
Boost 3
Level 1
FrankieBlue-uEP
Level 1

Likes

4 likes

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Boost 3
Boost 1
View profile
FrankieBlue-uEP
Level 1

01-03-2019

Perfect!

Avatar

Avatar
Validate 1
Moderator
jen_lasser
Moderator

Likes

119 likes

Total Posts

318 posts

Correct reply

8 solutions
Top badges earned
Validate 1
Give Back 25
Ignite 3
Ignite 1
Give Back 5
View profile

Avatar
Validate 1
Moderator
jen_lasser
Moderator

Likes

119 likes

Total Posts

318 posts

Correct reply

8 solutions
Top badges earned
Validate 1
Give Back 25
Ignite 3
Ignite 1
Give Back 5
View profile
jen_lasser
Moderator

05-03-2019

Not currently, but we can keep an eye on this suggestion and see how much demand there is for something like this. Not counting anything out for the future!

Avatar

Avatar
Give Back 3
Level 2
SM_AP1
Level 2

Like

1 like

Total Posts

11 posts

Correct reply

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

Avatar
Give Back 3
Level 2
SM_AP1
Level 2

Like

1 like

Total Posts

11 posts

Correct reply

0 solutions
Top badges earned
Give Back 3
Boost 1
Ignite 5
Give Back
Ignite 3
View profile
SM_AP1
Level 2

07-05-2021

Would be useful for me - especially if creating a self help workspace for folks not comfortable changing stuff in Adobe