Comprehensive and Detailed Explanation From Exact Extract:
In Workday Prism Analytics, window functions are used to perform calculations across a set of rows, such as calculating averages with a function like AVG. According to the official Workday Prism Analytics study path documents, the AVG window function, which computes the average, must operate on a fieldof type Numeric. This is because averaging requires numerical values to perform arithmetic operations (e.g., summing the values and dividing by the count of rows). Non-numeric field types, such as Text or Date, cannot be averaged, and Boolean fields (true/false) are not suitable for this type of calculation. For example, a window function like AVG(salary) OVER (PARTITION BY department) would calculate the average salary per department, where "salary" must be a Numeric field.
The other options are incorrect:
A. Text: Text fields cannot be used for arithmetic operations like averaging.
B. Boolean: Boolean fields (true/false) are not suitable for calculating averages.
D. Date: Date fields cannot be directly averaged; they require conversion to a numeric representation (e.g., days since a reference date) first.
The requirement for a Numeric field type ensures that the AVG window function can perform the necessary mathematical computations accurately.
[References:, Workday Prism Analytics Study Path Documents, Section: Data Prep and Transformation, Topic: Window Functions and Field Type Requirements, Workday Prism Analytics Training Guide, Module: Data Prep and Transformation, Subtopic: Using AVG in Window Functions, ]
Submit