How to improve the calculation of the max value on a line chart in the presence of fluctuations


I am trying to dynamically determine the "maximum" value of a column using a Calculated Value within a Text Area. However, the issue is that the value I am looking for is not the absolute maximum. Rather, I need to find the maximum of the curve formed by the Line Chart as indicated with the red arrow in the attached picture. I have been struggling with coming up with a way to accomplish this. Does anyone have any ideas, scripting or otherwise? 

Thank you




Image icon capture.png39.75 KB

(3) Answers