Splunk Search

How do I do a chart in splunk whereby I can forecast into the future?

HattrickNZ
Motivator

Hi there appreciate any help here. Coming from an excel perspective and trying to implement some graph I have in excel in splunk as I can see the value of splunk.
Appreciate any help!!

2 Examples graph 1 & 2 based on the below data

Graph1(#) has 8 known values (lets say Jan to Aug) and 4 unknown values(Sept to Dec). In this instance I have just used a forecast formula in excel to get the values for Sept to Dec and this would be shown in the graph.

Graph2(#2) is the same but I would use a pivot chart in excel and add a trend line to forecast into the future

Date    Device  #   limit   #2
1/01/2012   A   1   10  1
1/02/2012   A   2   10  2
1/03/2012   A   3   10  3
1/04/2012   A   4   10  4
1/05/2012   A   5   10  5
1/06/2012   A   6   10  6
1/07/2012   A   7   10  7
1/08/2012   A   8   10  8
1/09/2012   A   9   10  
1/10/2012   A   10  10  
1/11/2012   A   11  10  
1/12/2012   A   12  10  
Tags (1)
0 Karma

Damien_Dallimor
Ultra Champion

Check out the new predict search command in Splunk 5.0

Here is a blog post about it also.

0 Karma
Get Updates on the Splunk Community!

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...