From: Priya Raman, head of finance, Copperleaf Home Services (fictional)
The November sales report didn't refresh this morning, and the board pack goes out at noon. I need to know which customer segment brought in the most in November.
The data: Sales is November's export from the order system; Customers is the CRM export with each customer's segment. The order system was upgraded last week.
Done looks like: the Report query refreshes again, keeps every order (an unpriced order counts as unknown, not zero), brings in each customer's segment, and ends with the one segment that has the highest total. Fix one problem at a time. All names and amounts are fictional practice data.
Work through the failure the way you would at work: open the query, read the error, fix the smallest thing, and check the preview before moving on. Each step builds on your query from the step before.
The upgrade changed three things about the export. Find them as the errors and the empty values show up, rather than guessing them all at once. The last step returns the answer as a one-row table.
The first error names a column the export no longer has.