-
Create Month End Date column with Year & Month columns?
My dataset has a Year & Month columns, I would like to add a 'Month End Date' Date column into this dataset with magic ETL. But each month has different end date so I'm not sure how to go on about this
-
What is the best why to change the format of data in a cell?
I have a data set that brings in names under the column BDM Name with FY 2024 at the end of the name, see below screenshot. What is the best way to remove the "FY2024?" I have about 8 BDM names I need to change. Should I use a replace text tile in ETL?
-
Save AS ETL not functioning properly?
Hi, I am running into a weird issue. In most cases you can use "Save As" to make adjusted copies of a card or dashboard without changing the original. However, that's not working for ETLs for me. Instead of having a separate ETL, it keeps sending me back into the original. I'm just trying to apply the same name mapping as…
-
How get and combined column from another dataset using magicETL
Dataset A columns: Name, Bday, Age, Gender, City Address, Country Dataset B columns: Name, Position, Salary, Company columns I only want and will name as DatasetC: Name, Bday, Age, Position, Salary I am thinking if I can just use Dataset B, save as Dataset C and add columns (Name, Bday, Age) from Dataset A. But I don't…
-
How to find the owners of the Beast Modes?
Hi, I am trying to build a card that shows the broken beast mode by owner name, but can't find the owner name. I tried to link the 'DOMO Governance - Beast Modes' data set with the 'activity user' dataset which gives me the owners of the card, page, and even dataset, but how do I find the owner of the dataset? Any help…
-
Converting a duration time text field into a number
I have a field from NetSuite called duration, which is a measure of time in this format 8:30 This stands for 8 hours and 30 minutes of work time. I need to convert it from a text to a number so I can create measure. Thank you! Jayme K.
-
Issue in total/subtotal of the pivot
SEC_TO_TIME(SUM((End Time - Start Time)) - 3600) I am using the above calculation to get the employees who has exceeded their break by 1 hour. it is working fine in normal condition but when i put this into pivot and checking the subtotal / total, it is just subtracting 1 hour from the total which is wrong. it should just…
-
COLUMN to add as ROW.
Our database looks like this: We have separate columns for TransactionType, new_policy and renewal_policy. So when we build the card, the New policy and Renewal Policy won't come under the Transaction type, which we want to visualize like this: Question, How can I add/merge "new_policy_count" and "renewal_policy_count"…
-
Convert to timestamp
Hi, I have a process_timestamp column with string values like this: 2024-09-17T14:47:41. I am trying to convert it from a string to a timestamp in the format 2024-09-17 14:47:41. I used the formulas below in my ETL, but they are not working, and I get this error message "failed to convert value from type string to type…
-
Group By and Drill down
Hi, I am new user of DOMO and need help building this report: I have a data with columns: Name, Age, Birthday, Position, Email, Salary. For initial screen I want a filter channel by Name, Age and birthday. Then allow user to drill down into each Name for Position, Email, Salary details. Thank you!