Report Pundit
WelcomeStart Free Trial
  • โœจWelcome to Report Pundit Documentation
  • ๐ŸกReport Pundit Website
  • ๐Ÿ’ปReport Pundit App
  • ๐Ÿ›’Shopify Testimonials
  • ๐Ÿ“ŒGetting Started
    • ๐Ÿ‘จโ€๐ŸซWalkthrough
    • โ„น๏ธNavigation Panel
    • ๐Ÿ Home
    • ๐Ÿ“”Library
    • ๐Ÿ’ผMy Reports
    • โฐSchedules
    • โš™๏ธSettings
      • ๐ŸชชAccount
      • ๐Ÿ”Data Sync Options
      • ๐Ÿ› ๏ธReport Formatting
        • ๐Ÿ“…Week Start from Sunday
        • ๐ŸŒ•Include Current Day
        • ๐Ÿ’ฒEnable Currency for Reports
      • ๐Ÿ“€FTP, Google Drive, and Google Sheets
      • ๐ŸŒ€Recent Sync History
      • ๐Ÿ“ฌCustom Email
      • ๐Ÿ‘ฅUser Management
      • ๐Ÿคตโ€โ™‚๏ธShopify staff
    • ๐ŸงฉHow to Create a Custom Report and Auto-Schedule It
  • ๐Ÿง Knowledge Base
    • ๐ŸงพReport Creation
      • Customized Reports
        • Re-arrange columns
      • 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 Fields
        • Calculated Columns (Fields)
        • ๐Ÿ›ก๏ธStatic Field
      • Data Comparison
      • Formatting Tools
      • Sharing Report Links
      • Exporting the report
      • Unique Reports
      • Staff Details
      • Other Options
    • ๐Ÿ”—App Integrations
      • Stocky
      • UpPromote
      • Yotpo
      • Sezzle
      • Square
      • PayPal
      • Google Analytics 4
      • Amazon Ads
      • Bing Ads (Microsoft Ads)
      • Facebook
      • Snapchat
      • TikTok
      • Ship Bob
      • Ship Station
      • Ship Hero
      • Bold
      • Printful
      • Printavo
      • Authorize.net
      • Recharge Payments
      • Klarna
      • Shippo
      • Returnly
      • Rich Returns
      • Seal Subscriptions
      • Google Ads
      • Stripe
    • ๐Ÿ“ฅSchedules
      • โŒšHourly
        • "N" Number of Days
        • Week to Date
        • Static Start Date
        • Custom Date Range
      • ๐ŸŒžDaily
        • Custom Time Range
        • Custom Date Range
        • Static Start Date
        • Year to Date
        • Quarter to Date
        • Month to Date
        • Week to Date
        • "N" Number of Days
      • ๐Ÿ“†Weekly
        • Year to Date
        • Quarter to Date
        • Month to date
        • "N" Number of Days
        • Static start date
        • Custom Date Range
      • ๐Ÿ—“๏ธMonthly
        • "N" Number of Days
        • Quarter to Date
        • Year to Date
        • Static Start Date
        • Custom Date Range
      • ๐Ÿ•žSchedule Modification
      • ๐Ÿ”ฝOutput Options
        • Email
        • ๐Ÿ“คFTP
        • ๐Ÿ’ฝGoogle Drive
        • ๐Ÿ—’๏ธGoogle Sheets
        • Power BI
        • BigQuery
    • ๐Ÿ“ƒReport Types
      • ๐ŸคตSales
      • ๐ŸฅกOrders
      • Inventory
      • ๐ŸŽFulfilment
      • Customer
    • ๐Ÿ”„Data Synchronization
      • How to Manage Your Data Mismatch Issue
  • โ“FAQ
    • Reports
    • Schedules
    • Data Sync
    • Billing & Sales
    • Service
  • ๐Ÿ“‹Changelog
Powered by GitBook
On this page
  • How to Enable This Feature
  • How to Add Custom Fields
  1. Knowledge Base
  2. Report Creation

Custom Fields

Create data fields in reports that serve your unique business needs with Custom Fields. Find the details you need to set up and operate them on this page.

PreviousSortNextCalculated Columns (Fields)

Last updated 8 months ago

Report Pundit lets you fine-tune your reports with custom fields. Expand the capabilities of your Shopify reporting by adding Calculated and Static fields alongside default ones. Add to the insights given by your reports by further drilling down on your Shopify store data.

How to Enable This Feature

Custom Columns are disabled in Report Pundit by default for both new and existing users. It will be enabled by our technical support team from the back-end upon request. This is a one-time process. Once successfully enabled, you can create and edit custom columns as required.

How to Add Custom Fields

To create a custom field, click on Add Columns above the first data row in a report. Then, click on Add Custom Column option as shown below.

In the drop-down menu displayed, choose Calculated or Static as required. Next, you'll see a pop-up box where you can give your field a name and:

  • Add a Static Value if you're creating a static field

  • Add SQL code to create a calculated field, along with one of these format options:

  1. String: For adding alphabets, numbers, or alphanumerical inputs. Numbers added won't have numerical values and cannot be used for definite measure.

  2. Number: For adding numerical values to the column.

  3. Boolean: For adding Boolean operators, such as '1' representing 'True' and '0' representing 'False'.

  4. Date & Time: For adding date, day, and time inputs to your field.

We have categorized Custom Fields into two types:

๐Ÿง 
๐Ÿงพ
๐Ÿ–Œ๏ธ
Calculated Columns (Fields)
๐Ÿ›ก๏ธStatic Field
๐Ÿ‘‰