Optional Presentation Variables

[AEliza]

Hello,

Can we have the feature of "optional" presentation variables in Incorta? We will create these variables, but mark them as optional and if user would like to use them , only then, push the condition to query the data.  

[RADSr]

Can you clarify your question please.

I think you mean to have a presentation variable defined, and if it is populated then apply it as a filter to a query?

If so - yes! You can do that by creating a default value ( e.g. "ALL" ) and creating a filter similar to this:

OR(schemaname.customername = $PresentationVariableCustomerName, $PresentationVariableCustomerName = 'ALL' ) 

It's kind of slick.   We use if for defaulting to all locations, but allowing viewers to quickly narrow down a subset of insights to a specific location while keeping other insights at the enterprise level.