Add "total_order_value" field to BrewwQL for Customers

[luke]

Thanks for the suggestion, Mark.

I’m afraid this isn’t possible right now, but this is the right place to be requesting it

@mark-kelly

… Customer who’s orders total between 500-100, 250-500 and so on.

It should be possible to add a field to the BrewwQL filter for the customer’s total order value.

@mark-kelly

Basically I’d like the list to take customers that ordered £1000+ for March 2023.

To support this, it would be a very substantial change, so in all honestly, I think this isn’t something that’s likely to be added to BrewwQL in the short term. The issue is that each of the variables that you can filter on are evaluated independently, so while we could add a the total order value field, this would always be treated as a total order value and not just the total in any given month. I’ve explained this in more detail in this thread:

Breww QL & 'within range' query

I’m just after a bit of help with a Breww QL query - I am trying to create a dynamic customer list using an average value within a period, but can’t seem to figure it out. Using a combination of Number of Orders, Average Spend & Last Order narrows the range, but still picks up outliers. This is the part of the query that I’m struggling with: or (type != "Distributor" and (average_order_value >= "X" and number_of_invoiced_orders >= "X" and last_order_date > "X months ago")) Ideally we are loo…

I hope this makes sense. We’ll keep the feature request thread open, as hopefully we’ll be able to support this better in the future, but it’s a long way from how the filtering works at the moment. Thank you.