Try Yellowfin
Explore Yellowfin now with our sample dataset
Get StartedYellowfin Named a Visionary for Third Consecutive Year in 2022 Gartner Magic Quadrant for Analytics & BI Platforms. Read more
Yellowfin Scores Top 3 in Augmented Analytics Use Case in 2022 Gartner Critical Capabilities for Analytics & BI Platforms. Read More
See what’s new in Yellowfin 9.7
Yellowfin Named a Value Index Leader in the 2021 Value Index for Analytics and Data. Read more
Yellowfin Interactive Dashboard Gallery – See the world’s most beautiful dashboards in action. Explore
Yellowfin supports extensions in several areas:
Extensions can be implemented as Plugins that can be loaded dynamically via Yellowfin’s Plugin Manager.
Yellowfin has no proprietary languages. Yellowfin Code-Mode utilises html, JavaScript and CSS.
Yellowfin code extensions can be coded in the Java programming language.
Yellowfin supports extensions in several areas:
Extensions can be implemented as Plugins that can be loaded dynamically via Yellowfin’s Plugin Manager.
Yellowfin has no proprietary languages. Yellowfin Code-Mode utilises HTML, JavaScript and CSS. Yellowfin code extensions can be coded in the Java programming language.
Yellowfin ships with a Signal List and Custom HTML widgets out of the box. More widgets will be added to the product in the future. The Signal List widget will show a stylized list of your signals, this widget allows you to configure the signals shown by using a series of filters. You can filter on time period, Analysis job, Signal type and View. The Custom HTML widget allows you to add in your own custom HTML code and allows you to visualise your HTML in design mode and manage attributes such as size, location, background formatting and others.
Custom UI elements such as buttons, selection menus, or input forms can be introduced in the dashboard’s code-mode and are most often contained in the context of an HTML widget. However, there are several use cases where it may be advantageous to create a custom widget instead:
Custom widgets can do anything from applying filters to making workflow enabling API calls, based on user interaction with the dashboard. Custom widgets have access to both the client-side rendering layer of the dashboard and the backend of the Yellowfin application. Having the ability to change client-side rendering allows you to alter the user experience within the dashboard, from simple responsive color and text changes to interacting with the reports contained on the canvas (driving filters).
Access to the backend allows you to create complex actions upon the front end processes, such as writing back to a database or making authenticated API calls to other applications.
Custom widgets are coded outside of the application using a combination of Java (required for basic widget definitions), as well as the JavaScript, HTML and CSS that would be available in standard code mode. This project is compiled as a jar file and uploaded through the Yellowfin plugin manager.
Yes, once built, widgets can be imported into any Yellowfin 9 instance via the plugin manager.
Yellowfin provides several alternative means by which to navigate users through the various dashboards and reports that make up their day to day analysis experience.
Action buttons – Yellowfin provides built-in “action” buttons that provide a list of pre-built actions for users to choose from.
This can also be done manually in the dashboard’s code mode, or at a global level by using a custom header or URL redirection.
In addition to the out of the box charts, Yellowfin provides, we also provide the ability to build your own utilizing your favorite JavaScript charting libraries such as d3, hicharts, and threejs with a feature called “JavaScript charts”.
c3.js, chart.js, Google Charts and Highcharts
Javascript charts are created in the same core interface as standard charts, however, rather than providing a drag and drop interface, we provide an in-tool IDE, and expose the reports resultset as a JSON object, along with other contextual information relating to the chart such as the default color palette.
JavaScript Charts are disabled by default and can be enabled on a user by user basis with “Role Permissions”.
Further Reading:
Read about integrating JS charts.
Although Yellowfin comes with a very wide variety of chart choices that satisfy the analytical needs of most users there will be cases where a completely bespoke visualization is required – such as a 3d interactive human body showing injury sites. In such cases, you can extend Yellowfin with your own custom charts.
Custom data transformation steps can be coded in your IDE using java and imported into your Yellowfin instance using the plugin manager. Once imported, the steps appear in the step menu when building data transformation flows. This is described in detail here.
You can build a transformation step to do literally anything. This could include custom formatting of the incoming data, through to invoking a third-party API to enhance data with information from another application, for example calling a geo-coding service, adding weather information to location data, through to calling a predictive model hosted on a Machine Learning Platform.
As ETL processes can be highly specific to the individual business’s needs, Yellowfin provides an API to allow you to add your own custom transformation steps to the Data Transformation tool. These steps can serve a variety of purposes and be applied at all stages of the flow.
Custom data transformation steps are coded in Java, packaged as a jar file, and uploaded through the Yellowfin plugin manager. Once loaded into the application, the step becomes available to all transformation flows.
Read a full explanation of how to code these.
Data converters allow you to alter the field type after the primary report query has been run. The field type can be quite important in Yellowfin post-processing, as certain charts and advanced functions require data in specific formats. One example of this in action is the WKT converter in the Yellowfin view, that converts a string such as POINT(lat, long) to a geographic data type, allowing Yellowfin to leverage that field in the GIS map.
Read a full explanation of how to code these.
String->Geometry, String->Date, String-Numeric, Numeric->text, numeric->date, date->text, date(System Timezone)<->date(Local User Timezone)
The Data connector API provides an interface to connect to and report on data stored in external APIs, such as Jira, Google Analytics, and Salesforce.
Custom data connectors can be employed in one of two ways:
Read a full explanation of how to code these.
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. Users can create their own advanced functions and incorporate these into Yellowfin via the plug-in manager.
Advanced functions, allow you to alter the data within a column after the primary report query has been run. Within an advanced function, you have the ability to reference other report columns, create user input parameters, and remove rows. This allows you to perform advanced custom calculations, ranging from anywhere from a simple cumulative total to referencing an external API to obtain predictions based on the dataset <H2O>.
Custom advanced functions are coded in Java, packaged as a jar file, and uploaded through the Yellowfin plugin manager. Once loaded into the application, the function becomes available to all reports.
Read a full explanation of how to code these.
Yellowfin ships with a large set of advanced functions out of the box. The full list can be found here.
These include a wide variety of statistical functions (Mean, Median, Mode and more advanced functions such as variance, standard deviation, linear regression, exponential smoothing); Date and Time functions (for example, to perform calculations between dates and times); Analysis functions (ranking, percentage of total) and many many more.
While analytical functions can alter the data itself, formatters control how the data is displayed to the end-user. The Custom formatter API allows you to provide your own functions in this process. One example of this is the ability to change how a phone number looks, based on its country code: in the US: (123) 456-7890 vs AUS (12) 3456 7890.
As Yellowfin tables are rendered with HTML, custom formatters also allow you to return your data in HTML format. This can be used to create more visual displays such as images, icons, and even sparklines.
Custom formatters are coded in Java, packaged as a jar file, and uploaded through the Yellowfin plugin manager. Once loaded into the application, the function becomes available to all reports.
Read a full explanation of how to code these.
This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.