9 Replies Latest reply on Sep 22, 2015 5:32 AM by Daniel Vincent

    Group rows based on two variables

    Iris Meerman

      I want to get amount of records for each affected service and -software combination

      The table now looks something like this:

       

      IDAffectedTitleNum of rec.

      1

      ServiceBackups1
      1SoftwareBacula1
      2ServiceBackups1
      2SoftwareBacula1
      3ServiceApplication1

       

      And I want this:

       

      Affected ServiceAffected softwareNum of Rec
      BackupsBacula2
      Application-1

       

      So I want to group the tickets which have the same affected service AND affected software, and that is the problem I can't fix (group on one of them is easy).

      I tried a lot with LOD expressions, but I not seem to be familiar enough with it to get it right.

       

      I'ld love to hear your ideas about this issue.