3 Replies Latest reply: Nov 8, 2013 5:49 AM by Vannick TRINQUIER RSS

    Chart with difference between week N and week N - 1

      Hi all,

       

      I would like to ask some questions about Qlickview. I am still new into this product and I have just to work with the set analysis.

      I have a table that contains all the ticket with:

      • Date
      • Ticket Id
      • State that can be new, open or closed to make it simple

       

      Here is the table:

      • Day 1: Ticket ID 1, OPEN
      • Day 2: Ticket ID 1, OPEN
      • Day 2: Ticket ID 2, OPEN
      • Day 3: Ticket ID 1, OPEN
      • Day 3: Ticket ID 2, OPEN
      • Day 3: Ticket ID 3, OPEN
      • Day 3: Ticket ID 4, OPEN
      • Day 4: Ticket ID 1, OPEN
      • Day 4: Ticket ID 2, OPEN
      • Day 4: Ticket ID 3, OPEN
      • Day 4: Ticket ID 4, OPEN
      • Day 4: Ticket ID 5, OPEN
      • Day 4: Ticket ID 6, OPEN
      • Day 4: Ticket ID 7, OPEN

       

      I am already able to get a chart with the number of ticket opened by day doing a count on all the ticket for a date and filtering on the status. For instance:

      • Day 1: 1 tickets opened
      • Day 2: 2 tickets opened
      • Day 3: 4 tickets opened
      • Day 4: 7 tickets opened

       

      I would like to have a chart that give the evolution of the ticket created by day like:

      evolution = count (ticket(day(n))) - count (ticket(day(n-1))))

      For instance:

      • Day 1: 0 tickets
      • Day 2: 1 tickets created ( 2 - 1 = 1)
      • Day 3: 2 tickets created (4 - 2 = 2)
      • Day 4: 3 ticket created (7 - 4 = 3)

       

      Is anyone could provide me any information. If I need to use the set analysis to be able to do that or if it possible only with expression ? How can I compare the count of the current with the previous day

      I know qlickiew since only few days and I do not find information on that.

       

      Thank you very much for any help

       

      Nalysa