Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
SOLVED

Scheduled projects display issue when on rolling dates

Avatar

Level 1

I've scheduled a daily report on rolling dates but data of the latest days would be hidden if I did not manually expand the component once in a while. Is there a way to have this done automatically? Thanks!

1 Accepted Solution

Avatar

Correct answer by
Level 4

This is because the FreeForm size stays the same as last saved project which is the layout that gets rendered while generating the scheduled output. 

The workaround would be 

1. Avoid table and have some visualization for the same table . 

2. Create FreeForm table sized more then number of line items you are estimating  like for 3months data by day should have atleast size of 90-93 line items  with the max number of Row 200-400. 

3. Or spilt the date range, with that you have have week by week or Monthly equaly split FreeForm table which will no screw up the PDF output . 

 

suneeshkachroo_0-1630962243025.png

 

4. SHould be Identified as bug. 

 

View solution in original post

6 Replies

Avatar

Employee Advisor

@kittychang Rolling dates allow you to generate a dynamic report that looks forward or backward for a set period of time based on when you ran the report. For example, if you want to report on all Orders placed “Last Month” (based on the Created Date field) and ran that report in December, you’d see orders placed in November. If you ran that same report in January, you’d see orders placed in December.

 

Now can please elaborate more on the issue you are facing in this context ?

@VaniBhemarasetty Thanks for your response. However, in our case, we are using the rolling dates function to monitor daily visits & visit trend of our campaigns, which is the reason we are having Adobe Analytics schedule-send a daily visit report PDF to our colleagues. The issue here is that, even if we left space for 10 rows of data in a component/chart/campaign first day of launch, for example, we'll have to come back once in a while to manually expand each component because when there are 15 rows of data the component will not automatically expand itself to display the 11-15th rows but gives you a scrollbar. The 11-15th rows, nevertheless, will not be displayed in the daily visit report PDF as you can't use a scrollbar in a PDF.

 

Moreover, since our campaigns usually last around 3 months and at the end there will be at least 90 rows of data per component. We'll have to manually expand the components for multiple times during when the campaigns are up and running.

Avatar

Correct answer by
Level 4

This is because the FreeForm size stays the same as last saved project which is the layout that gets rendered while generating the scheduled output. 

The workaround would be 

1. Avoid table and have some visualization for the same table . 

2. Create FreeForm table sized more then number of line items you are estimating  like for 3months data by day should have atleast size of 90-93 line items  with the max number of Row 200-400. 

3. Or spilt the date range, with that you have have week by week or Monthly equaly split FreeForm table which will no screw up the PDF output . 

 

suneeshkachroo_0-1630962243025.png

 

4. SHould be Identified as bug. 

 

Avatar

Level 1

@suneeshkachroo Thanks so much for your insightful response! This is really helpful

Solution 2 didn't work for us as there would be too much blank space shown in the report PDF especially during first half of the campaign, but would definitely try out solution 3 which sounds brilliant. Really appreciate the help and thanks again!

Avatar

Employee Advisor

@kittychangThanks for writing in. I have heard of this behavior earlier too. What happens when you try scheduling the report by selecting all 400 rows, by default?

ishans52004352_0-1630927977201.png

 

Avatar

Level 1

@Ishan_Sinha_ We selected all 400 rows for all charts but the problem was still not solved. So I think the reason is, as @suneeshkachroo suggested above, "FreeForm size stays the same as last saved project which is the layout that gets rendered while generating the scheduled output."