I am trying to get counts based on comma delimited values for specified groupings of events. For instance I have the following logs. Event=A Ids="55,32,5"
Event=A Ids="55"
Event=B Ids="56,63"
Event=C Ids="23,53,12"
Event=C Ids="39,6" I want the data to show up in a table like the following Event A&B Event C 6 5 How would I craft the query to get it to aggregate it like this? Note: This would be happening for a large number of events.
... View more