Now, based on your business requirement a new function can be added in the aggregate function list like median, mode etc. In this case you have to manually add a new function in the list. For that, open the sqlQuery.properties file then add the new function in the list.File Path : C:\Users\hi\hi-repository\System\Admin\sqlQuery.properties
sqlQuery.properties file details
Note: File path may vary based on the installation directory.
Note: The aggregate function which is to be added should be supported by database. If it is not supported by database then the function becomes inaccessible, even though it is defined in sqlQuery.properties file. Now, you can use the new function present in aggregate function list in adhoc.
For more Info, contact us at email@example.com