Choice list filter with display and return value

Dries C · Feb 5, 2018 6:00AM

Hi,

Is there a possibility to create a “choice list” filter with a return value that differs from its display value.

For example we have some date filter with the following options:

(Arguably, the first 2 values should be calculated.)

In the create filter form however we can only enter the display values.

I noticed this question was asked a long time ago:

And there is a solution to move the case from the filter per analysis to a function:

But when I open a dashboard and check the HTML source code, I find the following in the script at the bottom:

{"caption":"3 Months Ago","codeValue":"3 Months Ago","eType":0}

And a property preceding this:

"isDoubleColumnInput":false

That property could mean sth. else but it sure seems like there should be a possibility to not only set the “caption” but also set the “codeValue”.

Is this a property than can be enabled?

Thanks!

Dries

Joel · Feb 5, 2018 6:14AM

You'll need to do this in 2 steps:

In your analysis on the same page as your dashboard prompt, you can have a column/filter with formula similar to this that references the presentation variable which is populated via the dashboard variable prompt from above:

Dries C · Feb 5, 2018 8:48AM

Hi Joel,

Thanks for your answer. This is actually the way we're doing things at the moment.

I was looking for a way to define the values straight away, as part of the choice list.

If you're used to working with HTML, it's very strange not to be able to define the return values.

Seeing as the "codeValue" attribute is mentioned in the pages javascript, I thought maybe it was an option that could be enabled.

Dries

MFA for Oracle Community