Question

You are building a Dataflow Gen2 transformation in the Visual Query Editor to prepare a customer analytics table. The source table contains one row per order and includes a CustomerID column. You need to produce an output that has exactly one row per CustomerID, keeping the most recent OrderDate for each customer and the total number of orders they placed. Which sequence of Visual Query Editor operations produces this result?

Accepted Answer

Group by CustomerID, then add aggregations for Max of OrderDate and Count of rows

Answer

Remove duplicates on CustomerID, then add a custom column counting rows

Answer

Sort by OrderDate descending, then Remove duplicates on CustomerID

Answer

Filter rows to the maximum OrderDate, then Group by CustomerID