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
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
Helical Insight version 5.0 onwards provides Table, Crosstable (also known as Pivot Table), Gridchart (which has got multiple further charting options) as well as Chart. This chart comes with some extensive set of charting options. Let us begin with example. Let us drag the fields bookng_platform and travel_cost to selected list (Columns or Rows: anywhere),
Read More
The custom column feature allows users to create a separate derived column which could be required for creating reports. This is useful when the data is required in a different format or there is some custom calculation which is required. In custom column we can write SQLFunction (as long as it returns a single column
Read More
In this blog, we are going to cover how-to Align reports in Dashboard Designer as well as the other advanced options of grid settings which can be used along with alignment Using Alignment option with respect to Grid Setting’s column we can easily set the component’s height and width alignment for screen size which will
Read More
With version 5.0 onwards we have revamped the entire UX of dashboard designer and made it much more smoother and easier to use. On the dashboard designer page, there are multiple operations and functionalities which can be done by right-clicking. Now on whatever component the right click happens, the functionality/UX changes get applied to that
Read More
In this blog we are going to cover and provide an overview of dashboard designer module. The dashboard designer module of version 5.0 has undergone major changes making the entire process of applying filters and making reports listen to it much more simple, handling the resizing without affecting the alignment and much more. Adding Reports
Read More