Splunk Search

How to use fit command together with foreach?

Wonjon
Observer

I would like to fit an ARIMA model to my data with a search something like this:

<base search>
| timechart span=5m avg(value) as value by some_field

The problem here is that, the number of field that returns by this search is dynamic, so it can return 5 fields one day but it could also return 3 or 7 the other day for instance.

I would like to fit an ARIMA model to all the fields that is returned by that search. What I found was the foreach command where you iterate over fields :

| foreach * [eval '<<FIELD>>' = ... ]

 

However, when I try to use the fit command instead of eval, I get an error message saying: 

Error in 'foreach' command: Search pipeline may not contain non-streaming commands

Since foreach cannot contain non-streaming commands.

 

Is there a way to come around this issue?

Labels (2)
0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...

Modernize your Splunk Apps – Introducing Python 3.13 in Splunk

We are excited to announce that the upcoming releases of Splunk Enterprise 10.2.x and Splunk Cloud Platform ...

Step into “Hunt the Insider: An Splunk ES Premier Mystery” to catch a cybercriminal ...

After a whole week of being on call, you fell asleep on your keyboard, and you hit a sequence of buttons that ...