I've read through a lot of similar posts on here but can't find a good answer on how to plot a linear trend line in a scatter chart. E.g. with X as Sum(Sales) and Y as Count(Customer) and Store as the dimension.
I've used the linest_m and linest_b functions to create a linear trend in a bar/line chart but when it comes to a scatter i can't get it to work. For the Linest_m function I can add the Y values by creating an aggr() table but it doesn't seem to like it if I try the same for the X values.
Has anyone had any success with this (using the reference lines)?
@Michael_Tarallo - I've read your posts on using the linest functions in bar and line charts and they make sense. Any thoughts on how to use them in a scatter where X and Y are both aggregates?
The problem with a combo chart is that the only dimension is the X axis. No option to split points/markers out by another dimension like you can in a scatter.
I get where you're coming from in that in a combo chart I could use, for example, aggr(count(customers),store) to create the equivalent x axis of count(customers) in a scatter chart. The problem still remains of not being able to split out the markers though.