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