Linear trend line in Graph for Time Series Data

[duncan]

Hey @pavanvlm

What part of the calculation are you having the most trouble recreating and what parts need to be dynamic? Specifically I’m not sure what you mean here:

@pavanvlm

there is no mechanism in quicksight to create a dynamic parameter value based on the calculation mentioned in the post

The workaround I see the most for this issue is creating the calculation in SQL before ingestion to QuickSight. Example:

How To Calculate A Linear Trend Line

Max, Thanks for the responses. I filtered the graph to start at beginning MonthNumberOfYear to start at 1, and increment by 1 naturally with filters, which should allow us to move forward with the functionality testing piece. I can look to make this more dynamic later, with possibly a Rank function or something. By Default, the Y-Axis on my line chart is based on the ‘Values’ I drag/drop into the field well, so I applied both of the Test measures and neither one is yielding a non-blank val…