Calculated Columns (Fields)

Learn more about Calculated Columns , an exclusive feature for Shopify merchants by Report Pundit that simplifies custom data acquisition.

Calculated columns let you add data fields to your reports tailored to your needs. You can add custom formulas using existing data during creation, and can modify it later as required.

Calculated columns deliver data that you won't find otherwise, enabling deep insights into any store metric for enhanced data-driven decisions.

Once you've enabled the custom column feature for your Report Pundit account, follow these steps to create your desired columns:

  1. Open your desired report by clicking on Library or My Reports in the navigation bar.

  2. Click on the Add Columns button above the report's data table. You should see a pop-up menu with data columns.

  3. Click on the Add Custom Column option at the bottom-right corner of the menu. You'll see a drop-down menu letting you choose between adding Calculated or Static field. Click on the Calculated Field option.

  4. A new box will pop-up with sections to add column name and formula. Give the column a meaningful name and add your desired calculation.

Defining Field Calculations

  • Use the available functions and operators to build your calculation. The function needs to be written in PostgreSQL.

  • Only columns that already exist in the report can be used for calculation. Make sure you add all relevant columns to the report before creating a calculated field. For example, to calculate "Sales," you can use the formula: [Ordered Quantity] * [Product Price].

Select the desired Output Type (String, Number, DateTime, or Boolean) using the drop-down menu at the bottom.

  • Format (Optional): If the Numeric Output type is selected, you can choose to apply formatting to the calculated column (e.g., currency, percentage).

  1. Once done, click on Save to create the column or Cancel to exit without creating it.

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

Important: You should save the report to retain the calculated column.

If you need help creating a custom column, click on Request Custom Column from the Manage Column screen or the Need Custom Column from the Calculated Column screen, describe your requirement and submit request. The Report Pundit support team will create the custom column for you.

You can also contact the support team for any custom column related issues or clarifications.

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.

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

These are a few commands available under the 'String' format, with syntax:

  • Character Length

    char_length([field_name])
  • All characters in Lower Case

    lower(string)
  • All letters in Upper Case

    upper(string)
  • String Concatenation 2

    'String: ' || integer

Tutorial Video: How to use Calculated Fields?

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

Last updated