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

Compare This Week to Date with the Equivalent Last Year

Avatar

Avatar
Give Back
Level 1
HayleyJY
Level 1

Likes

2 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Give Back
Shape 1
Boost 1
View profile

Avatar
Give Back
Level 1
HayleyJY
Level 1

Likes

2 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Give Back
Shape 1
Boost 1
View profile
HayleyJY
Level 1

19-01-2021

Description - The ability to compare this week to date with the equivalent last year

Why is this feature important to you - YoY comparrisons important to understand business performance

How would you like the feature to work - custom date range builder

Current Behaviour - currently you can only achieve this by minus a number of days, this then fails when its a leap year as there are a different number of days in the year.  The current tool doesnt allow you to minus a set number of weeks in this situation.  When you say start of current week minus 52 weeks and end of current day minus 52 weeks it gives you a date range that is impossible.  The end date being the day before the start date