Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
131
Views
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,

Chethana

 

Screenshot 2020-04-21 at 11.09.57 PM.png

Answers

  • Rank 5 - Community Champion

    hello,

    You can add current date as a field in your Data set and OAC has an option to use related filters for date objects:

     

    Time relative filters.png

  • Rank 6 - Analytics Lead

    Hello,

    Thanks a tonne. This has really helped me!

    Regards,

    Chethana

Welcome!

It looks like you're new here. Sign in or register to get started.