3 Replies Latest reply: Mar 30, 2017 11:48 AM by Martin Bacul�k RSS

    Calculate Date that reach a threshold value

    Andrea Giacomello

      Hi experts!

      I would like to calculate the exact date in which the cumulative value of a field reach a certain point. How can i do it?

      Example: i have a dataset in which for each day there are a certain number of values collected, like:

       

      Date:          xxx

      28 March     ***Text***

      27 March     ***Text***

      27 March     ***Text***

      27 March     ***Text***

      26 March     ***Text***

      23 March     ***Text***

      23 March     ***Text***

      23 March     ***Text***

       

      I would like to know which is the DATE_X in which the number of ***text*** from today till DATE_X is equal to 5. I cannot do that using the loadscript because the result has to be dependent to the filters present in the sheet.

       

      Any help?

      Thankyou very much!