Set All list of value as default value on Query prompt

[0swdas]

Hi Team,

Our requirement is to create a filter to select year :

And in select year prompt the prompt will be like this :

when user will refresh the report and open the prompt it will show in radio button to select the year

All

2023

2022

2021

So here i have created a list of value and parse in dimension and created a filter so in prompt when user will click All option it will show All the years data in report.

and if user will not select All option he can select any single year option .

But my requirement is that when user will refresh report automatically with out disturbing prompt it will take All option as a default value .

and if user want to select any other year he can open prompt and select radio button

so could you pls provide the required filter formula for this scenario.

@Select(Login Year\Year) IN @Prompt('Select Year','A','Login Year\Year',Mono,Constrained) Or 'ALL'

IN @Prompt('Select Year','A','Login Year\Year',Mono,Constrained)

its working but i need how to set default prompt as All option.

Thanks,

Swastika

[CdnConnection]

Why not just make the Prompt with OPTIONAL, this way if the users don't select anything ALL years will be slected

Ajay

[0swdas]

Hi Sir,

I can see If we dragged the dimensions in query filter then only we can see the optional prompt option

Can it possible if we create a native filter and try to set default in webi itself.

Thanks,

Swastika