2 Replies Latest reply: Jan 27, 2015 3:37 PM by Claus Barlose RSS

    Set analysis... or something else?

       

      I am bugged by the question of how to do this the easiest way, and I ask the community for help.

       

      The data record is very simple:

       

      Tickets:

       

      TicketID (Key)

      I-154356

      Created

      2014-12-31

      Title

      Thrusters defect

       

       

       

      Dataset consists of a number of rows with ticket details, each with a different creation date.

       

      Current selection is e.g. December 2014 and I want to show number of tickets created rolling month, twelve months back in time in a graph with year/month as the dimension.

       

      Will it be necessary to create another table to do it or can it be done with set analysis?

       

      Kind regards

       

      Claus