Schedule Report - 7 Days each Monday

User_10Z3A

Hello

I've created a report with all tabs and modified them as needed. I'm to the point that a I need to create a formula potentially, via cloud R&A. We used to have opera v5 so it was easier to generate what we needed. Unfortunately, we no longer have access to Opera V5 to see how this looked. This report will be scheduled to be sent every Monday at 6:00am with data from previous Monday - Sunday. Could you assist with the formula?

Would I create filter under STAY DATE tab, OPERATOR: "Is between" - check box Convert this filter to SQL, hit OK and enter a formula in that area?

Any information would help!

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/25676/schedule-report-7-days-each-monday

Hi @User_10Z3A,

Welcome to the Oracle Analytics Community.

Can you please try one of the following methods? It should work fine.

In case if you want the SQL, here it is:

"Time"."Date" BETWEEN CURRENT_DATE - 7 AND CURRENT_DATE

Hope this help.

Thank you.