DATA EXPORT
WelcomeKnowledge BaseFAQStart Today
  • ✨Welcome to Data Export Documentation
  • 🏠Data Export Website
  • 💻Data Export App
  • 🛒Shopify Testimonials
  • 📌Getting Started
    • Pre-Made Reports
    • Reports
    • Scheduler
    • Settings
    • Data Synchronization
    • Data Export: Basic Functionality
  • 🧠Knowledge Base
    • Welcome to the Knowledge Base
    • Reports
      • Customized Reports
      • Filters
        • 'Contains' & 'Not contains'
        • 'is' & 'is not'
        • 'include' & 'exclude'
        • 'is BLANK' & 'is not BLANK'
        • 'Begins with' & 'Ends with'
        • '= Equals' & '!= Not equals'
        • '> Greater than' & '< Lesser than'
        • '>= Greater than or equal' & '<= Lesser than or equal'
      • Sort
      • Custom Columns
        • Calculated Columns
          • Add Order line item properties to your report
          • Add Metafields to your report
        • Static Column
      • Formatting Tools
      • Clone & Delete
    • Scheduler
      • ⌚Hourly Schedule
      • 🌞Daily Schedule
      • 🗒️Weekly Schedule
      • 📅Monthly Schedule
      • 🔽Output Options
        • Email
        • FTP
        • Google Drive
        • Google Sheets
  • ❓FAQ
    • Welcome to Data Export FAQ
    • Reports
    • Schedule
    • Sales & Billing
    • Data Sync
    • Service
  • 📋Changelog
Powered by GitBook
On this page

Was this helpful?

  1. Knowledge Base
  2. Reports
  3. Custom Columns

Calculated Columns

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

PreviousCustom ColumnsNextAdd Order line item properties to your report

Last updated 1 year ago

Was this helpful?

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

Steps to Create a Calculated Columns

  1. Click on columns

  2. Click on the 'Add Custom Column' icon.

  1. Click on 'Calculated Columns'

  2. Enter the field name in the respective space provided.

  3. Click on the blank space below to write a custom function. The function needs to be written in PostgreSQL.

Note: Click on Show Documentation to view various functions that you can use. It is recommended to use this feature with basic knowledge of PostgreSQL.

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

These are the commands available under the 'String' format along with its 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

These are the commands available under the 'Number' format along with its Syntax.

  • Adding two or more field values

    [field_name1] + [field_name2]
  • Subtracting two or more field values

    [field_name1] - [field_name2]
  • Multiplying two or more field values

    [field_name1] * [field_name2]
  • Dividing two field values

    [field_name1] / [field_name2]
  • Limit or Truncate the decimal values to 'n' number of decimal places.

    trunc([field_name],n)
  • Greaater Than ( > ) : Returns 'true' if first condition is greter than second condition, else return 'false'

    [field_name1] > [field_name2]
  • Lesser Than ( < ) : Returns 'true' if the first condition is greter than the second condition, else return 'false'

    [field_name1] < [field_name2]
  • Greater than or Equal to ( >= ) : Returns 'true' if the first condition is greater than or equal to the second condition, else return 'false'

    [field_name1] >= [field_name2]
  • Lesser than or Equal to ( <= ) : Returns 'true' if the first condition is less than or equal to the second condition, else return 'false'

    [field_name1] <= [field_name2]
  • Equal to ( = ) : Returns 'true' if the first condition is equal to the second condition, else return 'false'

    [field_name1] = [field_name2]
  • Not Equal to ( != ) : Returns 'true' if both conditions are not equal else, return 'false'

    [field_name1] !=[field_name2]
  • Display Current date

    current_date
  • Extracts only Day from Order Date

    extract (day from [Order Date])
  • Extracts only Month from Order Date

    extract (month from [Order Date])
  • Extracts only Year from Order Date

    extract (year from [Order Date])

Trunc: Trunc removes the fractional part of the number and rounds numbers down to the nearest integer based on the value of the fractional part of the number.

trunc(([fieldnme])::numeric, 2)

Round: The round() function rounds a number to a specified number of decimal places.

round(([fieldnme])::numeric, 2)

Float: Float is used to store approximate values, not exact values. It has a precision from 1 to 53 digits.

float(([fieldnme])::numeric, 2)

Concat: Concat() function adds two or more expressions together.

concat([field_1],' ',[field_2],' ',[field_3])

🧠
📋