Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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
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])
or
=Num(Count(DISTINCT [Mobile Number]) / Count(DISTINCT TOTAL [Mobile Number]),'#.00%','.',',')
for a percentage.