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

Anonymous — Sun, 19 May 2013 15:13:23 GMT

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.

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

swuehl — Sun, 19 May 2013 15:24:57 GMT

Create a chart with dimension Customer and expression

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