-
Optimizing Domo Dataflows
* If you are struggling with long run times * Join big datasets at Domo Fusion speed and use them in ETL * Consistent failure of ETL after mulitple hours * Want to work on a subset of a big dataset * Create Views in Domo
-
PDP Util - the effects of the different delete_options in the config dataset
Config and Data Datasets before running the PDP Util For this I am using a Domo Webform dataset, which works like a Google Worksheet - i.e. you can edit the data without needing to re-upload a new dataset, which resets the dataset ID. See attached Word file for a better copy of the screenshots. After run 1: * Duplicated…
-
PDP Util - How to reset instance and/or token
This article relates to the PDP Policy Autocreation java tool. See KB article: https://knowledge.domo.com/Connect/Personalized_Data_Permissions_(PDP)/PDP_Policy_Autocreation There are multiple reasons why you may need to reset the configuration of the tool, including repointing to another instance or resetting the the…
-
SQL Transform for Customers With No Invoice Dated 2 Years Prior to Current Year
I have developed an ETL dataflow that outputs our gross margins per job. I have then used this dataflow to create cards that show total gross margins by customer. What I am looking for is to start from this exact same ETL flow but output only customers that have not had invoices in the 2 years prior to current year - so…
-
Multiple filters in Deep Linking with Filters
Hoping there is a syntax error here a fresh set of eyes can find. Deep linking with filters from one story dashboard to another. Using one column works perfectly. adding a 2nd isn't working - error "a problem has occured while loading page filters. if the problem persists contact domo support" (which I did, but unsure if…
-
Dynamic Date Field with Over Function and Balance Forward Question
Please see the attached video to better explain what we are trying to accomplish. https://youtu.be/jOZmhUea6KE. Beast Mode Used: SUM(SUM((CASE WHEN `PERIOD` = '2016-01-01' THEN (`Beg Balance`+`AMOUNT`) ELSE `AMOUNT` END) ) ) OVER(ORDER BY `PERIOD`) We currently have a balance sheet account where we are trying to calculate…
-
Merging Legacy and New POS Dataset
Hello, Experts! I am reaching out in hopes that I get some guidance on the best approach for building out an ETL. Our company is undergoing a point of sale transition and things are going well. We currently have legacy data in one dataset and new data flowing into Domo separately. My CEO is wanting to see week by week…
-
Append Issues (Not matching & not appending)
We have two Append issues which cropped up this week that I'm wondering if other people have run into. It's worth noting that WoW, our process and dataflow *didn't change* which makes this especially baffling. Not Matching Columns We upload an excel sheet via the file upload connector using the append method. This week,…
-
Case Statement Using Beast Mode Calculations
I need to create a card with one out of two solutions: * one chart that allows me to stack other beast mode calucations on top of one another, resembling a table; or * two very elaborate CASE statements that group together a dimension and measure of 17 categories. The former does not seem to exist, so it seems I'll have to…
-
ETL: Character Count
ETL: how do I count characters in a string (akin to char_length in mysql)? EX: ABC => Count = 3 ABCD => Count = 4
-
How do I count characters in a string in Domo ETL
ETL: How do I count characters in a string(akin to char_length in mysql)? Ex: ABC => Count = 3 ABCDE => Count = 5
-
Need to see a value by week with current year next to previous year in a Table Card
Hi, I am trying to rebuild Tableau Dashboards in DOMO and I am running into a lot of trouble dealing with dates. Some of the issues I have been able to figure out, but this one has me stumped and none of the available related advice seems to work for me in the SQL Transform component: Using 3 fields: 'date', 'line', and…
-
Calculating Weeks on Hand for an item based on subsequent weeks of forecast
Hi, I have the following dataset: Item Date Projected Inventory(PE) Forecast(FC) A Jan 28, 2019 604 50 A Feb 04, 2019 630 52 A Feb 11, 2019 500 49 A Feb 18, 2019 450 46 A Feb 25, 2019 1176 51 A Mar 04, 2019 1136 55 A Mar 11, 2019 1083 53 A Mar 18, 2019 1030 53 A Mar 25, 2019 980 50 A Apr 01, 2019 900 65 A Apr 08, 2019 853…