Graph View: Adding a custom trendline or regression line?

JfJf · October 22, 2012 7:00AM

Hi, It would be very nice for graphical analysis to add a trend line. This works very well for targets and range analysis. For example, in an scatter plot, being able to add an Horizontal line for a value in the Y Axis that would be overlayed in the visualization? This can be currently done but it requires going through the DataManager and is not as straightforward as it could be by just adding the option in the front end.

It would help a lot to understand patterns, and the more we could personalize that custom trendline, the best, if we could just put a formula, for example Y=5, that would create an horizontal line in the Y=5. Thank you, JfJf

tjbate · October 22, 2012 11:03AM

Juan - If you are using the Graph View to show your scatterplots, then all of these features are already there. On the Graph View View Toolbar, find the Stats dropdown menu and under Trends, choose Show line (of best fit). To add a horizonal reference or guideline that is keyed to the Y axis, choose Stats > Edit Y axis guidelines > {select Y axis field} Position = Custom and set the value for the guideline.

tjbate · October 22, 2012 11:15AM

If you are using the Bar/Line View to show multiple lines, you can also add a horizontal reference line. From the View Toolbar: Measures drop down, add a Formula measure. When the Formula Editor opens, define the formula as a constant by just entering the Y axis value for which you wish to add a reference line, e.g. ='25'. This will add a straight horizontal reference line Y=25 i.e. slope = zero and 25 as the Y axis intersect. If you use incorporated analytic scripts like R to estimate a reference line, e.g. line of best fit, you can also display this as a formula-driven reference line with a non-zero slope given the X-axis value and a constant Y axis intersect.

JfJf · October 22, 2012 11:49AM

Thank you Thomas, will try it right away!

Welcome!

Categories

Ideas Parade

Tagged