Creating a running percentage chart

KieranVinomofo

Hi All

 

I have a dataset, which is broken up into 4 populations (which is my series). I am trying to create a chart (or table) that shows the percentage of each population that had made their first purchase by a given day after signing up as a member (ie- % that bought for the first time by day one, then cumulative percentage that had bought by day 2, day 3) until eventually at some point each population would be showing 100%.

I'm trying to manipulate a Running Total Line chart to make it a running percentage, but I'm having no luck. Can anyone suggest another way to approach this?

 

My data is set out as follows:

Customer ID	Days to Convert	Population
1	1	Prior Year
2	1	Group 1
3	5	Group 2
4	6	Group 3
5	2	Prior Year
6	2	Group 1
7	2	Group 2
8	4	Group 3
9	3	Prior Year
10	10	Group 1
11	5	Group 2
12	13	Group 3
13	4	Prior Year
14	8	Group 1
15	9	Group 2
16	16	Group 3

 

Any guidance would be appreciated.

Thanks

laura_igl

Hi,

Is anyone able to help out with this request?

Thanks,