Numeric Database Archives - Helical Insight

Truncate Database Function Usage in Helical Insight

In this blog we will learn how to display a number truncated to a certain number of decimal places from numeric column in Helical Insight. Below you can see we are having a column in decimal values. If we want to display a number truncated to a certain number of decimal. Click on column. Click

database functions, helical insight, open source business intelligence, truncate database function

Share with

SQRT Database Function Usage in Helical Insight

In this blog we will learn how to display the square root of a non-negative number from numeric column in Helical Insight. If we want to display the square root of a non-negative number. Click on Travel Cost column. Click on more, user will get two options i.e., Quick and Advanced Click on “Advanced” in

database, helical insight, open source business intelligence, SQRT database function

Share with

SecToTime Database Function Usage in Helical Insight

In this blog, we will learn how to convert numeric seconds into a time value (hh:mm:ss) from numeric column in Helical Insight. If we want to convert numeric seconds into a time value (hh:mm:ss). Click on Travel Cost column. Click on more, user will get two options i.e., Quick and Advanced Click on “Advanced” in

helical insight, numeric database functions, open source business intelligence, SecToTime database

Share with

Round Database Function Usage in Helical Insight

In this blog, we will learn how to display a value rounded to a certain number of decimal places from numeric column in Helical Insight. Below you can see we are having a column in decimal values. If we want to display a value rounded to a certain number of decimal places. Click on Travel

helical insight, numeric database functions, open source business intelligence

Share with

Radians Database Function Usage in Helical Insight

In this blog we will learn how to convert the value of a number from degrees to radians from numeric column in Helical Insight. If we want to convert the value of a number from degrees to radians. Click on Travel Cost column. Click on more, user will get two options i.e., Quick and Advanced

helical insight, open source business intelligence, radians database function