-
Seeking Visibility to Scheduled Report Recipients
I am seeking a way within Domo as an admin to see all of our scheduled report recipients within a single dataset. Anyone know how to do that?
-
Troubleshooting on Dynamic SQL in MySQL
Hello, I am working on to create dynamic sql in MySQL. Bottom line for my query is, I would like to create column for each question and display answer associated with it in row for each application. This query is keep giving me an error. Can someone look into this and make some suggestion? Also, is there a way where we can…
-
Need help converting a MS SQL Query
Hello everyone, I am trying to move one of my SQL queries to Domo. I was able to move the query but I got slightly different results. I will attach the original query and the query I used to create the sql dataflow. Did I make a mistake with the dates in the query while moving the query to Domo? SQL Query select distinct…
-
Looking up values from secondary data source for multiple columns
So I'm having some trouble wrapping my head around a solution for this scenario in Magic ETL: -I have a primary data source with multiple columns where values are stored in shorthand like "hc_res" but I want to display reports with pretty names like "Healthcare Resources". The mapping of "hc_res" to "Healthcare Resource"…
-
Replacing Values in Multiple Columns Based on a Lookup Table
So here's a challenge I can't seem to figure out how to solve in Magic ETL. I have a primary data source that has values written out as "tags" like "hc_res" and a secondary data source that maps those tables to pretty display names like "Healthcare Resources," which is what I need to display in reports. Normally, I'd just…
-
Indexing Magic ETL vs Adrenaline
Hi a quick question Does Magic ETL delegate the Indexing to adrenaline. if it does would it be more efficient if the dataflow was in Magic ETL or Adrenaline. if you have a big dataset im assuming the SF layer will need to transfer from one engine to another ?
-
Magic ETL - copy/paste JSON definition to clipboard
During the Technical User Group kickoff call, @john_stevens dropped some knowledge on us that just blew my mind. As seen in the gif below, you can copy Magic ETL tiles to the clipboard, and then paste into a text editor and it will give you the JSON definition of those tiles. That definition file can then be edited and…
-
Number Format issues at dashboard/instance level
Hello, even if I am a Domo user since a bit of time, I keep finding extremely tricky the setting of number format. For example we would like to set the number format with "." for thousands and "," for decimals everywhere in a Domo instance (chart, kpi, summary numbers, hover text, tooltips, tables etc...) and so far it was…
-
Recreate 2 Excel Formulas in DOMO (table provided)
Can anyone match the exact results from the formulas in my excel spreadsheet? The Contribution: Is based off Rank Effort: is based off Contribution Formulas in Excel include: Contribution: =SUM(A$2:A2)/SUM(A:A) Effort = =F2/MAX(F:F) The results need to be identical to the attached file.
-
Common Beast Mode & ETL Questions
Once you are logged into the Help Center, you can move seamlessly between Domo University Training, Knowledge Base, Community and Support (using the head navigation menu) . Knowledge Base articles are a great resource to answer many general questions. KB articles answering the most common Beast Mode/ETL questions: * Beast…
-
Recent and slight behavior change in ETL - heads up
This may have been mentioned already and I have missed it, but if you do recursive dataflows or any dataflow in Magic ETL where you are bringing in the output as the input...in the past the 2nd iteration of that dataset would get the 1 appended to it at the end of the name. Now the reverse occurs and the original get the 1…
-
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…