Expand my Community achievements bar.

Fixed-Rolling dates - month granularity - Dashboards


Level 1


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


Level 2


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