How to filter consecutive values. Please see description and attached dxp file.
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?