Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!

Fixed-Rolling dates - month granularity - Dashboards

Avatar

Level 1

12/12/12

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

2/18/15

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