-
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…
-
Group By Issue
I need assistance with identifying transactions that net out to zero in a large dataset. Each row in the dataset represents a unique transaction with its own ID. Objective: Identify pairs of transactions that meet the following conditions: Same client ID Same transaction type ID Same transaction date The sum of their…
-
String to Date
Hi I'm trying to convert a string to a date where the string shows "day Month", ie "30 Aug" or "23 Jul" (double quotes not included in the string). The string to date statement doesn't seem to work. Any ideas? Thx John
-
Pulling the First Saturday of the previous 6 months
Hello, i'm trying to create an ETL filter formula that will pull the first Saturday of each month going back six months, but keep hitting errors. I've tried utilizing date_truncs with dayofweeks but no dice yet. Any assistance would be much appreciated!