I'm using the transaction command to correlate some searches, no I don't want to use stats, and its all split how I want but I've discovered what I thought was an individual id is in fact not but its still splitting correctly. Now I'm trying to figure out the avg duration per transacted event but what I was going to split it by is not individual to the transacted event. Does the transaction command produce a eventID per transacted event? Or will I need to make my own field for this?
You are experiencing why I tell everybody: DO NOT USE transaction
. It does not scale and will fail silently and return partial events without telling you so. It is a nightmare. Start over and let us show you how to do it right with stats
. Or ignore this warning and spin your wheels forever.
You have to make your own id/field for your requirement. transaction command takes your inputs and groups the events.
It only creates new fields like duration, closed_txn eventcount, evicted, linecount, timestartpos, timeendpos etc but not an identifier which you are after.
The transaction command creates two fields according to the documentation:
Additionally, the transaction command adds two fields to the raw events, duration and eventcount. The values in the
duration
field show the difference between the timestamps for the first and last events in the transaction. The values in theeventcount
field show the number of events in the transaction.
It sounds like all you need for your purpose is theduration
field that is created. If not, please post additional information such as the sample data you are seeing versus the sample data you would like to be generated.