4 Replies Latest reply: Jun 16, 2015 4:02 PM by Marcelo Fonseca RSS

    Count based on several lines with 1 field in common

      Hi, I have a database like the one below, and i would like to count in a graph something like the expression below:

            

      IDActivity ActionActivityDateResponsableRework Type
      1ExecutedAA01/01/2015A-
      1VerifiedAA02/01/2015B-
      1ReworkAA03/01/2015CRTA
      1ExecutedBB04/01/2015D-
      2ExecutedAA04/01/2015A-
      2VerifiedAA05/01/2015B-
      2ReworkAA06/01/2015CRTB
      2ExecutedBB07/01/2015D-

       

      For the same ID,

      IF Responsible = "A" for Activity Action "Executed", and Activity Action "Verified" has data in Date Field,  and Activity Action "Rework" has Rework Type = "RTA" , Count 1

       

      I am trying to do this with Set Analisys, but i am starting now to understand how it works.

       

      BR//Marcelo Fonseca