You can create your own custom functions, that can be used when adding a calculated field.

The function will be available when creating a calculated field and using the 'Pre-defined formula':






In order to add your own custom function, you will need to add the query to the 'custom-functions.xml' located within YellowfinappserverwebappsROOTWEB-INF.

Note: This needs to be placed under and not above.

Example :
[code]


Median

1
Column
numeric



MEDIAN($1)


$1


Oracle
numeric

[/code]

For additional information please see the Yellowfin wiki