-
How do I group by a integer but take into account both instances of the integer?
My company has a demographic table like the one below where we keep true or false info on borrowers. When the loan has two borrowers, we create the same loan id twice in our system. I am working to create a minority table but I have to take into account BOTH borrowers. If either row (1,1 - 3,3 in this case) has a true in…
-
Data imputation
Hello, I'm working with a large dataset that needs some data imputation and got some questions around it. I want to filter my data based on location but a small amount of the dataset is null there. Luckily, it is sales order data, so the same SO has many orders to it and SOME of them are lacking the location information.…
-
Breaking down bundles into individual items
Hello Everyone, I am currently pulling in sales data from shopify. We have a core range of about 20 products and another 20 or so bundles which are made up of those core products. I am hoping for some assistance with how to break down these bundles into its components (core products) as we would love to see how the core…
-
Joining only where Unique ID matches
I have 2 data sets. Data Set A and Data Set B. Data Set A. Has 6k rows of data and about 50 columns, and it has a unique column ID That can be matched a Unique ID within in Set B. Data Set B. Has 20k rows of data and about 30 columns, this also has a unique column ID. The Unique Column ID will match up on about 1000…
-
how to split up column based on string of charecters
I want to separate out the SKU that is at the end of a url... how can I do this with the following, where anything following "-sku-" is separated out into a new column? I tried using the split columns function and using -sku- as the custom delimitator, but it isn't working.…
-
removing last 5 characters of a value
How can I remove the last 5 characters of a text value in ETL?
-
How to look at multiple strings in one column
Hi, created a Case like below: case when `All File Dates` >= `EncounterDate` then 'Probable' else 'Obtain Op Note' end This doesn't work to full capacity because the dates in the "All File Dates" column are in no real order. See below highlighted row. The output for Op note on file should say 'Probable' because the…
-
Count function on a column to get total for two areas
I am trying to do a function to give me two number totals for locations by product line. The item number is a sublevel of the product line and I want to see how many of: for example 'Electric Cooktops' are in the red section and how many are in the green section. It might be an aggregation problem but the rank and window/…
-
Default Values for a column
Hi DOMO Community, I want to put a column on a dataset that defaults to 0. That column will be updated by a python script to 1. But on new data rows being added, it still defaults to 0 without overwriting the 1 rows Note that this will be in Magic ETL
-
Split varying full names into First Name, Middle Name, and Last Name
Hi there, Back with another question. I have a Full Name column in varying format: Alex McCandless Alexander David Thoreau Bobby Del Rio Cameron Diaz Camilo Carter Dave O'Donald Jack E. Topez ... and I need to parse this into three columns: First Name - the first word of the string, seems easily accomplished with the split…
-
Month Snapshot
I'd like to build a recursive dataflow, but capture data by month. Any idea how this can be solved?
-
Can you use _Batch_Last_Run_ as the date for a recursive dataflow?
Have a dataset that doesn't have a timestamp that is being imported via connector. Can I use the batch_last_run as the date to create the recursive dataflow?
-
How to Make a Weekly date range into a Daily Date?
Hello Domo Dojo Masters - Good Day! We have data from salesforce that only has a start of the week and end of the week date columns>>> How can I make it so that we can have a daily date?
-
How to get last date
Hi, I am new here! I have a dataset that has data on multiple rows for the same patient with different encounter dates. I want to only see the unique patient once (so patient ID is the identifier) and show me only the most recent encounter date. Example data: John Doe, Patient ID 1, encounter date 1/3/2022 John Doe,…
-
Fixed Date comparison
Hi, I have monthly data and have the data stacked with different period types i. Last year, 2021, 2020 and 2019. I can access these values by checking the period type in my beast modes. All good. For this use case I need to add a fixed 2019. So when I graph say 2021 through to 2023 each month looks back at 2019. e.g. I can…
-
Magic ETL hydrating error
Hello, Wondering if anyone has encountered an error like this before and know what it means? (other than that the action is thirsty)
-
Calculating Headcount based on Labor Hour Report
I am trying to get a HC for each department from our labor hour reporting data. I was going to use a count function by employee name to be able to pull the number of workers for each department. The challenge is for example: Date Employee Department 10/12 Jon Fabrication 10/13 Jon Fabrication How would I eliminate the…
-
Return most recent row/date
Good morning. Been running down the rabbit hole for a day or two on this and trying different solutions from previous Domo questions without much success. I have a sheet that has multiple entries for each equipment number and in the end I would like one row for each piece of equipment that is the most recent EVENTTIME.…
-
Domo isn't loading my excel files
Hi everyone, can anyone give any tips for loading an excel file with approximately 250,000 rows of data (some files about 60K KB, i've uploaded larger file sizes before)? It's to a dataset that is set to append but every time I upload it and click "save", and it imports, I go to check via Explorer view and I dont see the…
-
lag function
Hi everyone, We have a dataset containing two columns Date, Id and Value. We are using the lag function to get the value from the previous financial year. i.e. lag(Date, 364) over (partition by Id order by Date) Wondering how we could use this to get the previous date the year before but matching on the date. So 1st Feb…
-
Beginner - managing a wide table, creating sum of..
Hi there, newbie here. I have a wide table with a column format a bit like this: name, question1, OPP1, EXP1, ACH1, question2, OPP2, EXP2, ACH2 I will need to make calculations for each row on the values (integers) grouped by OPP, EXP, ACH. I thought to create new columns with the sum of OPPx, EXPx and ACHx (where x…
-
How to make my BeastMode dynamic
Hello DOMO Dojo - I have a beast mode that deals with dates, I am wondering if there is a way to make the date dynamic Here's my formula>>>> (case when (`TC: Created Date` >= '10/1/2025'and`TC: Created Date` < '1/1/2026') and (`TC: End Date`>= '7/1/2025'and`TC: End Date`<= '9/30/2025') then 'Q4 2025' when (`TC: Created…
-
How to compare different lines against each other for complex filtering?
Hi, I've joined two sets of data and the second set of data has Numbers that match the first set of data in some cases and in some cases there were corrections made. When I do the join, 2 line items become 4, because in many cases I'm duplicating data and need to filter it out, but in some cases like the below it wasn't…
-
Flow for dates
I have the following table: Id Service Start Stop 12 Mobile Jan May 13 TV Feb Sep what I want to do is reshape for a line chart to have counts of accounts for active services: id date service 12 feb mobile 12 march mobile 12 Apr mobile 12 May mobile 13 Feb tv etc…
-
Fiscal Year Beast Mode
Hi all, I am trying to create a filter on the dashboard for us to be able to filter by fiscal year The problem I am running into is that we have already contacted Domo about giving us the fiscal year option so all of the cards below this filter are already in fiscal year. The filter above is not. I have a simple beast mode…
-
How to solve this problem in Magic ETL - Link items to Header rows
Hi All, Currently we have a dataset which have records in this format: First row is the header record and next three rows are items of the this. but there is no link. I have ranked the dataset and the used a Lag function to join the header and item. Then I have performed the self-join to get Header information to First…
-
How could I generate an end date for each row of data based on the start date of another row?
I have a dataset that gives all records for all evaluations submitted. I need to generate an additional column in the dataset that records the summary_end_date. The start date of an evaluation is the value in the row for the summary_date column. The summary_end_date needs to be the summary_date of the next iterative…
-
How do I change the field type for a column on an existing table?
My company recently released a new version of our online platform and I am mapping its new database fields to my already existing Domo reporting tables. In the previous system we used a simple integer as the primary key for all of our tables. In the new version we have switched to UUID values for many of our tables.…
-
Data Flow Help
Ok this one is going to be a long one. My company keeps track of loans on an excel sheet. We are trying to migrate that excel sheet into a dataflow onto domo. There are a lot of different data sources we pull from to create this spread sheet but I am trying to bring together and formulate an ETL from just two sources right…
-
Magic ETL or Beast Mode?
Hey everyone, I'm using data that basically needs an (=if) statement like we were going to be using excel-- We have two columns called current income and qualified income. The 'income' column needs to populate with 'current income' if another column, called 'instrument' reads 'first home' otherwise, we need to use…