Linear trend line in Graph for Time Series Data

Question & Answer
, ,
1

Hi All,

I have a line chart now available in Quicksight associated to a time series data. Is there any way I can add/show a linear trend line to the chart, either linear or exponential? If the Line Chart doesn’t support is there any other chart visual which support this feature? If trend lines are not yet supported in Quicksight what will be an alternative. WindowAvg function does not help in achieving a smooth line.

The data set is given below:
QuestionSample

The following community post talks about the calculation of y=bx+a but there is no way to calculate the b and a dynamically and programmatically. Linear trend line in Graph

1 Like
2

@pavanvlm ,

1/ Based on the previous example on calculating y=bx+a , are you able to get this calculation and does the trend value look correct ? > Once you can confirm this.
2/ What does calculating b and a dynamically mean > Can you add an example on the values you expect to see ?

Kind regards,
Koushik

1 Like