What inspired this wish list request?
The inspiration for this request stems from a limitation encountered when trying to calculate the mode of string (categorical) data while simultaneously grouping it by another variable. Currently, the Col Mode() function, which is designed for grouped calculations, exclusively accepts numerical arguments. This means that if a user has a column of string data (e.g., product names, customer segments, error types) and needs to find the most frequent string within distinct groups (e.g., by region, date, or machine ID), Col Mode() cannot be used directly.
What is the improvement you would like to see?
The improvement I would like to see is for the Col Mode() function to be enhanced to accept string (text) columns as valid arguments for its main calculation. When a string column is provided, Col Mode() should perform the same grouping logic it currently uses for numerical data but apply the mode calculation appropriate for strings within each group.