Greetings,
The ticket is related to the previous ticket: link, which you marked as SOLVED without responding there. Though I never mentioned the issue is resolved, please kindly help me further:
Let me describe the issue again:
In genera,l I have two events:
- event A
- event B
1) Event A has the "spend" property, I will have to use this property value in the formula.
2) In Event B I would need to use the number of unique UNIQUES(B) calls - this is clear.
I need to have a sum of values of event A for the last 7 days within 180 days. I found the CUMSUM() formula which does almost everything I need, but I cannot set up a number of days for which I want to get a sum of values. Logically, the formula should look like this:
CUMSUM(PROPSUM, A, 7)/CUMSUM(UNIQUES, B)
I need to select 180 days on the chart: https://prnt.sc/oKAwqbOI5rmI.
But I am getting 400 error: status code. I understand that the CUMSUM() formula does not support the third parameter (7 days). But maybe there's another way to achieve the result?
Please share more information
Thank you
Best answer by Saish Redkar
View original