Trend line in a graph

[andreab]

Hi
i should show a trend line in a graph
I have this data from October 1st to December 10th
i tried to set a trendline with the following function

windowAvg(
sum({clicks_x}),
[{date check} ASC], 64.0,
)

but I don’t see a straight line (red line)

if i wanted to see a straight line of trend how could i do it?

Andrea

[sagmukhe]

Hello @andreab - Please see the following thread where similar query has been answered. Hope this helps!

Linear trend line in Graph

Hi All, I have a line chart now available in Quicksight. Is there any way I can add/show a linear trend line to the chart? 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. Does a WindowAvg function help in achieving a smooth line?

Did my suggestion help you in resolving your query? If yes, would request you to mark the post as “Solution”. This will help the community to find guidance and answers to similar question. Thank you!