-
Failed while executing with ENGINE-50500
Typically if a SQL transform fails I can find specifics within the execution history. Currently I am getting only "Failed while executing. An error with code ENGINE-50500 occurred." I do not believe I made any large changes that should cause me to be unable to execute my dataflow. Has anyone seen this? I searched this…
-
Normal distribution probability
Does Domo have anything similar to the norm.dist() function in excel or the probnorm() function in SAS? I'm looking to use it in a beastmode or calculated field within views explorer. norm.dist (excel) - https://support.microsoft.com/en-us/office/norm-dist-function-edb1cc14-a21c-4e53-839d-8082074c9f8d probnorm (sas) -…
-
Using Select Columns to reorder columns in Magic ETL
In Magic ETL, a Select Columns tile was inserted just prior to the Output Dataset tile in order to reorder columns. The columns in the resulting Output Dataset were not in the order specified in the Select Columns tile. Is there something else that needs to be considered so that the column order is retained in the Output…
-
Year to Date column on same card as monthly
I've been wrestling with this for several months and hope the Domo hive mind can help me out :) My team uses several graphs like the above for our monthly metrics. "Monthly PPM" is a calculation of col_1/col_2 *1000000. "YTD PPM" should be cumulative col_1 / cumulative col_2 * 1000000 with the year starting fresh in May.…
-
Calculate average time to accumulate to a value.
Consider a dataset like this: Person | Topic | Points | Date --------- | ------- | -------- | ------ John | Foo | 80 | 2020-09-10 John | Foo | 40 | 2020-09-12 John | Bar | 63 | 2020-09-14 Sally | Bar | 60 | 2020-09-16 Sally | Foo | 90 | 2020-09-16 Sally | Foo | 110 | 2020-09-18 Assuming the dataset is much larger with more…
-
putting excel data in Domo
Hi, Usually when I put excel data in Domo, I click 3 steps. 1.data 2. File 3.more upload methods But today, I try to put my excel file into domo instance, only white screen pop up after click "more upload methods" and I couldn't put my excel data to domo. Has there been any revision by uploading the excel file to Domo?…
-
Finding characters in a string and extracting the characters plus 4 more chars
We have a table that contains the Subject line of every email in our distribution list. I'm trying to extract our reference number and put it in another column. For now, our ref# starts with an 876 or 877 and it's 7 digits long. I used a CASE-WHEN-LIKE to identify the lines that contain 876 or 877 and minimize the lines I…
-
How can I get records from yesterday's 7am to today's 7am
Hi Can someone provide guidance on how I am able to extract records from a dataset based on a specific time set? I need to schedule a daily report that will show all records from 7 am Yesterday until Today 7 am and hope to use the 'TimeStamp' column to extract this information. Thanks
-
ETL - Get/Remove Values after First Space
Hi All, I am trying to separate the string's below to form two different columns. So my current column containing all the value is called 'Type' and i want to separate it to be two columns 'Medium' and 'Campaign' 'paid Car_Loans' should be 'paid' and 'Car Loans' 'callext Car Loans 2021' should be 'callext' and 'Car Loans…
-
Allowing DrillDowns on Pages/ dashboards
Excuse the category, on every browser it only allows me to choose 'DataFlows' - must be a temporary Domo website glitch. Hey all -- I'm a bit green here but how would you enable drilling down on the dashboard level? It seems to apply filters as the default behavior (aka select this element). It would be nice if a user…
-
Google Analytics Transaction ID failed to Parse
Hi all, I've read through the other replies on this topic, but none seem to help. I am attempting to join our CMS data with Google Analytics via 'Transaction ID'. When I do so, I continually receive the error message: Failed parse text '1234567890-loc' from column 'Transaction ID' as type 'Integer'. *sample number, not the…
-
How to setup Alert through SMS
Hello, Would Anyone know how can I setup Alert through SMS to someone's phone number? And question 2, the recipient of the Alert (as mentioned above through SMS) needs to have a Domo account or not necessary? Thank You antonis
-
DataFusion Colorblind
I am wondering if there is a way to activate a colorblind mode for DataFusion? Or is there a way to change the coloring or the dataset columns. I am not able to differentiate between the red and green ones.
-
Help with Replace Text Regex
Hi! Struggling to figure out how to replace this: { "value":"Email", "id":"13469" } with this: Email Any ideas?
-
Data Flow help
Hello, Experts, I am humbly reaching out for some help. I have a vendor sending a snapshot of a database table every day and not sending me diffs. I am trying to determine the diffs. The connector type is SFTP CSV. The file they send daily is overwritten daily. I currently have the data connector appending the data from…
-
Using Percentiles to Bucketize in Beast Mode Query
Hi All, I have a table with a text dimension (Name) and an associated measure (Score). I wish to do the following: Calculate if the Score for each Name is in the top 20th percentile of all entities (highest) If the Name is inside the 20th percentile, do not update the Name. If the name is outside of the 20th percentile,…
-
Grouping using two criteria / subgroups / subtotals
I have a dataset that works a bit like my first picture here: What I need is an output that looks something like this: By that, I mean that I don't simply want a total of how many drinks were sold overall by each person, or how many of each drink were sold (which I could do with the group function in Magic ETL). I need to…
-
Date Diff beast mode calculation with multiple variables
Hi, I am trying to write a beast mode that provides the number of days between when a file was received and when it was completed, if the file was received after the expiration date then date received is used to calculate the number of days, if the file was received before the expiration date then the expiration date is…
-
Magic ETL - Change column types and merge files
Hi, I am merging 7 data sets into one. I would like to change the column types on all 7 of the source files before merging into the output data set. 2 columns in each file are "text" columns, but I wish to change them to date type. Some of the data contains "n/a" as a string. When I ran a simple Set Column Type ETL on this…
-
Mitigating V2 - Federated source limitation in Magic ETL
Hi All, Not a support question but we are running into an issue and would like to get guidance on how others mitigated this issue. We have a Subscriber instance provisioned to one of our clients, who have created ETLs on top of the sources we had published to that instance. This was in Publish V1. Now with V2, Federated…
-
Extract Y-M-D from BATCH_LAST_RUN
Hi, I need to extract the year-month-day from the timezone column. The column BATCH_LAST_RUN has values like: `2021-06-24 07:15:04 AM UTC`, what I need is to convert the date to est zone and just have the values like: 2021-06-24 I tried: DATE_FORMAT(MAX(DATE_SUB(`_BATCH_LAST_RUN_`)), '%Y-%m-%d ')) Also, tried to apply…
-
How to extract Date from TimeStamp1, Time from TimeStamp2, and then combine the two?
So I have two fields, "DateV2" and "EventTime V2". I am trying to extract out the Date portion (2018-11-16) from "DateV2" and combining that with the Time portion (12:07:00) from "EventTime V2". I am trying to do this in Magic 2.0. Here is my beast mode/formula in the Formula Tile: DATE_FORMAT(CONCAT(DATE_FORMAT(`Date…
-
Share dataflow and dataset owned by me to other author in the same organisation
Is there any easy way to share everything so that the other authors can see my work? I need to click share each time for each dataflow or dataset or cards that I created. How can I work more collaboratively with other author in our instance so we know what's the progress from each other? Thanks Sherry
-
Are "Joins" case sensitive
As we all know, Salesforce record IDs are case-sensitive. Has anyone done a join on Record ID? Are joins case sensitive?
-
Creating Repayment Rate by Group
I want to create a chart that shows repayment rate by each customer segment Repayment Rate = Repayment/Outstanding I followed this topic (https://dojo.domo.com/discussion/comment/47384/#Comment_47384) because I found a similar solution there, however it didn't show how you'd do it if there's multiple groups you'd like to…
-
Google Ads
Hi Team, Does anyone know which connector I should use for google ads? Thanks, Yuvraj Chavan
-
New addition to Webform not flowing through all dataflows
I have a webform that houses in different columns site level details like store name, Region, and Site ID's across multiple sources. I use this to join with datasets so it makes it easy to filter for things like Region and Site's. I recently added a new site, and all the other details to this webform. if has flowed through…
-
Show last 12 months dynamically using beast mode calculation?
I wanted to show last 12 months from June 2020 - May 2021 dynamically using beast mode calculation. Any help is appreciated! Thanks in advance
-
Beast Mode to Add "Warning" for Data Point
I have the Beast Mode below for a card that reflects IsShortAbandon "Good" when <=.07, else "Bad". I want to add "if .06 - .069 then "Warning". I am struggling a bit with the logic and appreciate in advance any assistance. Thanks Michael
-
Append a dataset without using recursive design
Is there any other way to append to a dataset without using a recursive design in Magic ETL?