Skip to main content
Interania

Create a Derived Column

0votes
4updates
159views

Use derived columns to define new calculated columns after data has been imported. You can define the derived columns with D language functions, and they must return integer (long) or decimal (double) type values. See Derived column examples for more detailed examples of using derived columns in Interana. 

But the basic process of creating a derived column starts from the Settings tab of the Visual Explorer.

From the Settings > Manage Data tab, click to Edit an existing table. Click the Add Derived Column button in the lower-left corner.

In the Edit Derived Column dialog, type a D programming language function that returns a long datatype, then click Save Derived Column. See Derived column syntax for details. 

Now you can refer to your derived column normally in the user interface. In this example, we are grouping by the new funding_round_size derived column which allows us to quickly see the number of funding events that fall into four size buckets (<1M, 1-10M, 10-100M and >100M).

See Derived column examples for detailed examples about building and using derived columns.

  • Was this article helpful?