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

Fixed-Rolling dates - month granularity - Dashboards

Avatar

Avatar
Boost 1
Level 1
keithmacd
Level 1

Likes

2 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
Applaud 5
View profile

Avatar
Boost 1
Level 1
keithmacd
Level 1

Likes

2 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
Applaud 5
View profile
keithmacd
Level 1

12-12-2012

We need better handling of Fixed-Rolling date combinations on dashboard reportlets with Month granularity.  This appies as example to (fiscal) year-to-date reporting.

 

I've got dashboard reportlets with a Fixed starting date and rolling end date, with Month granularity.  The problem is the reportlet's rolling date is *daily* relative, not monthly.  As example, "last month" includes only until Nov 26 instead of Nov 30 - the 26th is relative to the day last time I updated the date range.

 

The work-around is to update the reportlet date range every month, defeating the purpose of automated reporting.

1 Comment

Avatar

Avatar
Validate 1
Level 2
emmajoan
Level 2

Likes

12 likes

Total Posts

16 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
emmajoan
Level 2

Likes

12 likes

Total Posts

16 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
emmajoan
Level 2

18-02-2015

Agree agree. It's easy to solve this in Report Builder using date functions in Excel, but then Client Care recommended to me that I shouldn't use dates from cell for scheduled reports, just in case my report suite time zone and where my report is scheduled on Adobe's time zone do not match up. So I definitely need a reliable rolling:

- this month-to-date

- last month-to-date

- last year month-to-date