-
Null Date Values in Card Filters
Hi! I know this question has been asked a few times in the forums over the years (see "Best Practice for Date fields" and "How do you Filter on Date that is Null") so apologies for the redundancy. I'm asking the question again because these posts seem to miss an element that is crucial to my use case: calculations and…
-
Dataflow failed
Hello all, I get the below error after running my dataflow. As this consists for multiple inputs, I haven't still been able to trace the exact field causing it. But I do have a formula tile with this calculation.. " Failed to convert value '-3--3-01' from type 'String' to type 'Date'. " Some days this data flow runs…
-
Dataflow Search Screen - Show # of Tiles
It would be cool if when searching for dataflows that screen could show # of tiles in the dataflow.
-
How do I take a portion of a column value and push it to a new column?
I have a column for campaign names that looks roughly like this A1234567| Campaign 1 | Google Ads | …… What I need to be able to do is read/grab all the non-space characters before the pipe and put that value in a new column called Campaign ID. In the case above, the new column for Campaign ID would contain A1234567. If…
-
How to exclude/filter out based on 2 dates
Hello Domo! I uploaded a file/table in DOMO, that has a wipe date and a forecast date. What I was hoping to do is, to use this table and join it in my dataset, so that I can use it to filter out everything within the wipe date and forecast date. Is this possible? I am having problems with joining it to my dataset.
-
Dataflow or View Query to run AFTER user filter pages
Sometimes it can be really difficult to build an end dataset that will be able to calculate the metrics that my users care about on the fly in a beastmode. For example: This contains 3 different fixed functions so that I can show a certain metric dynamically to the user. Because of the high computation (mixed with a big…
-
Wildcard for numbers not characters in Beast Mode or Magic ETL?
I'm trying to create a new column based on the prefix of another column, but the prefix B### is categorized as type B, and prefixes BC and BW are categorized as another type H. E.g. Col_ori Col_new B001 B BC002 H BW001 H The wildcard % (i.e. using LIKE 'B%') will include all prefixes starting with B. How can I distinguish…
-
Colorize Column Headers in MagicETL Previews based on Connecting Line Color
With complex flows, it can sometimes be difficult to know what column came from what connecting source. It would be nice if MagicETL colorized column headers based on the connected line colors when in preview mode. As you can see in my beautiful artwork below (🤣), note the task I highlighted in yellow. That is the task I…
-
UUID / GUID Functions in Rank and Window
There are times where I may need to generate a unique ID so I can tie related batches of records together under said ID without worrying much about collisions with another group of related records in the same dataset. This will also allow me to treat them as a partition key if I want to target a handful of records for…
-
Ability to save and easily reuse commonly used strings of logic within MagicETL/SQL
It would be really nice, when creating or editing a Magic ETL, to be able to easily reuse sequences of logic that could be easily adapted to any environment. Recursive append loops Rank and filter Split column and dynamic pivot The option to select which saved item you want to use would appear in the Magic ETL edit menu on…
-
Domo ETL parallel processing to reduce ETL runtime
Hello, I have a python script which is part of an ETL to transform a combination of 3 input datasets. The python script contains multiple if else statements and for loops which is taking aroung 4 hours to complete the ETL pipeline. I want to know if there is an option to parallelize the python script in Magic ETL to reduce…
-
Data transformation ideas around old/new user data
HI, we're migrating from username sign in, to okta that uses email as user id. we have an existing user info data with user id as username (xfsgsbss) but we would have a new data with user id as email(fdhsvbsjsbsjsh@email.com). I want to be able to join both old and new data and make sure the right attributes goes to them,…
-
How to create a rate by specific selection criteria in Domo
Hello again community. So I work within a healthcare organization and I have a domo grouped/stacked bar graph built currently from an etl that has columns regarding patients readmission start date, account number, discharge date and attending providers(previous admission). The card breaks down the readmit percentage rate…
-
Using Magic ETL to extract a substring using Regex and excluding remaining strings
Hello! I know variations of this question have been asked in the forums but I haven't been able to find a solution that works for me. I have a column Project Name that contains Projects out of Financial Force that may contain an At-Risk ticket number, which is formatted as: AR-00000 i.e. literally "AR-" or "AR - " followed…
-
More info in logs
It would be very useful if, when executing a Domo ETL, a log file was generated to see the details of potential failures in the process. Currently, if there is a failure in any of the Domo's own boxes, you see that the process has been interrupted in a part of the process but we don't see the details. Also, if the process…
-
Saving States
Is there a way to save data and possibly append to it? Let me give an example. When I pull data from a database, I would like to pull data and when I pull data tomorrow I want the original data to still be there. So I want to be able to see user counts by region today, and then in a month I would still like to see what it…
-
Joinin on Email
I have 2 contact databases where I need to join them based on both phone number, name, and email. I am able to currently join on phone but the email part I am having an issue with. When trying to join on email it isn't working. What is the best way to join on email address and if possible where emails closely match?
-
Split Column by Number of Characters
Can we add an option to split a column by the number of characters in the field? I.e. split column by number of characters as far left or as far right. This is a very useful feature in PBI Power Query Editor especially when you have strange date formats like 1231201 or concatenated fields with an order number of a specific…
-
Rank Tile Not Grouping, Needs Case Sensitive box
I am using the Rank tile, ordering on a Timestamp and the column that makes up a partition is Customer. For example, I have "CUSTOMER A" and "Customer A." These are in the raw data and represent different clients, but the Rank is treating them as the same. I will probably value map one of variations to be unique, and I'll…
-
Rank and Window? Lag?
So I have a dataset that captures quarterly expense data. I have been tasked with adding an 'expense ratio change column' Basically, I need to know the % change of expenses changed from quarter to quarter by project I know the math on this ((p2 - p1) / (p1)) but am not sure how to tile it in domo to make sure it is taking…
-
How to mix and match Data
Number City 1000 A 1100 B 1200 C 1300 D E 1400 1500 F 1300 Hi Folks, Need your help pls. 2 Questions - 1) In the table above, you could see that 1300 is mapped to city 'D' but in last row it is blank. How do I map it using beast mode or Magic ETL to fill by Lookup in the same column. Req: Lookup in 'Number' and fill Blanks…
-
Does a slicer work even if I'm using a sub dataset?
Hello. Hope someone can enlighten me or help me if there's a solution for this: I need to use one slicer for my dashboard, which contains like 16 cards. The slicer should be able to filter all cards in that dashboard. Here's my problem: I'm using three datasets for the cards in the dashboard: Main Dataset - let's name this…
-
Is there a way to duplicate a value one row down?
I have a column with a numeric value and null value every other cell. I want to replace the null cells with the numeric value that is directly above it. Thanks in advance!
-
Weighted Average Calculation
Hi, I'm working with a dataset and am wanting to make sure I am going to get a weighted average of our mortgage rates. We have loans that range from 100k-400k and each loan has an associated mortgage rate. As an example, we have two loans that go into the same security that are 5% and 5.5% Loan A is worth 200k and loan B…
-
Where can I find the Description when you save a dataflow
I would like to create a card showing the changes to dataflows and the description. I have looked in domo stats and also domo governance and dont see it. I am looking for the comment you add before you save. Not the description of the dataflow that you put along with the title.
-
Add Notes and Titled Containers to ETLs
I find that my ETLs are often big, with multiple endpoints; so when I come back it takes me some time to catch up with what I did. I think that adding some text notes to the ETL view would make it easier to evaluate what I, or one of my coworkers, have done. As for titled containers, they would allow a user to draw a…
-
Combine tables using ETL inner join
Hi everyone, I'm trying to combine two federated tables using the inner join in Magic ETL. Both tables have over 9.5M rows but when I join them, the result is only 87K. I tested the join in Snowflake and it resulted in 9.5M by the logic: SELECT * FROM 'A' INNER JOIN 'B' ON A.X = B.X What could i be doing wrong? *I'll need…