Best Of
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!

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)

Re: Trying to get card that shows the row count that is shown in the data warehouse
@apritchett & @Billobi Note that the Domo Governance datasets only allow once/day scheduling, so if you are running the Governance dataset overnight for example it would not capture any rows that have been added throughout the day
Re: Card Status Data in DomoStats or DomoGovernance
I agree! Many times a card gets broken from column name changes and we have no way of knowing until someone points it out to us.

Re: How to use variables for time comparison?
This example was deployed to the domo-dojo instance for reference. https://domo-dojo.domo.com/page/1880852133
If you need access you can refer to https://dojo.domo.com/main/discussion/55204/access-to-domo-dojo-instance