An analyst adds a linear trend line to a sales-over-time line chart that contains one extreme outlier month caused by a one-off bulk order. They want the trend line to reflect the normal pattern without permanently deleting the outlier mark from the data source. Which action achieves this directly from the view?
- ARight-click the outlier mark and choose Exclude, which removes it from the view so the trend line recomputes without it Correct
- BEdit the trend line and tick the option to ignore the highest value, which Tableau applies before fitting
- CDelete the outlier row from the underlying data source so every worksheet using it is corrected at once
- DSwitch the trend model from linear to polynomial, which Tableau weights to suppress isolated outliers
Why A is correct: Excluding a mark drops it from the current view only, leaving the data source intact, and Tableau immediately refits the trend line on the remaining marks so the line reflects the normal pattern.
Why B is wrong: The trend line editor has no ignore-the-highest-value setting; fitting options cover model type and factors, not single-point exclusion. It sounds plausible because excluding the outlier is the goal, but this control does not exist.
Why C is wrong: Editing the data source contradicts the requirement to keep the outlier in the data, and it affects every view rather than just this one. The scenario explicitly rules out permanent deletion.
Why D is wrong: A polynomial model changes the curve shape but does not down-weight outliers; a single extreme point can distort a polynomial fit just as much. Changing model type does not remove the outlier's influence.