I have a scenario. Lets say I have a list of product for which there is a metric(aggregated) calculated on a daily basis. I would like to have a list of all the products for which the value of the metric is less than a threshold. I have attached the excel data for reference. If you look at the data you would notice that Product 2, 9 and 27 have values for three days consecutively less than 98%.
I require a calculated field that gives me the number 3 ( no. of products with successive failure for three days ) and list of those products.
The table updates daily and everyday data gets added to the view.
Hope I made myself clear. Any help would be appreciated.