Hi Wonder if any of the community can help me.
I'm trying to create an average of some data, and running into problems.
My data looks like this
Fieldname is Animals
Event 1 - "Dog","Cat","Horse","Rabbit","Zebra"
Event 2 - "Zebra","Horse","Cat","Rabbit","Dog"
I'm trying to create an average for each element (i.e each animal) in the event, based on it's position.
So -
Dog = position 1 and 5
Cat = position 2 and 3
Horse = position 3 and 2
etc
what I want out the back of this, is a table that looks like the following
Animal Avg
Dog 3
Cat 2.5
Horse 2.5
Rabbit 4
Zebra 2.5
Many Thanks for any help.
index=win |head 2| eval animals="Dog,Dog,Dog,Cat,Horse,Rabbit,Zebra"|eval animals= split(animals,",") |eval eventno=1 |accum eventno |mvexpand animals |streamstats count by eventno |stats avg(count) by animals
index=win |head 2| eval animals="Dog,Dog,Dog,Cat,Horse,Rabbit,Zebra"|eval animals= split(animals,",") |eval eventno=1 |accum eventno |mvexpand animals |streamstats count by eventno |stats avg(count) by animals
the index=win|head 2|
was just for testing purposes but I get the idea right?
Thats got it!
Thanks - Really appreciate that.