OK, we figured out the exact syntax: our datamodel has an object named "Package", which has such extracted fields as "length", "width", "height" and a calculated "tot_dim" which is a sum of the three dimensions. It also has a "token" field, which for some reason is not extracted properly, so I tested the GROUPBY syntax on some other field.
All in all, it looks like this:
| tstats count first(Package.tot_dim) AS tot_dim1 last(Package.tot_dim) AS tot_dim2
from datamodel=Our_Datamodel
where index=our_index
by Package.token
| search count=2
Shall we agree that some of Splunks intricacies are somewhat underdocumented? 🙂
Oh, and we are still in 6.6.2 - though I doubt it changes much in the latest version.
... View more