Oracle Analytics Cloud and Server

Products Banner

Filter by Button click

Received Response
37
Views
2
Comments

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

     

  • Brian666H
    Brian666H ✭✭✭✭✭

    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.