• Report Editor Overview

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

• Tabs

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

• Filter

  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 (e.g. email, name, ...): equals to any of not equal to any of is empty is not empty starts with Special fields: e.g., Risk Level → chooseSome readers

• Selection

  Selection Field Selection Search or browse for fields you want to add to your report: 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: If you hover over a field, a bFew readers

• Layout

  Layout Change the column order or column name Modify the column settings Click on the settings icon next to a column to access additional configuration options: There are different options depending on the tSome readers

• Mappings

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

• Rows

  Rows Customize the header row "Hide header Row" ( 1 ): No header row will be in the output file (Excel, CSV) Add additional rows ( 2: ) 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" or "afteFew readers

• Aggregations

  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, minimums, maximums and averages, and even sort the results. 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: Create a new reportFew readers