In this blog we are going to cover how to connect to an API / HTTP requests from Open Source BI product Helical Insight and use that to create reports. Introduction : Apache drill has introduced HTTP storage plugin from drill version 1.18 and onwards. The HTTP storage plugin lets you query APIs over HTTP/REST.
Read More
Adding shadow is one of the many right-click operations available for your use. Depending on which object you right-click on (dashboard, report, text, image, group etc), the properties will be applied only to that object Step 1: Right click and select Shadow. This will give you options related to shadow for that component. In this
Read More
Many a times there arise a need to add up additional objects to dashboard, other than reports that we have built up. We may need to add additional text to label up the objects or put up a description or elaborate a report. Other times we may have to add up the organization logo or
Read More
In this blog we are going to cover some of the advanced filtering options When we add filters, few more additional options have been added for more granular control. This option gives you additional control over your filters and its application to the reports Unique a. If this option is checked, system will generate unique
Read More
The new Visualization option introduced in Helical Insight is that of Card widget. It gives an option to generate a single value output for reports. Like total sales of current month, or Profit YTD. It generates the single value output as shown below. There is even an option of adding a subchart kind of option
Read More
This topic will show you how the Inter Panel Communication (IPC) works on Dashboards of Helical Insight 5.0 onwards. With interpanel communication you can click on one of the places in the chart of dashboard and the other charts can accordingly get filtered and will show filtered out data. From version 5.0 onwards the entire
Read More
We have recently released the GA version of Helical Insight 5.0 in May 2023 after success of RC2 version short while ago. It has been a long road and many functionalities as well as user experience has improvised and standardised since last version. In this blog, we will cover the major changes that our new
Read More
This is the first or default visualization that you will see when you generate the report. This is also a first place to start before applying any other visualization as this shows the exact result of your search parameters and perhaps the most commonly used visualization option. Table visualization can show any number of dimension
Read More
Depending upon needs we may have to use a Grid Chart some times. When there are a lot of comparisons to be made. Think of it as if we have to compare total_cost, based on multiple criteria like per mode_of_payment, per booking_platform, per client, and we want to see that split as per meeting_purpose. Let
Read More
Generally, the output of SQL in a tabular format is not very optimal information to understand and put to use. If we are dealing with textual information we need to represent information from one column against another column to have a comparative analysis. CrossTab visualization is designed for that purpose. With version 5.0 onwards we
Read More