How Do I Add, Change, or Remove Columns from a Report?

The first article in our new 'basics' series, this one looks at how to add/change/remove columns from a report in Report Toaster. 

First, choose the report you want to modify. In this example, we'll use the Sales - '30 Day Summary' report:

Adding Columns

Step 1 - Click on the grid button (top right). This opens the columns popup like so: 

Step 2 -  Those fields listed on the left hand side are already on the report, while those on the right are the available options to add to it.

These are searchable - so let's say I was looking for 'Transaction Fees', I could type that in (where it says 'type to filter') ...

Step 3 - ... and transaction fees appears! Hold down left-click on any field you want and drag it over to the left hand side. You should now see it appear on the left like so: 

Hit 'Ok' when you're done, and that's it :) 

Changing the Order 

Step 1 -  The order the fields appear in on the left (ascending) is the order they will appear on the report. So suppose I want Transaction fees to appear last, I can follow the same drag/drop procedure and move it to the bottom like so: 

Step 2 - Notice that now, Transaction Fees appears as the last column on the main report. 

Metric Columns

Sometimes you will be presented with column fields that have more than one option available to choose from. For instance, if we look at the field for Net Profit, you'll notice a little arrow next to it. Clicking on that provides options for Net Profit, Net Profit (avg), Net Profit (max) and Net Profit (min). 

These can be understood as follows: 

1. Sum, e.g. Net Profit. This would be the total or sum for the defined period. In my example above, with one row per day, this would be the total Net Profit for each day. 
   
2. Average, e.g. Net Profit (avg). This would be the average for the defined period. In my example above, with one row per day, this would be the mean average Net Profit per order for each day. 
   
3. Max, e.g. Net Profit (max). This would be the largest value for the defined period. In my example above, with one row per day, this would be the order that had the highest Net Profit value for each day.
   
4. Min, e.g. Net Profit (min). This would be the smallest value for the defined period. In my example above, with one row per day, this would be the order that had the lowest Net Profit value for each day.

Clicking on any of these options will replace the original 'Net Profit' field selection with the one you chose, e.g. If i clicked Net Profit (min), it would appear like so: 

From there, I could drag it over to the left-hand side as normal to include on the report.

Bear in mind that if you have already included one of the options on the report, only the remaining options will be available from the dropdown like so: 

Removing Columns 

Step 1 - Simply follow the same procedure as Adding columns above, only in reverse. For example, if I want to remove Returns from this report, I would open up the columns popup again: 

Step 2 - And then drag Returns over to the right hand side. 

Once again, hit 'Ok' when you're done, and there you have it. That's all there is to it! 

For a more complete video version of this tutorial guide, check out our video series here.

• Related Articles

• How Do I Share a Link to a Report?

  Another entry in our 'Basics' series, this article will cover how to setup a Shared Link for a report in Report Toaster. Note - You must be on a paid plan of Report Toaster to have access to this feature. You can check out our app listing for more ...

• Premium Report - Cohort Reports

  Cohorts (By Revenue, By Customers, By Retention) Cohort reports are used to display data about repeat purchases by customers based on when they made their first purchase. Each row of the report represents a cohort of customers that made their first ...

• Premium Report - Sell Through Reports

  Sell Through Rate (By Product, By Variant, By Vendor) Sell Through Reports are used to compare how much of something has been sold vs how much you have in stock. These reports all follow a very similar format - tracking your Sell Through Rate on a ...

• What Do I Get In Report Toaster (that I don't get in Shopify?)

  What do I get out of Report Toaster that I don't get in Shopify? I already get reports in Shopify - why do I need Report Toaster? Why should I upgrade my Report Toaster Account? In fact, questions like this are so commonplace that we have an entire ...

• Premium Report - Stock Report

  Stock Reports Stock Reports are used to compare how much of something has been sold vs how much you have in stock at each of your different locations. These reports follow a similar format to the Sell Through Reports, but the available quantity ...