Regression line in BI Viewer

giutor73
New Contributor III

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

 

4 REPLIES 4

JackLacava
Honored Contributor

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
New Contributor III

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
Honored Contributor

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

giutor73
New Contributor III

Thanks mate, I will.