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

Question

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.

Carter Beaton · Answer

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

Gianni Ceresa · Answer

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

User_PGXQQ · Answer

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.