Categories
- All Categories
- Oracle Analytics Learning Hub
- 29 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 237 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
pick date
User_VMJII
Rank 4 - Community Specialist
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?
0
Best Answer
-
Please do not double post.
You asked the same thing, you got replies, you replied as well: stay in that thread.
0
Answers
-
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
0
This discussion has been closed.