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.