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

[HattrickNZ]

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  

[Damien_Dallimor]

Check out the new predict search command in Splunk 5.0

Here is a blog post about it also.