4 Replies Latest reply: May 19, 2011 7:53 AM by matteo.capelletti

# Ordered count

Suppose I have the following table:

Data:

1, 1, C

1, 2, C

1, 3, O

1, 4, R

1, 5, R

1, 6, C

2, 2, O

2, 3, O

2, 4, R

2, 5, R

2, 6, O

3, 3, C

3, 4, C

3, 5, R

3, 6, O

4, 4, O

4, 5, R

4, 6, C

5, 4, C

5, 5, R

5, 6, C

];

I want to obtain a bar chart whose first bar counts the number of C's in the first newsletter of each contact, the second bar counts the number of C's in the second newsletter of each contact ecc. (but the first/second.. newsletter is different for each contact...)

Can anyone help me with this?

Thanks

• ###### Re: Relativized count

Do u need this:

Plz find the attachment below.

• ###### Re: Relativized count

Thanks, but that's not really what I need.

My chart should count in the first coulumn the clicks on the fisrt newsletter a contact has received. In the second, the second and so forth.

So in the example the first coulumn will count the clicks, if any, at idContact=1 and idNewsletter=1, idContact=2 and idNewsletter=2 (because the newsletter 2 is the first for contact 2), idContact=3 and idNewsletter=3 ... Then in the second column it count the clicks, if any, at idContact=1 and idNewsletter=2, idContact=2 and idNewsletter=3, idContact=3 and idNewsletter=4... The second newsletter received by each contact. And so forth .

Is it any clearer?

Thanks a lot!

• ###### Re: Relativized count

Hi.

Regards.

Oscarashi

• ###### Re: Relativized count

Not really. I think I should make use only of a calculated dimension which has the first newsletter of each contact, then the second newsletter of each contact and so forth. Then I hall calculate the number of C's.