How to Implement linear regression line?

[saikumar1]

How to Implement linear regression line ?

[Brett]

Hi @saikumar1,

Take a look at this previous post; a user breaks down how it can be accomplished in Quick Sight:

Linear trend line in Graph

It’s a bit of work but for anyone who really wants linear regression calculations in Quick Sight here’s how it can be done: y = bx +a Where b = slope of the graph and a = y intercept. Using an example where x’s represent months from 1 to n, and the y values are Revenue: Create a calculated field for Slope (b): (COUNT(Revenue) * SUM(Revenue * Month)-SUM(Revenue) * SUM(Month))/(COUNT(Revenue) * SUM(Month^2)-(SUM(Month)^2)) and a calculated field for Y Intercept (a): AVERAGE(Revenue) - (Slop…

Additionally, you can explore the highcharts option; this addition provides users a much broader library of potential visual and visual options:

Using Highcharts - Amazon QuickSight

[Brett]

Hi @saikumar1,
Following up here as it’s been awhile since we last heard from you on this thread; did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you

[Brett]

Hi @saikumar1,

Since we have not heard back further, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.

Thank you!