Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Schedule Report - 7 Days each Monday
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!
Answers
-
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.
0
