I faced an issue with rendering a chart using your custom formulas.
In general 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 perform the following calculations:
1) Take the "spend" property value (can be any number) and sum them up over the last 7 days.
2) Divide the result by the sum of Event B calls over the last 7 days.
If I try to imagine the formula logically, in a simple way, then it should be something like:
(Sum of event A properties "spend" for the last 7 days)/(Sum of events B for last 7 days)
I checked your documentation together with tech support topics, but I couldn't find the way to create such a formula.
Please let me know if anything's unclear. I hope you can help me with achieving it.
Best answer by Saish RedkarView original