pick date

User_VMJII

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?

Gianni Ceresa

Please do not double post.

You asked the same thing, you got replies, you replied as well: stay in that thread.

https://community.oracle.com/products/oracleanalytics/discussion/22635/date-in-manual-query

JohnW-Oracle

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