How to do this by Set Analysis function or other ways?

[Anonymous]

For example, we have 2 sellers on 3 customers, we want to know how much "seller day(SD)" on every customer.

If one seller 100% visit on C1, then we call there is 1SD on C1.

If one seller 40% visit on C1 and 60% visit on C2, then we call there is 0.4SD on C1 and 0.6SD.

The data is following

Load * Inline[

Customer, Seller, Visit_Date

C1, S1, 2012-12-1

C1, S1, 2012-12-5

C1, S2, 2012-12-5

C2, S1, 2012-12-20

C3, S2, 2012-12-25

]

I want to get this result, but I do not know how to write expression for SD.

Customer	SD
C1	1.17
C2	0.33
C3	0.50
Total	2.00

[swuehl · Accepted solution]

Create a chart with dimension Customer and expression

=sum( aggr( count( Visit_Date) / count(total<Seller> Visit_Date), Customer, Seller))