Hi
I have three communication types: Start, Update, Restore.
Each event can have multiple communication types to multiple prems.
I am trying to declare success if the number of "restore" messages sent is equal or greater than the number of "start" messages.
Event 486 would be a success and 393, 404 and 406 would fail.
EVENT_ID type prem
393 restore 434
393 start 474
404 restore 21
406 start 10
406 restore 19
486 restore 1
486 start 1
<<| transaction source, EVENT_ID
| rex "^(?[^,]+),(?[^,]+),(?<code>[^,]+),(?[^,]+),(?[^,\r\n]*)"
| rex field=source "(?[^-]*)_18"
| rex "premisecount:\s(?\d+)"
| rex field=source "(?[^_]*).csv"
| stats count sum(premisecount) by EVENT_ID,type | rename "sum(premisecount)" as prem ]
|table ,EVENT_ID, type, prem>>
</code>
You need to create a eval function for this
| rex "^(?[^,]+),(?[^,]+),(?[^,]+),(?[^,]+),(?[^,\r\n])" | rex field=source "(?[^-])18" | rex "premisecount:\s(?\d+)" | rex field=source "(?[^]*).csv" | stats count sum(premisecount) as Prem by EVENT_ID,type | eval Success = if (restore >= start , 1,0) |table ,EVENT_ID, type, Success
@SathyaNarayanan thank you for the response. The recommendation returns all zeros. I think this is because the count is by prem, not type. How can one tie the two together? The recommendation is exactly what is trying to be accomplished to count the successes and failures.
Thank you
sorry 406 would be a success