Show count last value by dimension graph

[daniel_martin_a]

Hi to all.

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.

Please, can you help me.

Thanks.

Regards.

[daniel_martin_a · Accepted solution]

I answer me.

=count(
AGGR(
if(MaxString(TOTAL <ID,YearMonth>
Aggr(MaxString( ID & '%' & Phase),ID,YearMonth)) =
ID & '%' & Phase,
ID) ,
ID,YearMonth,Phase)
)

Thanks.