The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

giutor73's avatar
giutor73
New Contributor III
3 years ago

Regression line in BI Viewer

Hello folks,

I'm trying to add a regression line on a scattered chart in Bi Viewer. I'm trying to use Calculated fields but when I arrive to the point of calculating the y in the equation I get an error as a "summary expression" is expected:

[intercept] + [slope] * [V4]

If I surround V4 with Max or Min it's accepted but no line is plotted on the chart. 

Does anyone have a clue if it's possible to add a regression line on a chart?

Many thanks

 

BI Viewer

4 Replies

  • JackLacava's avatar
    JackLacava
    Icon for OneStream Employee rankOneStream Employee
    3 years ago

    That depends on how you're producing those calculated fields... Maybe have a look at BI_Viewer_Design_and_Reference_Guide.pdf in the documentation package, it contains a section on Aggregations that should show you how to deal with that sort of situation.

  • giutor73's avatar
    giutor73
    New Contributor III
    3 years ago

    Thanks for the reply but sadly didn't help, it gave another error. May I suggest to add the option to plot the regression line straight from the BI Viewer as it happens with Excel and PowerBI in the future OS version? 

    • JackLacava's avatar
      JackLacava
      Icon for OneStream Employee rankOneStream Employee
      3 years ago

      Post it on IdeaStream and ask people to vote it up! Devs take all those ideas in consideration.