Hello dear Support service!
I have previously submitted a question to the ticket https://community.amplitude.com/building-and-sharing-your-analysis-58/how-can-several-events-with-certain-time-intervals-be-displayed- in-one-chart-1030?postid=3547#post3547 for which you quickly found a solution, for which I am very grateful!
Since that ticket is already marked as RESOLVED, I decided to create a new ticket.
I need to add another chart where I will use events A and B in it (these can be any events)
First I need to do some simple math between events:
Event A multiplied by 100 and divided by event B - A*100/B.
Next, I need to substitute the result of these calculations in the ROLLWIN() form in order to display the result of the formula on the chart. But I can't do that because the specific syntax of the ROLLWIN() formula doesn't allow me, I can only use:
ROLLWIN(UNIQUES, A, 7)
ROLLWIN(TOTALS, A, 7)
So the question is, how do I substitute the result of my calculations (A*100/B) into the ROLLWIN() formula?
I would highly appreciate your help!
Best answer by Saish RedkarView original