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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.