In the ever-evolving landscape of data analytics and visualization, the power of open source tools has become increasingly evident. Among the plethora of options available, Helical Insight emerges as a beacon of innovation and reliability, spearheading a revolution in data visualization. Let’s delve into why Helical Insight stands tall as the frontrunner in the realm
Read More
In helicalinsight few values are restricted in filter expression for the security reasons. If you pass that restricted keyword you might get the below error Error: HCRException: The filter value is unaccepted, please try with someother value. In case if you compulsory want those values to be passed in filter expression then navigate yourself 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
In many cases we might use Helical Insight with Trino wherein Trino will be in turn connecting to one or multiple datasources like Mongo. In this document we will be covering how to install Trino and connect to a datasource. And then how Helical Insight can then be used via Trino to connect to that
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
This document is applicble to Helical Insight version 5.0 and onwards. In this document we are going to use JS and CSS to customize the login page. We use CSS for styling and JS for changing the actual content of an element in the DOM. Customization with CSS : 1. To style the total background
Read More
It is possible to add one or multiple filters in Helical Insight. By default all the filters gets added in AND expression i.e. Filter1 AND Filter2 AND Filter3 which means it shows an overlap of data wherein all the filtering conditions value gets satisfied. But in some cases we may want to change and use
Read More
From the version 5.2 onwards of Open Source BI Helical Insight, we are directly supporting DuckDB out of the box. Hence the steps mentioned in this blog are not required. In the below image we have highlighted from where you can find out about the current version of your Helical Insight instance. Connection string looks
Read More
On charts/tables/visualization we support UTF-8 character, that means whichever language you have the data in, it will appear exactly in the same format in the visualizations. Even the text components or headers or column headers alias etc which you are adding at report/dashboard it can be in anylanguage. However, by default Open Source BI Helical
Read More
In Open Source BI product Helical Insight version 5.0 built 1083 onwards, we had added a new functionality called “Reference Line” option. This allows you to add a new reference line which can often be helpful in doing the comparison. Navigate to Marks by clicking on the 3 dots(meatball icon) that appear beside Visualization. Within
Read More