You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!

How do I extract a range of dates from the current_date object in OAC

Accepted answer
25
Views
2
Comments
edited Apr 21, 2020 5:42PM in Oracle Analytics 2 comments

Summary

I want to extract a range of dates (last 7days or last 14days) from the current_date object in OAC

Content

Hello,

In a OAC project, I have a visualization, that uses current_date object as the x-axis and current_month as the top level filter.

Currently, as shown in the screenshot, for the current_month, data for current date alone is shown.

I have a requirement to show data for only past 7 days, i.e., data for Apr13 - Apr19. How would I show this? What is the calculation I need to use for this?

Thanks in advance,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!