Does the Group By stage return both aggregated and detailed data?

The Group By stage in Workday Prism Analytics is designed to summarize data based on specified groupings, which primarily leads to the generation of aggregated data. When you apply a Group By operation, the output focuses on summarizing datasets by defined dimensions, producing metrics such as sums, averages, counts, or other forms of aggregation.

In contrast, detailed data is retained until the grouping is applied; however, the main output of a Group By operation is the aggregated results, which means the detailed entries are not typically included in the final dataset shown after this operation. Therefore, stating that the Group By stage returns both aggregated and detailed data isn't accurate, as the emphasis is clearly on aggregation. The nature of how Group By works is to take a collection of records and distill them into summarized forms based on the grouping criteria specified, which is why the answer is that it does not return both types of data.