topic Re: Calculation of area of a graph in Archive
https://community.splunk.com/t5/Archive/Calculation-of-area-of-a-graph/m-p/39782#M4958
<P>thank you for that. <BR />
Do you think it is more exactly with your idea instead of calculate the area? </P>
<P>Thanks</P>Tue, 20 Nov 2012 13:33:35 GMTnebel2012-11-20T13:33:35ZCalculation of area of a graph
https://community.splunk.com/t5/Archive/Calculation-of-area-of-a-graph/m-p/39780#M4956
<P>Hi there,</P>
<P>today I have a special question. I am not sure how to realise this.<BR />
I have on the one hand a lot of performance values, like 20, 13, 15. On the other hand I have the time stamps for those performance values. It mean, I can create easily a graph. No I am adding a extra line, called recommendation of 10.</P>
<P>Now we have a graph and a line which is the treshold line. </P>
<P>The idea is now, to calculate the area which is higher than the recommodation. I already found the mathematic phrase but I think there is maybe another way to realise this. With a mathematic phare it is so complex...</P>
<P>Could you please advise me how I can realise this? Any kind of ideas are more than welcome.</P>
<P>Thank you very much in advance</P>
<P>Regards</P>Tue, 20 Nov 2012 09:01:49 GMThttps://community.splunk.com/t5/Archive/Calculation-of-area-of-a-graph/m-p/39780#M4956nebel2012-11-20T09:01:49ZRe: Calculation of area of a graph
https://community.splunk.com/t5/Archive/Calculation-of-area-of-a-graph/m-p/39781#M4957
<P>Calculating area under a curve normally requires calculus and integration to properly calculate. However, you can try and approximate it. What I would do, since you have each of the values of the area points, you can take the points with values higher than your threshold, subtract the threshold value (to get the value above the line) and sum them over the _time of your graph. A search may go something like this.</P>
<P><CODE>your_search|eval threshold = 10|where perf_value > threshold|eval diff_threshold = perf_value - threshold|stats sum(diff_threshold) as "Total 'Area' Above the Line"</CODE></P>Tue, 20 Nov 2012 11:18:18 GMThttps://community.splunk.com/t5/Archive/Calculation-of-area-of-a-graph/m-p/39781#M4957alacercogitatus2012-11-20T11:18:18ZRe: Calculation of area of a graph
https://community.splunk.com/t5/Archive/Calculation-of-area-of-a-graph/m-p/39782#M4958
<P>thank you for that. <BR />
Do you think it is more exactly with your idea instead of calculate the area? </P>
<P>Thanks</P>Tue, 20 Nov 2012 13:33:35 GMThttps://community.splunk.com/t5/Archive/Calculation-of-area-of-a-graph/m-p/39782#M4958nebel2012-11-20T13:33:35Z