I think I may have figured it out myself, just had to take a step away for a minute. Pasting what I got here in case this comes up in a Google search and someone else needs help. index=sfdc sourcety...
See more...
I think I may have figured it out myself, just had to take a step away for a minute. Pasting what I got here in case this comes up in a Google search and someone else needs help. index=sfdc sourcetype=sfdc:conversationentry EntryType IN ("ChatbotEstablished", "BotEscalated") | stats count(eval(if(EntryType="ChatbotEstablished",1,null()))) as ChatCount count(eval(if(EntryType="BotEscalated",1,null()))) as EscalationCount by ConversationId | stats sum(ChatCount) as sumChat sum(EscalationCount) as sumEscalation | eval pctEscalation=round(((sumEscalation/sumChat)*100),2) | table sumChat, sumEscalation, pctEscalation