Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=Aggr(Count(Distinct Year),Customer)
From this expression, I've created buckets where you have customers with 0,1,2,3, years of business.
Now I would like to create a pie chart with these buckets with the dimension being the distinct years. How would I go about doing this? Thank y ou in advance.
Hi
Could you explain a little bit more what you ar trying to achieve.
Cheers
Darius
Apologies for the ambiguity.
I have a list of clients and sales over 3 years and 10 sales divisions.
The end result I want is to create a chart/pie chart that shows:
sales of clients who have dealt with all 10 divisions,
sales of clients who have dealth with 9 divisions,
sales of clients who have dealth with 8 divisions,
sales of clients who have dealth with 7 divisions etc....
I used the aggr(count(distinct division), client) to create the appropriate buckets in a LIST BOX but i'd now like to create a new field named 'Clients and number of divisions'. This would presumably allow me to create a pie chart with each slice being 10,9,8,7...etc.
If I write this into the script, I'm wondering what the syntax would be or if there is a better solution that would be great.
Thank you.
Hi henrynoh,
view atteched file.
Alex
Thank you! This is precisely what I was looking for.