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

Allow Last-Year-to-Date in Analysys Workspace date range manager -- that excludes "today"

Avatar

Avatar
Boost 50
Level 9
normcloutier8
Level 9

Likes

450 likes

Total Posts

66 posts

Correct reply

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

Avatar
Boost 50
Level 9
normcloutier8
Level 9

Likes

450 likes

Total Posts

66 posts

Correct reply

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

17-08-2016

Short version of this request: Add 366 as an option in "days minus" of date manager.

 

Why? If you want to build a YTD comparison for last year and this year, you are forced to include "today" a year ago -- which will be a full 24 hours -- and "today" this year, which may be far less than a full day. Ideally, I would want a YTD that excludes "today" which is easy to build for the current year, but impossible for the previous year.

 

Model now for LAST Year-to-date:

    Setting this rolling timeframe on Aug. 17, 2016

           -Start of-     -current year-  -minus-     -1-      -year -

           -Start of-     - current day-   -minus-   -365-    -days

 

Which gets me 1/1/15-8/17/15

 

If I could set minus-days to 366 I could get to the desired rolling window of 1/1/15-8/16/15

Thanks for your consideration.

2 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

17-08-2016

Good suggestion @NormCloutier2. I'm in favor of doing this. 

Avatar

Avatar
Ignite 1
Level 2
ctromey
Level 2

Like

1 like

Total Posts

7 posts

Correct reply

0 solutions
Top badges earned
Ignite 1
Boost 1
Applaud 5
Applaud 50
Applaud 25
View profile

Avatar
Ignite 1
Level 2
ctromey
Level 2

Like

1 like

Total Posts

7 posts

Correct reply

0 solutions
Top badges earned
Ignite 1
Boost 1
Applaud 5
Applaud 50
Applaud 25
View profile
ctromey
Level 2

05-10-2018

I'd rather have the option to always exclude "today" even when I'm not comparing to a previous time-frame.  For some analysis, we prefer to use full days of data and it would simpler to have an 'exclude today' check box, then I can select last 30 or 90 days and not have to fiddle with the dates.