1 Reply Latest reply on Jul 26, 2018 9:53 AM by Deepak Rai

    Finding List of products with successive failures

    Rahul Singh

      Hello All,


      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.