I'm making a timechart, returning a unknown number of columns.
So I don't know how there named. I make appendcol, to add avg information, so I have :
field1 field1_avg field2 field2_avg ... fieldN fieldN_avg
08:00 2 3 2 2 4 5
I would like to eval a fieldxdelta=field-fieldavg
How could I achieved this ?
split it by consecutive spaces, get the total number then sum all of them divided by the total number. Note: Don't count the last field just count the spaces and add two to the total number. this will assume that time in the field1 is as of other fields so 1 in 3.
If your first fields contains other then time then considered to be the sum. In that case you will have 2 sum one for field1 and one for all other fields the equation will be
parity(sum+sum/2*(Total Number of Spaces + 2) +- 1) this will include 0 instead of all and the equation will not be thrown by null but by +1 or -1. This is not very fundamental it's just an equation where null could be the solution of your problem, don't be very optimistic if the solution is 1 or greater then it will be the sum. 1=sum , if your first field is 1 as other then you will not receive null as solution. In this case null doesn't exist my dear.
I've no spaces, the table above is an example, thats the results I get from splunk :
index=summarykihub source="summarycus5vdvdfimsgbusiness" earliest=-1h@h Splattform=ikihub | timechart span=1m c(SFahrtID.FahrtBezeichner) by Spartner | rename * as *avg, _time as _time | appendcols [search index=summarykihub source="summarycus5vdvdfimsgbusiness" earliest=-2h@h Splattform=ikihub | timechart span=1m c(SFahrtID.FahrtBezeichner) by S_partner]
So I think we are not speeking about the same thing , are we ?