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

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
Give Back 5
Level 2
emmajoan
Level 2

Likes

12 likes

Total Posts

16 posts

Correct reply

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

Avatar
Give Back 5
Level 2
emmajoan
Level 2

Likes

12 likes

Total Posts

16 posts

Correct reply

2 solutions
Top badges earned
Give Back 5
Give Back 3
Ignite 3
Give Back
Ignite 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