Calculated Fields

Learn more about Report Pundit Calculated Fields, an exclusive feature for Shopify merchants.

Calculated fields' editor can be used to create a custom function for a particular field.

๐Ÿ“‹ Steps to Create a Calculated Field

โœ”๏ธ Click on the 'Custom Field' button (located below Report Type within the Report Designer screen).

โœ”๏ธ Click on 'Add Calculated field'

โœ”๏ธ Click on the blank space to write a custom function. The function needs to be written in PostgreSQL.

Note: Click on Help Documentation to view various functions that you can use. It is recommended to use this feature with basic knowledge of PostgreSQL. To learn more about PostgresSQL syntax, please visit this link.

Hint: Type a keyword for the field to receive suggestions to add into the editor.

There are various calculations and commands which can be executed through these custom fields.

These are just a few commands available under the 'String' format, along with its Syntax.

  • Character Length

  • All characters in Lower Case

  • All letters in Upper Case

  • String Concatenation 2

    'String: ' || integer

Tutorial Video: How to use Calculated Fields?

In this tutorial video, we will guide you through the process of using calculated fields to generate your report.

Last updated