Mode() returns the most commonly-occurring value, the mode value, of the aggregated data in the expression, as defined by a group by clause. The Mode() function can return numeric values as well as text values.
Return data type: dual
|expr||The expression or field containing the data to be measured.|
If more than one value is equally commonly occurring, NULL is returned.
Examples and results:
Add the example script to your document and run it. Then add, at least, the fields listed in the results column to a sheet in our document to see the result.
LOAD * inline [
] (delimiter is '|');
LOAD Customer, Mode(Product) as MyMostOftenSoldProduct Resident Temp Group By Customer;
|Result field (Customer)||Result value (MyMostOftenSoldProduct)|