Hi, Please help us with this query: In Oracle Analytics Cloud, I have canvas 1 and canvas 2. I have a Data Action that passes all values from Canvas 1 to Canvas 2. The problem is that canvas 1 passes only 3 values and Canvas 2 has these 3 values and another one in a dashboard prompt and the fourth value does not reset to ALL values. Here is an example: * Go to Canvas 2 and select values in the 4 filers in dashboard prompt. Value in the fourth filter is "ABC" * Go to Canvas 1 and click on the data action that passes 3 values to Canvas 2 * Now in Canvas 2, I see all three values that were passed by Canvas 1 but the fourth value is not reset to all values. It keeps displaying "ABC" value from a previous query and hence render an incorrect result. We need the fourth value in the dashboard prompt in Canvas 2 reset to all when it's been called from the data action from canvas 1. I tried Default value to "All" but it searches the "all" value in the filter

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Data Action

Erikaa-Oracle

Hi,

Please help us with this query:

In Oracle Analytics Cloud, I have canvas 1 and canvas 2. I have a Data Action that passes all values from Canvas 1 to Canvas 2. The problem is that canvas 1 passes only 3 values and Canvas 2 has these 3 values and another one in a dashboard prompt and the fourth value does not reset to ALL values.

Here is an example:

Go to Canvas 2 and select values in the 4 filers in dashboard prompt. Value in the fourth filter is "ABC"
Go to Canvas 1 and click on the data action that passes 3 values to Canvas 2
Now in Canvas 2, I see all three values that were passed by Canvas 1 but the fourth value is not reset to all values. It keeps displaying "ABC" value from a previous query and hence render an incorrect result.

We need the fourth value in the dashboard prompt in Canvas 2 reset to all when it's been called from the data action from canvas 1. I tried Default value to "All" but it searches the "all" value in the filter

Find more posts tagged with

Accepted answers

All comments

Shantaram-Oracle

Hi @Erikaa-Oracle, It helps to understand better if you can attach your data action screenshot and your canvas2 values screenshot as well.

Erikaa-Oracle

Canvas 1

Canvas 2: By Cluster Description

Thanks. The issue is when the user first go to Canvas 2 and select a value in "Description". Then when he/she goes back to Canvas 1 and click the data action in the heatmap from Canvas 1 it passes all values that I have in Canvas 1 (Date, country, type and category) to Canvas 2 and the fourth filter "Description" that I don't have in canvas 1 is not reset to All in Canvas 2. It keeps as NA that is a value we set in a previous request.

As a workaround, I've added a filter at the top of Canvas 1 for Description but it only works if I select all values in Description in Canvas 1. Then I can see in Canvas 2, Description is selected with all possible values. If a user needs to select one specific value in Canvas 2, it has to clear the filter and then select the value he/she needs.

Is there a way that Canvas 2 shows "All". I also tried default value but it actually searches for the "All" value instead of choosing all possible values in the filter.

Thanks for your help.

Shantaram-Oracle

Can you please change the data actions pass values from all to custom and check if it Passes only user selected custom filter values for the selected data?

Federico Venturin - Oracle

Hi @Erikaa-Oracle ,

This is the expected behaviour of dashboard filters in Data Visualization. Previously selected values in dashboard filters are persisted when you manually navigate between canvases, and they are not overwritten with actions if you don't specify a different value for them (either using a dedicated dashboard filter or clicking on a specific column in a visualization).

As a solution, you could:

split your canvases into 2 separate workbooks
edit the current action to navigate to second workbook
add a new action to the second workbook to navigate back to the first one (you have to specify that you don't want to pass values for the Description column in the data action definition)

Erikaa-Oracle

Thanks Federico. How do I specify to not pass a value for a specific column? Should I select Pass values = custom and pass all other fields except description?

Federico Venturin - Oracle

Hi @Erikaa-Oracle ,

When you create the data action, you have to set Pass Values to Custom and make sure that the Description column is NOT selected.

Erikaa-Oracle

Thanks Federico. We finally decided to use workbook filters instead of dashboard filters.