Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

pick date

Closed
21
Views
2
Comments
User_VMJII
User_VMJII Rank 4 - Community Specialist
edited Aug 17, 2024 9:38AM in Oracle Analytics Cloud and Server

I have a manual query like:

select x, y, z, count(*) N

from table_a, table_b

where open_date <= '31.12.2020'

and nvl(close_date, '31.12.2020') >= '31.12.2020'

group by x, y, z

I need to upgrade it so that the user can choose any date in the visualization (instead of the specified '12/31/2020')

Can someone please help me?

Best Answer

Answers

  • JohnW-Oracle
    JohnW-Oracle Rank 7 - Analytics Coach

    Hi @User_VMJII,

    Thank you for the question. You could add a couple filter/prompts (open_date and close_date) to your Visualization so users can select dates.

    Regards,

    John

This discussion has been closed.