19. Get Accounts that have an average Order size of more than 50 euro

note the scenario below uses data from the deselect demo data package see docid 5 cozdtg0nwmlmeufrmbz note the scenario below uses data from the deselect demo data package scenario you want to get the company name of all accounts that have an average order size of more than 50 euro note this scenario uses feature formula's in subqueries, which is available in deselect plus and advanced 1\ input on the selections overview screen, click on new to create a new selection drag data extension deselect demo accounts to the selected data extensions section drag field id to the filters section choose criteria in results from the dropdown select data extensıon deselect demo orders choose field accountid now we have indicated we want to get the accounts whose id appears in the orders data extension however, we want to filter only the accounts with an average order size above 50 euros click on the fx button on the created filter on the added line select average as the formula select field total amount from the available fields dropdown choose criteria at least fill in 50 as the value we will now be filtering based on the average of the amounts of the orders; this has to be 50 or more 2\ output hit the create data extension button, enter a name, eg accounts with larger average orders, and press save select the following fields by either double clicking on them or dragging them to the section on the right company name from deselect demo accounts click save data extension 3\ preview when you click run preview on the preview screen, a results table will be shown with field company name from deselect demo accounts the results table shows only accounts that have an average order size of more than 50 euro