Accessing regression line equation

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?

Comments

  • GrantSmith
    GrantSmith Indiana 🔴

    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
    jaeW_at_Onyx Budapest / Portland, OR 🟤

    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
    jaeW_at_Onyx Budapest / Portland, OR 🟤

    @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.

This discussion has been closed.