Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 53 Oracle Analytics and AI Sharing Center
- 25 Oracle Analytics and AI Lounge
- 307 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.6K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 118 Oracle Analytics and AI Trainings
- 22 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
How to set default filter to first available value
I'm working with two canvas pages, canvas1 and canvas2, both equipped with identical filters. My objective is to have the filter on canvas2 initially set to the first value by default, while the filter on canvas1 should default to displaying all values. If a selection is made in the canvas1 filter, it should automatically update the filter on canvas2 accordingly. Additionally, if 'All' is selected in the canvas1 filter, the filter on canvas2 should revert to displaying the first available value.
I've attempted to address this by creating a parameter for the canvas1 filter and enabling the 'First in List' default value option for the canvas2 filter, using the parameter from canvas1. Initially, the canvas1 filter correctly displays the first available value. Changes made to the canvas1 filter are accurately reflected in canvas2. However, when I select 'All' in the canvas1 filter, the canvas2 filter also defaults to 'All', whereas I expected it to show the first available value
Any suggestions you have would be helpful. Thanks in advance!
Best Answer
-
Set the same parameter to the filter in canvas1 and canvas2. Selecting all the values in canvas1 will show all the values in canvas1, but canvas2 shows the first available value which is set in the parameter.
0
Answers
-
Hi @Rashmi Jadhav-Oracle
If the reply was helpful and answered your question, then please mark it as 'answered'. This helps the community when there are future searchers seeking answers.0
