Accessing regression line equation

user060355

I was able to add a regression line to my bar chart, however I cannot seem to access the equation for the line.  It's a simple task in excel so I figured DOMO should be able to do this without a problem.  What am I missing / How do I access it?

GrantSmith

Hi @user060355 

Currently Domo doesn't export the exact equation for the regression line. You could utilize an online regression calculator to calculate it possibly.

jaeW_at_Onyx

http://www.silota.com/docs/recipes/sql-linear-regression.html

 

@GrantSmith  lol i'm half tempted to try to calculate this in a dataset view (which actually shouldn't be difficult) and then calculate the X and Y points as calculated fields in the DSV.  

 

Might have to build a view on a view...

 

but then you could plot it as a series.

jaeW_at_Onyx

@user060355 ... be advised though... while showing the regression line in analyzer is interesting, it is very much dependent on the data that you see in your card.  which of course implies, as soon as you add filters or interact w/ the card to apply filter, a new regression line will be calculated.  

 

it may make sense to calculate the regression line in the dataset so it isn't impacted by applying filters to your data but that's up to you and your use case.