Filter data based on expression

[#1]

Hi All,

I am trying to filter out records on changing one slider based on an expression results. I have shown in a table, a column that has accumulated percentage (sorted on a ranked column). What I want is to filter out the records based on this accumulated percentage column after the selected (on slider) value is covered in this column.

I am sorry for unable to explain the situation the best, however I have created an example of what is required. Please see attached document. 

regards,

Salman

[#2]

Attached with answer. You can use a calculated dimension.

Hope it helps.

Thanks

[#3]

Hi Ajay,

Thank you for the quick response. This is really helpful though it didn't serve the purpose. I am using that table on the right just to show the complete dataset being used in analysis however the goal is to use the filtered data in the chart in the middle.

[#4]

Oh ok i didn't know you wanted it in the Bar chart. In that case

The calculated dimension you already have put that in the back-end and create a new field say - TestField

Then use the expression you already have in the chart expression for filtering out the data.

Thanks

[#5 · Accepted solution]

Hi,

I was able to get required results by:

1-     Sorting data source on Direct Cost field.

2-     Adding a trigger on variable change and in trigger, select in Discharge Id field the following expression:

'('&concat(Aggr(if(rangesum (above(sum([Direct Cost]),1,RowNo()-1))/sum({$<[Discharge Id]=>}Total [Direct Cost])<v_x_percent_cost_driver,[Discharge Id]),[Discharge Id]),'|')  &')'

regards,

Salman