Knowledge Base

How to use the Calculate Block

Next >>

<< Prev

Calculate Block tutorial transcript

To perform data transformation in the Calculate Block:

Step 1. Bring the Calculate Block from the Block Library onto the Main Canvas, and connect it to the input data.
Step 2. To add new columns, press the “+ Calc Col” button. Define the calculation using functions and expressions in the Calculation Editor. Name the new column and click “OK”.
Step 3. To edit columns, click on the “…” button. Edit column definition in the Calculation Editor and click “OK”.
Step 4. To rename a column simply type a new column name.
Step 5. To change column order, click on the column and drag it up or down.
Step 6. To delete a column, click on the “Delete” button.
Step 7. Pass the output of the Calculate Block to another block.
Step 8. Click on the output stub of the Calculate Block, and use Data Viewer to view the created columns.

Contents:

  • Add new columns
  • Edit columns
  • Rename columns
  • Change column order
  • Delete columns
  • Calculation Editor

Related Materials:

Transcript – How to use the Calculate Block

Other resources:

Tutorial 3: How to perform calculations and transformations on your data.

Documentation

Length:

1:17

You can download a free trial of Analytics Canvas to follow along with the video.

Back to more Support    |   Try Analytics Canvas for Free

Was this article helpful?

Related Tutorials/Video

Need Support?

If you need any further help, don't hesitate to send a support request to our support team.

Contact Support