Collapse columns based on value

user09188

I have a set of Call data where each row contains similar information in all columns but creates a new row based on the "flow" of the call.

 

For example:

 

 

LinkedId	Leg	LegType	MenuName	MenuOption	Initial Queue Name
bos-z15-call3-1550235827.1062618	leg 1	Dial			curc-iready-q
bos-z15-call3-1550235827.1062618	leg 2	Answer			curc-iready-q
bos-z15-call3-1550235827.1062618	leg 3	EnterIVR	curc-auto-main-update		curc-iready-q
bos-z15-call3-1550235827.1062618	leg 4	EnterIVR	curc-auto-main-update_Special Event		curc-iready-q
bos-z15-call3-1550235827.1062618	leg 5	EnterIVR	curc_65950	2	curc-iready-q
bos-z15-call3-1550235827.1062618	leg 6	EnterIVR	curc-tech-support-update		curc-iready-q
bos-z15-call3-1550235827.1062618	leg 7	EnterIVR	curc-tech-support-update_Day		curc-iready-q
bos-z15-call3-1550235827.1062618	leg 8	EnterIVR	curc_66674	2	curc-iready-q
bos-z15-call3-1550235827.1062618	leg 9	EnterIVR	curc_32386		curc-iready-q
bos-z15-call3-1550235827.1062618	leg 10	EnterQueue			curc-iready-q
bos-z15-call3-1550235827.1062618	leg 11	Answer			curc-iready-q
bos-z15-call3-1550235827.1062618	leg 12	Hangup			curc-iready-q
bos-z15-call3-1550235827.1062618	leg 13	Hangup			curc-iready-q

 

I'm trying to determine which calls are abandond from the information. The flow can change depending on the call but I want to seperate out each call that goes to voicemail (a specific LegType) and which calls Hangup without being answered. 

 

The number of Legs can vary. But if they have a status of EnterQueue, I want to call out the ones that go to Voicemail, and ones that hangup after. Any other call will count as answered. In doing so I want to collapse the data and add an extra column that just says "Disposition" and have a value of answered, Voicemail, Or Abandoned.

 

Any assistance would be appreiated.

Unknown

You should be able to do a beastmode (calculated field)
http://knowledge.domo.com?cid=beastmodecalculation

You would want to do a case statement something like

CASE

when `Leg` = 'leg 3' then 'Voicemail'
When `Leg` = 'leg12' then 'Hung up'
Else 'Answered'
End

 

If you do this it should give you the three groups based on those categories. Then you can do a drill path to a card that has the details of each section.