NOTE: From version 5.2.2, additional options of Drill Through with limited data (based on the on-click event) or full data with default values is introduced. The same is covered towards the end of the blog. In this document we will be covering how to create a drill through report. Refer to our other blog to
Read More
In this blog, you will learn about how to use Apply before Aggregate function. Basically this can be used to specify the sequence in which we would like to apply the dbfunctions along with aggregate functions i.e. whether first aggregate function should get applied or whether first DBfunctions should get applied. Let us understand with
Read More
Following are the steps to add a Header to a Dashboard. This below UI is available from the version 5.0 onwards of Helical Insight: The header option allows giving the entire dashboard or individual components a header, based on where we have right clicked and specifying the configurations. Right-click on the dashboard designer page, when
Read More
In this document, we are going to explain about usage of DATE RANGE PICKER component in Dashboard Designer. 1. While creating adhoc report, we have to add 2 different date or date time filters on same date or date time column. 1 filter for Starting Date with condition Greater Than or Equal to and 1
Read More
Canned reports are not self service adhoc reports, these are pixel perfect canned reports and they take more time to develop wherein the alignment, size, repetition etc are specified. Even though they take more time to develop, in this blog, we are going to cover what are the best practices which can be followed for
Read More
In this document we are going to cover the usage of dynamic view with one of the sample example. Also we will discuss about what all are must things for creating the dynamic view. 1. What is dynamic view and how it is different from normal view ? – In normal view, you cannot pass
Read More
We are creating a custom drill down function using java script code , we will explain drill down for pie chart as well as Tabular report. Follow below steps in order to creating custom drill down functionality with child dashboard. Step 1: – Create a Parent Report and apply a filter as per your requirements.
Read More
You don’t need to spend lot of time for research on which is best power BI alternative. already you have reached right article, Helical Insight is the best alternative of Open Source Microsoft Power BI
Read More
In this blog we are going to explain how to install 2 instances of helical insight on the same server and same tomcat and same port number but with a different extension. Like below http://localhost:8085/hi-ee -Instance 1 http://localhost:8085/bi-ee -Instance 2 (A) So first of all you will install the first version with hi-ee using the
Read More
Till version 4.1 GA Enterprise edition the charting engine provided by default Helical Insight Community Edition is D3 and C3 charts (except table, crosstab, polar, radar and map). We have by default many UI driven customization options. Anyhow, there will be few requirements which cannot be accomplished with help of default properties. In such cases,
Read More