To GoodData homepage

Topics started by Ashleigh

1 Topic

A
AshleighNew Participant
asked in Metrics and MAQL

Difficulty creating new MAQL metric based on Customer Segment

Hi,I have a dataset containing sale orders, which includes:Order Date - Date the order was placed Customer ID - Unique ID for each customer Order ID - Unique ID for each order Customer Type - ‘New’ if it’s the first order placed by the customer, ‘Repeat’ for all subsequent orders £ Amount - Total order amount in GBPWe would like to introduce a Customer Segment, which is dependent on the reporting period (week/month/year) and is defined as:‘New’ if the customer placed their first order within the reporting period (regardless of whether they also placed repeat orders within the reporting period) ‘Existing’ if the customer placed their first order before the reporting periodI want to create a metric ‘£ New Customer Sales Monthly’ which is the SUM of the sale order amounts (£ Amount) for New customers each month.Note - if the customer places their first order in a given month and places repeat orders within that same month, then all of those sale order amounts should be included in the ‘£

3
A
3 years ago
Welcome to the GoodData Community!Cookie settings