You are viewing a public preview
Sign in to save your progress, do assignments, join discussions and get feedback.
Flashcards · Period 7
10 wordsCombining records into one value per group, such as the total net sales of each region.
For "how much in total?" use SUM. An average of individual sales answers a different question (typical size of one sale).
A value axis that starts at zero. Bars encode value by length, so a truncated axis exaggerates differences.
How a chart maps data to visual features such as bar length and position. Check that the encoded measure is the one you asked for.
Net_Sales_Amount records sales after discount. It contains no costs, so it cannot support claims about profit, margin or efficiency.
Measure, values, scale, labels and units, claims. A correct ranking never explains why regions differ.
A written description of a chart (data, type, axes, labels) that you can build in another tool. Use it when the chatbot cannot draw.
A pivot table or SUMIF formula that reproduces the grouped totals independently. State honestly which output came from the spreadsheet.
Improving readability (order, clutter, emphasis, labels) while keeping values, measure and baseline unchanged, then rechecking.
Brief, prompts, input version, verified table, charts, checks and revision notes saved together so a peer can reproduce the totals.