• Report Editor Overview

  The Report Editor enables you to create and customize every aspect of your report. You find details about the sections in the following pages: Tabs Filter Selection & Layout Rows (/en/article/rows-lSome readers

• Tabs

  Add a new tab by clicking the "+" icon. Choose from one of these export types: Collection Customer Location Order Product Simply click the "+" icon again to add as many tabs as needed in your Excel export. When you hover over the tab name, icoFew readers

• Filter

  Filters allow you to customize the data exported in your Excel or CSV files. Depending on the field type, different filter options are available: date fields after (a date) before (a date) between (two date values) current is empty last ( of days) on (given date) Char fields (eg email, name, ...) equals to any of not equal to any of is empty is not empty starts with special fields eg "Risk Level "Some readers

• Selection

  Within the Columns tab ( ), you can select any data from Shopify that you want to export: If you click on "Browse" ( ), you will see an overview of all available fields for export. Then simply click on the fields you want to select: (https://storage.crisp.chat/users/helpdesk/wFew readers

• Layout

  Click on the settings icon next to a column to access additional configuration options: There are different options depending on the type of theSome readers

• Mappings

  In this tutorial, we'll show you how to use Mappings in DataChamp and how to calculate values. With mappings you can customize the output of any column. There are three sections: if set to Use this section in the same way as "filters". Set up the condition when the mapping should be usSome readers

• Rows

  "Hide header Row" ( ): No header row will be in the output file (Excel, CSV) ( ) after header row as first row as last row before each new item after each new item If you use the position "before each new item" oFew readers

• Aggregations

  The Aggregation Function in DataChamp is a versatile feature designed to help you analyze your data effectively. It allows you to group values by rows or columns, calculate sums, minimuns, maximums and averages, and even sort the results. Here’s how to make the most of it. In this tutorial, we'll walk you through a simple example on how to use the Aggregation Function to generate a report that calculates the Average Order Value per Country: youtube (uUFew readers