Trendlines for scatter plots was "coming soon" in Spring 2022. Did it? When it gets added, can I recommend that the trendline could be written manually or the function edited?
The reason for my suggestion here is that sometimes that same line may be used to represent "Target" rather than "Trend". There may also be other complex scenarios where you want to manage it quite strictly.
For example, I have a use case where I want to show price stability over time;
1 bubble per sale
X Axis is [Billing Date]
Y Axis is [Gross Invoice Value] / [Net Weight] (I could do this in the load script)
Size of the bubble is Log([Net Weight])
My Trendline should just be a total Sum([Gross Invoice Value]) / sum([Net Weight])
I can even write it as a very simple formula, but it seems there's still no easy way to add that formula in to the a bubble chart as a line?
