1 Reply Latest reply on Nov 16, 2018 5:05 AM by Norbert Maijoor

    Count mismatch when compared to actual data

    Vijay Kumar

      Hi,

       

      I am having a chart like below for "Number of tickets Opened" and "Number of tickets closed". This chart is created based on the SQL model .of Opened and Closed event. Sample given below.. When I actually count Distinct Ticket ID I am getting the correct ticket count. But when I count the number of rows of "Opened" I am getting more tickets like 6+, etc., than the actual. I dont know what is causing the issue.

       

      Select

      Ticket ID,

      Created Date,

      Created Date as Month,

      Resolved Date,

      'Opened'

      From Table A

       

      Select

      Ticket ID,

      Created Date,

      Resolved Date,

      Resolved Date as Month,

      'Closed'

      From Table A