Splunk Search

How do I predict the monthly data using predict command in splunk?

saranravi
New Member

Sample Data;
Month Year X1
5 2015 220
6 2015 210

7 2015 225

Output

Predicted results:

Month year x1
8 2015 220
9 2015 223.4

I have three years of data. any suggestion would be helpful.

Tags (1)
0 Karma

Sukisen1981
Champion

Hi,
I am assuming you had a look at the predict command documentation - https://docs.splunk.com/Documentation/Splunk/7.1.1/SearchReference/Predict

Now, you need to try the various algorithm options as mentioned in the table. If your data is seasonal / periodic etc. , your algorithm option should be based on that. I suggest starting with LLP5 and LLP first.
2 key points to remember
1-Please specify a holdback period, this will allow you to see how accurate your predictions are. from the document above - holdback
Syntax: holdback=
Description: Specifies the number of data points from the end that are not to be used by the predict command. Use in conjunction with the future_timespan argument. For example, 'holdback=10 future_timespan=10' computes the predicted values for the last 10 values in the data set. You can then judge how accurate the predictions are by checking whether the actual data point values fall into the predicted confidence intervals.
Default: 0
2-Remember , your data must have some underlying pattern for a algorithm to be successful. Try out the algorithm options with holdback and one of them should fit your use case,

0 Karma
Get Updates on the Splunk Community!

Application management with Targeted Application Install for Victoria Experience

  Experience a new era of flexibility in managing your Splunk Cloud Platform apps! With Targeted Application ...

Index This | What goes up and never comes down?

January 2026 Edition  Hayyy Splunk Education Enthusiasts and the Eternally Curious!   We’re back with this ...

Splunkers, Pack Your Bags: Why Cisco Live EMEA is Your Next Big Destination

The Power of Two: Splunk + Cisco at "Ludicrous Scale"   You know Splunk. You know Cisco. But have you seen ...