Scheduled Reports: Show Data for Month before Last | Adobe Higher Education
Skip to main content
January 25, 2016

Scheduled Reports: Show Data for Month before Last

In my dashboard which is sent as a scheduled report on the first day of the month, there is a reportlet called "Visits Previous Month". But the reportlet would actually contain the data for the month 2 months ago. E.g. if the dashboard is generated on Feb 1, the reportlet should contain data for December. My problem is: how can you set a reporting period for this reportlet as a rolling time range? There is no preset date range for that (only "Last 2 months", but it is not what I need). And just a rolling period is also not an option, because the number of days in month vary (30/31). Are there any workarounds I'm missing?

Any advice will be much appreciated!

Ce sujet a été fermé aux réponses.

2 commentaires

martijn_123
Level 3
January 25, 2016

Hi Aline,

 

You can not schedule it for the 28th of each month? A last month report will contain the data you are looking for.

 

Cheers,

Martijn

January 25, 2016

Hi Martijn,

Thanks for your comment. I considered this option. I don't want to send out the dashboard, on say the 28th, cause this dashboard is a monthly report and then for most of the reportlets (except for the troublesome "Visits previous month") the data for 2-3 last days of the month will be missing. What I considered doing is sending the dashboard on the last day of the month as late as possible (11pm). BUT in AA you cannot schedule a report to be sent on the last day on the month!! you can choose 30th, or 31st day of the month, but you cannot have a flexible solution! That's why I chose to send the report on the first day of the month.

warrensander
Level 6
January 29, 2016

i would think running the dashboard on the 1st of the month at 3 AM with dates set for the last 2 months and rolling monthly would give you dec/gan on 2/1 and jan/feb on 3/1 etc.

You can also play with the custom dates now available and create your own dates

it's in the left nav, open the components section and 'manage date ranges'

February 1, 2016

Wow, actually this should work. Thanks for the tip!

Regarding "Manage date ranges" - I have recently noticed this new feature as well, but as far as I understood custom date ranges can be used only in Adobe Workspace.