1 slider pointing to 2 data columns

[Anonymous]

Hi all ,

I have one slider object on the report and 2 column values "Rating Scale" and "Requirement Scale" which consists of entries from 0 to 10.

how do i create one slider so that when i filter the slider it searches the data in both the column and result the data.

kindly suggest on how to achieve this .

Thanks & Regards

[HarishG]

Hi,

Can you elaborate your scenario?

[Anonymous]

Hi Harish ,

I have 2 columns for ratings , "Current Rating " and "Requirement Rating" , values in these 2 columns are  from 0 to 10.

now on the report i have a filter called Product type (list box) which has 2 values "Current" and "Recommended"

and i also have a slider .

now the requirement is when i select "Current " in the product type filter i want the slider to reflect "Current Rating" column values .

and when i select "Recommended " in the product type filter i want the slider to reflect "Recommended Rating" column values .

this has to be achieved on the single slider option available in the report.

Kindly suggest on how to achieve this.

Thanks in advance

[HarishG]

If you are using Field in the slider, then you can write the expression below,

=if(Product type='Current',Current Rating,Requirement Rating).