Grouping data

Wed, 25 Nov 2020 16:16:04 GMT

I have to create a graph that shows the number of campaigns received by the customer base in a month.

on x axis it would be the number of campaigns 1, 2,.....10+

on y it should be the customer base.. 5%,10%,15%....100%

This should show what percentage of the base receives 1,2...10+ campaigns

Data I have is mobile number, campaign code, date.

I did the count(campaign code) against the mobile which gives me the campaigns received for each mobile, how would i group this mobile base?

Thanks

Re: Grouping data

swuehl — Thu, 28 Jul 2016 20:13:50 GMT

Mobile number denotes your customer?

You can try a calculated dimension like

=Aggr( Count([Campaign Code]), [Mobile Number])

and then use

=Count(DISTINCT [Mobile Number])

=Num(Count(DISTINCT [Mobile Number]) / Count(DISTINCT TOTAL [Mobile Number]),'#.00%','.',',')

for a percentage.