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
Check out the new predict search command in Splunk 5.0
Here is a blog post about it also.