Oracle Analytics and AI

Child Item

Conditional Visibility of Filters based on selected Parameter Value

Hii OAC Community, As shown below we have a Dashboard Filter bar having :

1) Parameter named Time Frames (Details in screenshot below )

2)Column named Creation Date being used as a Filter with dataType: DateTime and format:dd/MM/yyyy.

3)Derived Dates Columns from above - Creation Date (Year) and Creation Date (Month).

We have a requirement to ensure that:

a)When Yearly is selected from Parameter Value then only Creation Date(Year) Filter should be visible .

b)When Monthly is selected from Parameter Value then only Creation Date(Month) Filter should be visible .

c)When Daily is selected then only Creation Date Filter should be visible.

Pls advise how to achieve this, Thank you….

Use Freeform layout.

Then use Visibility on sections tied to parameter.

You can stack the filters

Use Freeform layout.

Then use Visibility on sections tied to parameter.

You can stack the filters

Thanks a lot @Wayne Van Sluys .It's working Fine 👍️ .

Just a quick question ,is there any way to achieve this by keeping the canvas layout as AutoFit ?

Yes, though you cannot stack in autofit.

Ok,Got it….Thanks for the info @Wayne Van Sluys…