1 Reply Latest reply on Aug 21, 2016 12:55 PM by Tharashasank Davuluru

Percentages calculations

Hi All!

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

• 1. Re: Percentages calculations

Hi

please check this. post your sample workbook.

1 of 1 people found this helpful