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
Read More
In this blog we will cover how to export a reports data in Excel or CSV format in a dashboard for version 5.0 onwards of Open Source BI product Helical Insight. NOTE: This will export individual panel data of a dashboard. It is not possible to export entire dashboard data into a single CSV/Excel, reason
Read More
If a CrossTab has more than one row/column group level, then this functionality give control to the user to specify whether or not to enable the CrossTab to be expanded at runtime, and set the default expanding/collapsing state of groups in the outer level. This functionality is available in CrossTab property and which is applicable
Read More
This article shows how to apply page break in group footer which is used to display totals at the group level. A Page Break or hard page break is a code inserted by a software program (e.g., word processor) telling the printer where to end the current page and begin the next. To add a
Read More
In this blog we are going to cover how to connect CSV files in Helical Insight 5.1 via apache drill It will also support flat files like excel ,json , parquet files etc ( process will be same as CSV) Follow below steps : 1. Download, install and start Apache Drill. To learn how to
Read More
In this article we will see how we can create a dynamic parameter for canned reports.This document has been created for Helical Insight version 4.1 GA. A parameter is a variable that takes the value passed by the user and hence the data gets filtered before it is displayed on your screen. A parameter can
Read More
This article shows various types of settings for listeners of parameters added in the canned report. This blog has been created for Helical Insight version 4.1 GA canned reporting module. Briefly, the steps involved in creating a canned report are: Create a connection Write a query without where clause Add input parameter and give its
Read More
This blog is relevant to Helical Insight version 5.0 and upwards. In Helical Insight version 5.0 onwards filters are identified by their filter names. If your dashboard is having 5 reports and all of the reports have a filter with filterlabel “Country”. Then changing the value of the filter Country at dashboard level will change
Read More
We had a major release of our version 5.0(Version 5.0 build 960) few months back wherein we had made a lot of changes and focused a lot on improving the entire UI UX as well as there were a lot of changes were made on the backend frontend. We have been working hard on latest
Read More
In this blog we will learn how to use ‘Table’ property to give users the ability to set the number of records per page. Note :This property is applicable for Table only. 1. Open the Reports Module/Tab in Helical Insight and connect with already created Metadata(from SampleTravelData database). 2. Add travel_id column to column shelves
Read More