count max if

[Anonymous]

Hi Guys,

I have here a scenario which I only wanted to count the ID conversation with the last segment start time and with segment type as 'wrapup'.

since there is multiple id session for every id conversation. This is the desired result.

Thanks in advance!

[jonathandienst · Accepted solution]

In a table with ID:Conversation and ID:Session as dimensions, you could use this for the required result:

If(FirstSortedValue({<[Segment Type] = {'wrapup'}>} [ID:Session], -[Segment Start Time]) = [ID:Session], 1, 0)