CREATE DIMENSION from =Aggr(Count(Distinct Year),Customer)

[#1]

=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.

[d_pranskus]

Hi

Could you explain a little bit more what you ar trying to achieve.

Cheers

Darius

[#3]

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.

[#4 · Accepted solution]

Hi henrynoh,

view atteched file.

Alex

[#5]

Thank you! This is precisely what I was looking for.