Oracle Analytics Cloud and Server

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

How to reset value in dashboard prompt when switching between radio button.

Question
1
Views
0
Comments
Kari_100683-Oracle
Kari_100683-Oracle Rank 3 - Community Apprentice

I have a requirement to switch between the dates through radio buttons in dashboard prompt. To implement this I've done the below changes:

  1. Defined a Variable Prompt and radio buttons to pick either "Invoice date" or "Amount paid date".
  2. Created two different dashboard prompts for "Invoice date" and "Amount paid date" based on the column value.
  3. Created two different sections in dashboard for these two new column prompts.
  4. Created an analysis with a dummy column which returns 0/1 rows based on the filter on Invoice date=pvar1.
  5. Added condition based on this new analysis on two new sections created in step3.
  6. So when I switch from one radio to another ,a respective section shows the date.

 

When I select Invoice date with some date range and then switch to the amount paid date radio button, the value for Invoice date should be cleared/reset, which is not happening. Vice-versa is also true. Is there any way we can reset values when we switch between buttons?