Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 279 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 105 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Filter by Button click
Summary
Need to filter all data on sheet with one button click
Content
Team
My user needs the ability to filter all data by Yesterdays date by clicking a button, then reset by button click.
Click:Todays_Date() -1, show only Yesterday
Click: Clear, show all dates
Date fields is Entered_DTTM
Version
18 , Cloud
Answers
-
Hi
I have built something similar in a dashboard: by default we display this month numbers and by clicking 'Last month' button, you get the numbers for the previous month.
To do it:
- Create two pages on your dashboard
- Insert an "Action Link" on Page 1 pointing to Page 2 and similarly on page 2, pointing to page 1
In the Section Properties, you can use "Custom CSS Class" = Section Button so your Link is displayed as a button
- In Properties, Hide Page 2
Hope this makes sense and will help you.
Cyrille
0 -
Cyrille
That sounds like one way to do it. I have 7 report objets on my page so that would not be my first option unless it is my only option.
0
