Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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)
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)