7 Replies Latest reply: Jul 18, 2014 3:40 PM by Claus Barlose RSS

    Set analysis expression

      Hi

       

      Hope anyone is able to help me with this set analysis question.

         

      I have a data record, consisting of:

      Ticket ID

      Creation date

      Resolve date

         

      - and want a bar chart to show year/mont, e.g. 2014/03, on x-axis and a stacked bar showing how many tickets created the specific month and how many that are resolved the same month.

       

      I might have selected January ’13 to January ’14 in my dataset, but off course wants to look at tickets created before selection, but resolved in selection period.

       

      Obviously it's the expression that kills me...

       

      Thanks to anyone that may help me!

         

      Best
      regards,

      Claus