Best Of
New Customers/
Hello,
I'm working on visualizations that aim to show new customers within years. My database contains data from 2020 moving forward. I want to see new/unique customers that bought from us for the first team this year. If it is possibly want to compare it to 2021 too but struggle to filter that out or write a beast mode. Any recommendations? Was thinking of something like
(CASE
WHEN 'firstorder' date (that's the place where I don't know how to write it) > '01.01.2022' THEN 'New Customer 2022'
WHEN 'firstorder' date <'12.31.2021' AND 'firstorder' date '01.01.2021' THEN 'New Customer 2022'
ELSE 'old customer'
END
)
Any ideas how to handle that?
zuchu
How to count distinct based on the sum of another column?
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?
lb1234
Domo Simple API - Insert null value using json
It seems Simple API does not accept null value in json format. How can I insert null in a column using API? I tried "" and it works but this recognizes the column as string, if I need a int column or date column, this approach it's not what I'm looking for. Thanks!
Re: Trying to Count the number of Appointments in my data
@mhouston Bingo. Using AND not OR, and using an equal instead of like both fixed the issue and corrected the count. Thank you both @Billobi and @mhouston for helping!
Cwal
Re: Breaking down bundles into individual items
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)
Billobi