Build core chart types from scratch - bar, line, pie, scatter, histogram, tree map, box plot, dual axis, and combo - and sort data including custom sorts.

A quality analyst is building a box plot to compare defect counts across four assembly lines. The analyst has Line on Columns and SUM(Defects) on Rows, then drops a box plot from the Analytics pane, but the chart draws a single box per line with no spread because each line shows one aggregated total rather than the individual readings. What change lets the box plot display the true distribution of readings within each line?

• AAdd the individual reading identifier to Detail on the Marks card so each line shows one mark per reading for the box to summarise.check_circle Correct
• BChange SUM(Defects) to AVG(Defects) so the box plot summarises the average reading per line.
• CTurn on stacked marks so the single value per line is broken into segments the box can span.
• DSort each line by descending defect count so the box plot can rank the readings into quartiles.

Why A is correct: Disaggregating to one mark per reading via Detail gives the box plot the underlying points it needs to compute quartiles and whiskers, restoring the spread within each line.

Why B is wrong: Swapping the aggregation still collapses each line to one value, so the box plot would again have a single point per line and no distribution to draw.

Why C is wrong: Stacking changes how marks are layered but does not create multiple underlying readings per line, so the box plot still has nothing to spread across.

Why D is wrong: Sorting only reorders categories and cannot conjure individual readings out of one aggregated total, so the box would remain a single point.