Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

DV Dashboard Filter-List option-display all related items + Selected item and same with dependent.

25
Views
4
Comments
User_PGXQQ
User_PGXQQ Rank 2 - Community Beginner
in Oracle Analytics Forum

Hi,

DV Dashboard Filter-List option-display all related items + Selected item and same with dependent filter. In 'List' filter.

for ex:1

In 'Year' filter display all years and selected year, in 'Month' filter display all months with selected month.

Year, Month filters are dependent on each other.

Please see image.

ex2:

'customer Id' filter displays all the 'customer Id' + selected 'customer Id'.

'customer Name' filter display all the 'customer Name'+ selected 'customer Name' with dependency.

Comments

  • User_PGXQQ
    User_PGXQQ Rank 2 - Community Beginner
    image.png
  • User_PGXQQ
    User_PGXQQ Rank 2 - Community Beginner

    as it is explained in ex2,
    looking for this idea or request to develop in OAC.

    Customer_id, Customer_Name filter conditions display all the values at left file pane show selected items at right filter pane. Currently Customer_id filter shows this but not Customer_Name doesnt.

    looking for a requirement that Cutsomer_name(dependent on Customer_id) filter condition 'show all the values in left and show only selected values in left pane'.

    Intention here is,
    Filters: Customer_id, Customer_name
    Users wants to select Customer_name first and then Customer_id behaves a dependent and vice-versa. In this, users wants to see all the list of customers in both the filters so that they can identify customer from 'Id' or 'Name' and select the customer.

    Just like above screen 'Year', 'MonthName' shows all the values at left filter pane and selected at right filter pane, same manner, users wants to see customer_id, Customer_name display all the values at left pane and selected values at right pane in all the dependent filters.

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    This post was in a very strange category, and therefore I believe nobody saw it for the past 2 months. It has now been moved to the OAC-OAS category.

    If you are asking for a new feature in OAC, you should consider posting an idea in https://community.oracle.com/products/oracleanalytics/categories/aidp-idealab

  • Carter Beaton
    Carter Beaton Rank 4 - Community Specialist

    Not sure if you have found your answer. It sound like you want to control the limit by option of the filters. If the filters are in the same Dashboard Filter viz, then you can go to the dashboard filter properties and select the Filter Controls tab. Expand the column and there is an option "Limit Values By" you can change. If you select the option to None, the filter will load all value in the column regardless of what is selected in the other filters in the same dashboard filter viz.

    The video below shows an example.

    https://youtu.be/wAOL_8eTOBg?si=aEtGiyOC2jbsD_Pm

    image.png