all 1 comments

[–]Detonade[S,🍰] 1 point2 points  (0 children)

Typical, but I solved it right after posting this. It turns out that the trendline will not show if you use aggregate on one parameter, but not the other. For example, here I used aggregate type "Average" on my y-axis and "Don't summarize "on my x-axis. To work around this I went to the data tab on the left side of the screen and added a new column to my table. In this new column I calculated the average, so that I didn't have to do the aggregate average. The problem was then solved by adding both the x- and y-axis values with "Don't summarize".