Skip to main content
Newcomer
Apr 17, 2023 1:38 PM UTC

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

 

4 replies

Employee - Sage
Apr 18, 2023 8:24 AM UTC

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.

giutor73Author
Newcomer
Apr 18, 2023 12:05 PM UTC

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? 

Employee - Sage
Apr 18, 2023 12:53 PM UTC

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

giutor73Author
Newcomer
Apr 18, 2023 1:11 PM UTC

Thanks mate, I will.