Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations 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