I'm trying to make a retention report, that means that I need to calculate many percentages.
I have this view:
and this is the same report in real numbers:
The X axis is a field of datediff.
Now - What I need to build is a line graph of the percent for each Datediff.
Meaning - for datediff 1 - sum of all the numbers in 1 column divided by sum of all numbers in 0 column (until Aug 19) - 27.71%
For datediff 2 - sum of all the numbers in 2 column divided by sum of all numbers in 0 column (until Aug 18) - 27.61%
And so on...
But the only graph I manage to create is the sum of each datediff column divided by the entire sum in 0 column.
I hope I made myself clear enough - If not, please tell me what's not not clear - I'm sitting on this view for hours now...
Thank you all so much