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

    Ordered count

      Suppose I have the following table:

       

      Data:

      Load * Inline [

      idContact, idNewsletter, Action

      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