How to filter consecutive values. Please see description and attached dxp file.

Hi All,


Please see attached dxp. I am trying to create a bar chart with accepted Ratio which is sum(accepted)/ sum(carried over)+sum(new ones)).

I would like to color the accepted ratio as below.

Greater than 90% Green

Less than 80% Red

Between 80% and 90% as Amber.

I wanted to create a filter with values as "Green", Red" and Amber". Whenever the user clicks on "Green" the Bar chart (X axis - Project and Period) should show only consecutive periods where accepted ratio values are above 90%.

Similar way if "Red" is selected it should show bar which has consecutive values below 80%.

How can we do this?

Thank you



Binary Data testing.dxp164.66 KB