BookmarkSubscribeRSS Feed
sc5
Calcite | Level 5 sc5
Calcite | Level 5

Hi, 

 

Is there a way I can access the coefficients of a linear fit through a scatter plot and use it in calculations displayed in a report?

 

E.g. I have 2 scatter plots, both controlled by a set of List controls. Every time I change the list selection, the data displayed and the fit lines on both plots change. 

 

sc5_0-1714399253799.png             sc5_1-1714399277066.png

 

 

is there any way to display a table with the difference between the calculated y-values from both fit lines at certain x-values?

This table would dynamically update every time the list control selection changes, and it would be displayed on the main report page.

 

Essentially, are the intercept, slope and R-square stored anywhere as objects I can reference? Like can I create a parameter as @chartobject.slope or something?

I can see them when I maximise the chart object, but I don't see a way to display them dynamically updating as part of the main report page.

 

sc5_2-1714399699286.png

 

In Excel this is easy with pivot tables. Slicers control charts connected to the pivot tables, and formulas =intercept(<y_col>,,x_col>), =slope(<y_col>,,x_col>) capture the trendline dynamically in cells anywhere I want. 

I don't want to have to export a regression / run code / refresh the report / etc., the aim is just to do some quick interactive analysis in the report as we slice data on-the-fly. 

Thank you!

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 0 replies
  • 83 views
  • 0 likes
  • 1 in conversation