Best Of

I dataset with a list of "pulls" for each day and the "setter" associated with that pull. I have a calculation through the ETL for this dataset that sums up the total sales per setter for the previous 30 days. My objective is to count the number of distinct setters who have a sum of 0 total sales for the time range filtered on the card. How would I do this on a beast mode? I can't do this through ETL as I need this count to work dynamically based on the date range the user chooses for the card.

Ex:

If I were to look at the distinct number of setters for 9/30/22 the number would be 1 because Test User 1's sum of total sales in the last 30 days exceeds 0 and Test User 2's total is 0, so Test User 1 does not count in the setter count but Test User 2 does.

If I were to look at the distinct number of setters for 9/25/22 - 9/30/22 the total would be 0 as both test user's sum of total sales would exceed 0 for that time frame.

Is this calculation possible through a beastmode?

Shopify really just gives you the products & variants datasets last time I was in there...if your bundle relationships don't jump out at you from that you'll be pretty limited with what comes from Shopify. Unfortunately with all the bundling apps out there the storefront API doesn't have a uniform way of reporting on them.

Usually I see folks connecting to the bundle app (custom API) or a Google Sheets connection where they track all their product attributes (as well as build out kit/bundle lists). Join up the bill of materials from those kits against the orders and you can get an expanded set of products ordered based on the kit components. You could set the relative ratio of price (to multiple line items by the total amount) in the attributes sheet, or try to base it on a function of the compare_at price on each of the pieces.

The frequency that you're adding new products & kits would help you decide if you wanted to invest in a custom API (lots of product adds every week, no bandwidth or interest for offline tracking in Sheets) versus using a lookup in Sheets (very few product additions, already using Sheets to some degree for tracking kit composition)