Use of 2 or more Database Functions

Hello Helical,

I am using Helical Insight 4.0 to connect to Mongo DB via Apache Drill. I am using Key Value function to get the values on the frontend. However, the output is in varchar format. I want to have a sum of this particular field. Can I use type conversion function on top of this key value function?

Thank You,
Kajipe.

Hello Kajipi,

Helical Insight allows the use of nested database functions.
In order to achieve the output in the above example, first use the CAST function in type conversion.
In the column section, drag the key-value function. Within this, give your column and the key name.
Give the conversion type as integer. Save the function.

image

Apply “Sum” aggregate function and generate the report.

image

Thank You,
Helical Insight.