2 Replies Latest reply: May 23, 2013 9:24 AM by Rodrigo Giner RSS

    Problem with Set Analysis and Max

    Rodrigo Giner

      I have a problem, that cant solve.

       

      I have this table

       

      Ticket Count Date Status Side
      1000 1 Feb 2013 Open Me
      1000 2 Feb 2013 Question Client
      1000 3 Mar 2013 Process Me
      1001 1 Feb 2013 Open Me
      1001 2 Feb 2013 Question Client
      1002 1 Mar 2013 Open Me
      1002 2 Mar 2013 Question Client
      1002 3 Jul 2013 Process Me
      1003 1 Jul 2013 Open Me
      1003 2 Jul 2013 Process Me

       

      What I need is a Bar Chart with 2 columns (Me and Client)  discriminated by month/year. Where I have to show How many tickets do I have for each month, but only I have to Count the last status ( the Max Count field)

       

      So based on this example:

       

      Should be 4 in total, cause I have only 4 distinct tickets, 1 in "Client" on Feb 2013, 1 in "Me" on Mar 2013, and the last 2, 1 in "Me" and 1 in "Client" on Jul 2013

       

      I cant find the way to only show the last status for each ticket, It can be solved only with set analysis or I should have to use aggr ?

       

      I leave the example.

       

      Thx