If I want to add up all numbers I have in the nr_external_recipients field for a particular event type, is this the best way of doing it?
action=email_confirmed | table nr_external_recipients | addcoltotals nr_external_recipients | stats max(nr_external_recipients)
Example event of the type that I want to add up are (this example should show 5):
"action=email_confirmed nr_external_recipients=2"
"action=email_confirmed nr_external_recipients=3"
If you want the total as a seperate line/event addcoltotals
is your best option. If you're only looking for the total, then you can do stats sum(nr_external_recipients) as total