Best Of
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
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.
Ashleigh
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
Re: How do I get my subtotal and total rows in Table card to show the avg of % rather than the sum of %?
@lb1234 In that case, I recommend using an ETL to aggregate the data by team first so that you have a columns in your dataset for team, count of create date (numerator), and team goal (denominator). Then you can set up a beast mode in your card to calculate the percent of goal, like below:
sum(`Count of Create Date`) / sum(`Team Goal`)
Re: Compare two peer groups
@GrantSmith thanks for your reply. I did look into this but it doesn't seem to solve the business problem.
Variables appear to be extremely useful if I need to pick a number or a date, however when it comes to strings they appear to be extremely limited. Very powerful if I want to build a button that says pick units or dollars figures, far less useful and highly manual if I have 1000+ campaigns that are named different things, it appears to only offer the ability to 'hand key' a few custom selections on strings rather than being able to filter on the same field two different ways.
I also looked at FIXED functions but they would not be helpful here, because while it allows for filter removal and adding, it's 'all or nothing' logic so I can't compare two samples of a field filtered two different ways. For example I can compare Texas vs the United States, but I cannot compare 'Texas and Oklahoma' vs 'Florida and Georgia'.
This is turning into quite the head scratcher.
G_Grey
Re: Mass Disablement of Data Flows (Data Management)
You can multi-select dataflows from the Dataflows tab in the Data Center and then disable all selected dataflows at once, which is definitely quicker than doing them one by one, but I assume you would like to do it in greater bulk than that, correct?
There's not a published API for disabling dataflows, but you can sniff out the API by performing the action while watching the Network tab in Developer Tools (that's where it's located in Chrome - might be called something else in another browser). You can then write a script to iterate through a file of dataflow IDs (and whatever other pieces of info are part of the API call, I'm assuming dataflow ID is one required piece). Since those APIs are not published I wouldn't recommend creating long-term, ongoing processes based on them (they might change and there wouldn't be a way for you to know), but I've had success using them to avoid manual work for ad hoc tasks (like one-time cleanups). I've never used the API for disabling dataflows, but I've used APIs for other data center tasks with success (like sharing datasets).
NOAA Connector
I saw some people using the NOAA connector data at DP18. I got the token to activate the connector, but I am having a hard time understanding how to get weather data out of it. Does anyone know of any resources that I can use to understand this connector?
There are 2 things I would like to pull into Domo so I can ETL it with our daily visit data. I want to know historical weather and the 7 day forecast.
Thank you,
Jason
JaBo1256
Re: Line Chart with Weekends Denoted
There isn’t a way to switch the color on a single line however I’ve used two lines with the same values and a beast mode to conditionally display certain values. You’d use your metric as the weekday which would display the weekend and weekdays.
CASE WHEN WEEKDAY(`Date`) IN (1,7) then `Metric` END
you’ll have to play around with the order in which they’re listed as values in your chart but it would allow you to have a “line” that alternates colors. Just set the color on your metric as the color for the weekday and the beast mode color as your weekend color
Re: How to grant permission for a user to access an ETL dataflow?
@GrantSmith Did your idea for this in the exchange get deleted? I tried to click on it and upvote, but the link is dead.
Hoping Domo is still working on implementing something to address this issue as we are in a growing world of collaboration including ETL's!
I don't want to give our users admin rights or super user privileges to edit all ETL's -- I just want them to be able to share access to their ETL's to their other team members so they can work on them / review them together.
PacoTaco