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:
28 March ***Text***
27 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.
I tried to write down the selection information into a variable, and then from the script code use her. Unfortunately, the script gives an error at circulation to the calculated values of the variable (see the attached file). As variant, may be the information about the selections save to external file (xls, qvd, csv), and then use the information from this external file when loading script?