list box, current selection box

Thu, 19 Feb 2015 07:57:11 GMT

my one the dimension column lets say "is_sold" have two type of values 1,0

is_sold

this column is put into list box, i use expression - =if(is_sold=1 ,'yes','no')

2. i also have current selection box on my dashboard.

behavior:

if i select filter from list box to "yes" then current selection box also show to 1 (which is basic value of column)

i want:

i want to see "yes" in selection box instead of 1.

without using dual function at script level.

is it possible?

Re: list box, current selection box

AbhijitBansode — Thu, 19 Feb 2015 08:01:55 GMT

As per my understanding, its directly not possible in UI.

However, you can do a workaround. use text object to show current selections.

You can then write expression in it.

if(GetFieldSelections(is_sold)=1,'yes','no')