-
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…
-
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…
-
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!
-
Validating datasets that has different formats
I need to validate 2 finance datasets to ensure the numbers match for all GL accounts. Dataset A: Columns: Account_name, Branch_id, MTD, MTD Budget, MTD Last Year, YTD, YTD Budget, YTD Last Year. This dataset is generated monthly from the ERP system, with pre-calculated values. I need to append it each month after adding…
-
Unique calculation
I have an issue where there is a campaign "Campaign 1" that needs to be split out into 3 parts; NHL, NBA, and NCAAF. NHL will get 40% of the impressions, NBA will get 40%, and NCAAF will get 20%. I cannot figure out how to break this into 3 parts and calculate the impressions. I have multiple other campaigns that I can…