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.