5 Replies Latest reply on Aug 14, 2019 7:26 AM by Zhouyi Zhang

    How to compare data with previous week data for trend


      Hi All,


      I have a data set like for each equipment, I am getting its true reachability value every week on Friday.

      I want to compare true reachable value for each equipment with the previous week and want to calculate "dropoff".

      Now, Dropoff = If for an equipment, true reachable value change from "1" to "0" in a week compared to the previous week. Hence, dropoff % = (count of dropoff equipment/ that day total equipment)


      I have created a date field but nit sure how to update the data for the day.