This guide will teach you how to create your own advanced functions and use them in reports.
Advanced functions allow you to perform operations on top of report data after the primary SQL query has been run, unlike a calculated field, which is added to the report’s SQL statement. Functions can range from simple mathematical calculations and text manipulation, to more complex API calls with user input parameters.
This guide is broken into the following sections:
Basics: The basic process of creating a custom advanced function for Yellowfin reports. Start here if you are new to coding Yellowfin plug-ins.
Advanced function creation: The core methods required to code the function.
Parameter set up: Provide user input parameters such as radio buttons and drop down menus.
Dependent parameter display: Create dynamic interfaces by expanding upon the basic user input parameters.
Data access and modification: Use values from other columns, then return a customized result set.
For further reference, see the advanced function appendix.