In this article you will learn about how to change the chart background color and its opacity. First, open the chart report created using Helical Insight. Also, you can create your own customize report by connecting the datasource with Helical Insight. For your understanding we have used an “AreaSplineChart”. Default view of a generated chart
Read More
Different functions like sum, group by, and Count etc. can be applied to the variables. If the user drags or selects a column in the selection area, a function would be applied to that column by default, depending upon the type of variable. Mostly, a group by function is applied automatically for categorical variables and
Read More
Following are the mathematical functions that can be applied to the column: Group by Sum Distinct Count Max/Min Avg Users can observe that by default, categorical variables take ‘Group by’ function and Numerical variables take ‘Sum’ function. These default applied functions can be seen and changed in the Meta data file which is present in
Read More
Metadata is basically a logical DB schema which gets stored locally in the backend DB of Helical Insight and allows users to define which tables, columns they would want to keep. Thus, different Metadata can be created for the different set of users like finance metadata, sales metadata, operations metadata which then can be shared
Read More
In this blog, we will how to connect to a data source in Helical Insight. Overview of Data Sources Tab The list of Data sources is present as a collection of icons for each database. User can search for the data source by typing in the search box. User can also search based on type
Read More
Custom column feature allows user to create a separate derived column which could be required for creating adhoc reports. This is useful when the data is required in different format as that of present in the database. Some use cases of Custom column are mentioned below: We have ‘time of call’ in the database. Let
Read More
Toggle Auto-Update: On enabling toggle auto-update, the user does not need to click on generate reports. As soon as any filter is applied or columns
Read More
Users can create Reports in the form of Table, Chart, Cross-tab and Geographical Map. Table: Output is seen in a tabular format (Rows & Columns) Charts: Users can select any of the charts from the list containing Non-axes charts, Axes charts & advanced charts to create data visualizations. Cross-tab: Data in the tabular format
Read More
In Settings tab, users can change the sample size to any numerical value or select full sample size. Note : Sample size is the size of data that would be visualized while you create a report. Users can unselect the option of prepending the table names. Doing this, users would then only see the column
Read More
Editor Tab is especially for the developers who can modify the results using HTML & CSS. At the report level interface you can see Editor Icon clicking on that you can see two options i.e. JS Editor & CSS Editor. 1. JS editor: Users can write Java scripts in this section for adding customizations like
Read More