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

Coffee Break: Join us on Wednesday, April 5th at 10am PT to chat with Ben Gaines, Director of Product Management for Adobe Analytics. Ben will be online to answer your Analytics and Adobe Summit questions.

Fixed-Rolling dates - month granularity - Dashboards

Avatar

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

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