I need show count of incident by month and last phase for this month and incident.
Please, I attach a little example of this problem (because I try some aggr and not found the solution) to help me.
On this example, I want obtain on YearMonth = 201910 the values phase = 3 then 1 and phase = 4 then 1, but obtain other values (first phase by Incident and YearMonth, phase 2 and phase 3, I want last phase). Rest of months are ok in this example.
