Forum Discussion
Maureen
Helper III
Helper IIIKeep a constant trend line when filtering
In this attached scatterplot, I have schools for the entire state with a trend line. I would like to filter to certain schools to see where they are in relation to that trend line but when I do, the...
JirkaZ
Solution Specialist
Solution SpecialistSure - you'll just have to ignore the filter using ALL in the calculation of the trend line.
The sytax will be something like:
Trend Line Value All := CALCULATE([Trend Line Measure], ALL('Schools'))
Obviously you may need to tweak the formula so that it matches your expectations.
MaureenHelper III
Helper IIIThank. I am not seeing an option to add a formula under the analytics tab for the scatterplot option . . .where could I add this formula to impose the line on the scatterplot . . . .