Visualization Framework (VF), is a framework that is used to generate different visualizations. The VF accepts JavaScripts to generate the required visualization. The Reports module provides some predefined visualizations and also allows users to add newer, often required visualizations to that list.

However, if the user requires to use a certain visualization for an exceptional case, the said visualization need not be added to the list of existing visualization options, instead can be stored separately and called only for the said case.

How to use Visualization Framework (VF) in HI V5.1.0 :

Visualization Framework (VF) can be used in ‘Reports’ module inside “Visualization” tab at report level.To create customizable visualizations using VF component user need to connect to metadata and add fields into the Column or Rows shelves. Now to create any visualization user need to write the script in VF editor area and click on ‘Apply’ button. User can create VF reports by using Report data and Static data well.

Visualization Framework (VF) In Helical Insight Version 5.1.0

Visualization Framework (VF) In Helical Insight Version 5.1.0

User can write any JavaScript function inside editor and execute it, please make sure whatever function you’ll write in the editor should return jsx/html in order to print something in the rendering area of report.

Below is example to create ‘Line Chart’ of Antd library using VF :

Visualization Framework (VF) In Helical Insight Version 5.1.0

Note: To generate this visualization user need to add ‘booking_platform’to Column shelves and ‘sum_travel_cost’to Row shelves.

The above example will create a Line chart using the data present in the report. In this :

data is assigned to a variable , this data is present in hreport and VF has access to it
report is assigned to a variable, this report is present in hreport and VF has access to it. components is an instance to VF , it contains all the components that are used in hreport and you can get anything from it and use it in your chart.

Points to be remember while writing scripts in VF :

1. whatever function you’ll write in editor , please make sure that the top most parent function should be a normal javascript function and it should always written some jsx/html, you can return null as well , i.e it should be like

function abc(){ return <h1>hello world!</h1>} ,

2. if you want to import something then you’ll have to get it from components, components is the instance to this editor which contains every possible component/chart of the libraries that we are using in our application . i.e. antd, antd charts , muze charts etc.

you can import something like this –

function abc(){
                             const {Line} = components,
                              ...
                          }

similarly we have two more instances : “report” and “data” report is the current active report of the application and data is the json object of the data that is being used in the report.

3. The top most parent function will be a normal function of js , i.e it starts with function keyword (This is the limitation of the library that we are using for VF , and in future it’ll be fixed) , but you still can use the other functions such as arrow function but that you can do inside the parent function only.
For.Eg :

Visualization Framework (VF) In Helical Insight Version 5.1.0

Below are the few examples of visualizations which are created by using Visualization Framework (VF) :

Example 1 –

Visualization Name : BidirectionalBar 
Library Used : Antd

Visualization Framework (VF) In Helical Insight Version 5.1.0

Note :To generate this visualization user need to add ‘destination’ to Column shelves and ‘count_source_id’ and ’count_travel_id’to Row shelves.

Generated visualization :

Visualization Framework (VF) In Helical Insight Version 5.1.0

Example 2 –

Visualization Name : Radar
Library Used : Antd

Visualization Framework (VF) In Helical Insight Version 5.1.0

Note: To generate this visualization user need to add ‘mode_of_payment’ to Column shelves and ‘sum_travel_cost’to Row shelves.

Generated visualization :

Visualization Framework (VF) In Helical Insight Version 5.1.0

Visualization Name : Bar
Library Used : Muze

Visualization Framework (VF) In Helical Insight Version 5.1.0

Note: To generate this visualization user need to add ‘booking_platform’ to Column shelves and ‘sum_travel_cost’to Row shelves.

Generated visualization :

Visualization Framework (VF) In Helical Insight Version 5.1.0

Example to create VF reports with Static Data :

Visualization Framework (VF) In Helical Insight Version 5.1.0

Generated visualization :

Visualization Framework (VF) In Helical Insight Version 5.1.0

Note :To create VF report with Static data user needs to connect to metadata and add any field to column or row shelve.

How to use Default tooltip,Marks,Report properties and Interactivity with VF reports :

To enhance the chart creation and to use default functionalities from Report module user can use below helper functions in VF script.

1. Function to use default tooltip in VF report

const {getTooltip} = helperFunctions

2. Function to use Report properties in VF report

const {getPropertiesConfig} = helperFunctions

3. Function to use Marks in VF report

const {getPropertiesConfig} = helperFunctions

4. Function to enable interactivity in VF report

const {enableInteractivity} = helperFunctions

Below is the example of how to use above helper functions in VF reports :

Visualization Framework (VF) In Helical Insight Version 5.1.0

Note: Above is the example from Antd chart so in return it is used (“antd”, report) in helper function, for muze library charts we need to return (“muze”, report).

You can create the other examples from Antd and Muze library with VF in HI application.Examples are present on below websites :

Antd charts :

https://ant-design-charts.antgroup.com/en/examples

Muze chart :

https://github.com/chartshq/reactmuze/tree/master/examples/src/Examples

Thank You
Kedar Ingale
Helical Insight

Helical Insight’s self-service capabilities is one to reckon with. It allows you to simply drag and drop columns, add filters, apply aggregate functions if required, and create reports and dashboards on the fly. For advanced users, the self-service component has ability to add javascript, HTML, HTML5, CSS, CSS3 and AJAX. These customizations allow you to create dynamic reports and dashboards. You can also add new charts inside the self-service component, add new kind of aggregate functions and customize it using our APIs.
Helical Insight’s self-service capabilities is one to reckon with. It allows you to simply drag and drop columns, add filters, apply aggregate functions if required, and create reports and dashboards on the fly. For advanced users, the self-service component has ability to add javascript, HTML, HTML5, CSS, CSS3 and AJAX. These customizations allow you to create dynamic reports and dashboards. You can also add new charts inside the self-service component, add new kind of aggregate functions and customize it using our APIs.
Helical Insight, via simple browser based interface of Canned Reporting module, also allows to create pixel perfect printer friendly document kind of reports also like Invoice, P&L Statement, Balance sheet etc.
Helical Insight, via simple browser based interface of Canned Reporting module, also allows to create pixel perfect printer friendly document kind of reports also like Invoice, P&L Statement, Balance sheet etc.
If you have a product, built on any platform like Dot Net or Java or PHP or Ruby, you can easily embed Helical Insight within it using iFrames or webservices, for quick value add through instant visualization of data.
If you have a product, built on any platform like Dot Net or Java or PHP or Ruby, you can easily embed Helical Insight within it using iFrames or webservices, for quick value add through instant visualization of data.
Being a 100% browser-based BI tool, you can connect with your database and analyse across any location and device. There is no need to download or install heavy memory-consuming developer tools – All you need is a Browser application! We are battle-tested on most of the commonly used browsers.
Being a 100% browser-based BI tool, you can connect with your database and analyse across any location and device. There is no need to download or install heavy memory-consuming developer tools – All you need is a Browser application! We are battle-tested on most of the commonly used browsers.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
We have organization level security where the Superadmin can create, delete and modify roles. Dashboards and reports can be added to that organization. This ensures multitenancy.
A first-of-its-kind Open-Source BI framework, Helical Insight is completely API-driven. This allows you to add functionalities, including but not limited to adding a new exporting type, new datasource type, core functionality expansion, new charting in adhoc etc., at any place whenever you wish, using your own in-house developers.
A first-of-its-kind Open-Source BI framework, Helical Insight is completely API-driven. This allows you to add functionalities, including but not limited to adding a new exporting type, new datasource type, core functionality expansion, new charting in adhoc etc., at any place whenever you wish, using your own in-house developers.
It handles huge volumes of data effectively. Caching, Pagination, Load-Balancing and In-Memory not only provides you with amazing experience, but also and does not burden the database server more than required. Further effective use of computing power gives best performance and complex calculations even on the big data even with smaller machines for your personal use. Filtering, Sorting, Cube Analysis, Inter Panel Communication on the dashboards all at lightning speed. Thereby, making best open-source Business Intelligence solution in the market.
It handles huge volumes of data effectively. Caching, Pagination, Load-Balancing and In-Memory not only provides you with amazing experience, but also and does not burden the database server more than required. Further effective use of computing power gives best performance and complex calculations even on the big data even with smaller machines for your personal use. Filtering, Sorting, Cube Analysis, Inter Panel Communication on the dashboards all at lightning speed. Thereby, making best open-source Business Intelligence solution in the market.
With advance NLP algorithm, business users simply ask questions like, “show me sales of last quarter”, “average monthly sales of my products”. Let the application give the power to users without knowledge of query language or underlying data architecture
With advance NLP algorithm, business users simply ask questions like, “show me sales of last quarter”, “average monthly sales of my products”. Let the application give the power to users without knowledge of query language or underlying data architecture
Our application is compatible with almost all databases, be it RDBMS, or columnar database, or even flat files like spreadsheets or csv files. You can even connect to your own custom database via JDBC connection. Further, our database connection can be switched dynamically based on logged in users or its organization or other parameters. So, all your clients can use the same reports and dashboards without worrying about any data security breech.
Our application is compatible with almost all databases, be it RDBMS, or columnar database, or even flat files like spreadsheets or csv files. You can even connect to your own custom database via JDBC connection. Further, our database connection can be switched dynamically based on logged in users or its organization or other parameters. So, all your clients can use the same reports and dashboards without worrying about any data security breech.
Our application can be installed on an in-house server where you have full control of your data and its security. Or on cloud where it is accessible to larger audience without overheads and maintenance of the servers. One solution that works for all.
Our application can be installed on an in-house server where you have full control of your data and its security. Or on cloud where it is accessible to larger audience without overheads and maintenance of the servers. One solution that works for all.
Different companies have different business processes that the existing BI tools do not encompass. Helical Insight permits you to design your own workflows and specify what functional module of BI gets triggered
Different companies have different business processes that the existing BI tools do not encompass. Helical Insight permits you to design your own workflows and specify what functional module of BI gets triggered