5 Replies Latest reply: Jun 29, 2016 11:48 AM by Rickard Andersson RSS

    Get last or first occurrence of data only?

    Rickard Andersson

      Hi, I am doing analysis of data that is basically a daily download containing a snapshot with all open cases from a ticket-system.

       

      I some cases I am interested in only the first occurrence of that ticket (or the last) - ie. to do graphs on new tickets created (date) any ideas on how I could do that?

       

      also. any idea how to find out trend on tickets being closed (that would mean identifying rows that "disappeared" in today's loading compared to yesterday's loading.