-
Replacing nulls when adding across columns
I have a table which contains null values, and I want to get a dynamic (i.e. it responds to filters - therefore has to be done in beast mode, as I understand) total of values across three columns, keeping null values in the orignal columns but treating them as '0's for the purpose of the calculation. I have tried several…
-
Is there a way to limit the number of input records on the ETL dataflow ?
I have 10 GB of data and I want to run a python script on that. But I am getting Out of memory issue because of the size of data. I want to limit the number of records from the input dataset. How to do it? Thanks in advance for suggestions and solutions.
-
Beast Mode Formula Error: This calculation is too long
I currently have a case statement within a beast mode calculation that does as follows: case when `advertiser name` like '%Microsoft%' then 'paid' (745 lines similar to the one above) else 'NA' end I get error: Invalid Formula : This calculation is too long Not sure on how to go about this. Any advice or direction on what…
-
If contains statement beast mode
I essentially have a list of URLs in one column and need to extract out the advertiser into a new column. I want to use an if contains statement to search every row in data set and see if it holds the pertaining advertiser name. Below is what I what both columns to look like and the code that I tried. COL.a COL.b url…
-
Python urllib3 failed NewConnectionError: Name or service not known
i can't get urllib3 to work. it always returns Name or Service not known errors Same code runs perfectly fine outside of Domo. What gives?
-
beast mode formula: Previous week compare to same week last year
Hi, I am struggle to get a beast mode formula to work for calculating the sum of same week last year, our business date start from Sun- Sat, i want to get the formula to only calculate previous week data e.g. today is 24th Wed but i want to calculate the week from 14th Sun -20th Sat DOMO says the formula for LY is…
-
How to calculate average using SUM(DISTINCT 'field name') / COUNT(DISTINCT 'field name')
Trying to get average of the SUM(DISTINCT 'Days Excavating') / COUNT(DISTINCT 'Days Excavating'). Both field types are whole numbers. This calculation always retuns the value for SUM(DISTINCT 'Days Excavating'). Beast Mode does not run the COUNT(DISTINCT 'Days Excavating'). I have used parenthesis around both functions and…
-
Single number selection from a group of numbers (Like random selection but from a controlled source)
I've got a very unusual issue. I need to select a group of workorder numbers that meet a certain selection criteria, and then from those select one. In the perfect world it would be random. I know that was a stretch so I tried put a ranking on them and thought that I could simply turn the value into Max(Value) and get my…
-
Excel text to column equivalent in magic ETL
What is the equivalent of the text to columns (from Excel) function in magic ETL? I have a column with mixed values that I need dileneated based on a constant character (in this case ";"). Ex. 123456;SKUName Need two columns Column A Column B 123456 SKUName
-
Domo Beast Mode/Data Flow
Hello, I currently have a column in my data set that is numerical called "session duration" with values ranging from 0 to 45,000 (in seconds). I want to be able to create a new column that does value mapping for values > 10 to be identified as "Greater than 10" and values < 10 to be identified as "Less than 10". Currently,…
-
Do I need to use Beast Mode to filter data in this way?
I'm working on a sales dashboard and I've got a scenario where within a card I need to filter out pitches sent to internal staff unless they are tagged with a specific word (of 10 possibles) contained in a measure. Is Beast Mode the solution and if so how would I do it? Any help much appreciated. Cheers, Danny
-
Beastmode calc for previous calendar month data
I am trying to create a beastmode calc for counting the number of records that occurred in the previous CALENDAR month. In current month (July), regardless of what day I run the report in July, I want my report to display the cound of records that occurred in calendar month June. So from Jun 1st to Jun 30th. I have tried…
-
Magic ETL Conditional Column
Hello, I am brand new to Domo and looking for the equivalent data transformation in Power BI that is called "Add Conditional Column" which basically allows you to write a case statement based on values in existing columns in your data set. Ex. If [Sales Rep] = "Dan" and [Order Type] = "1" then "Exclude" else "Include". Is…
-
Joining One-to-Many relationship datasets
I have two datasets that I am trying to join together, posts and metadata. I am figuring out how to do this via a pivot. The data schema looks like the following: # post schema ID | Name | Type 1 | Post 1 | post 2 | Post 2 | post # metadata schema Object UID | Field Name | Field Value post:1 | Number of Cats | 2 post:1 |…
-
Beast Mode works but not in Summary
I have created a beastmode calculation to show as my summary. The calculation works, however when I select it to show as a summary number it returns "No Summary Number". My beast mode is: CONCAT(ROUND(AVG(CASE when LOWER(`On-Time or Late`) = 'on-time' and LOWER(`Drop/Live`) = 'live' then ABS(`Live Turn Time Data`) when…
-
Total the count of Attendees for last 7 days & last 14 days in Table View
I am looking to find a way in Beast mode to do the following I have CustID and Class_Date and Class_Time. I am trying to show total Attendees and % of total for last 7 days and last 14 days both displaying in Table view mode. Any thoughts on how to do thiss via Beast Mode or any other way?
-
sum column values
I have a column total revenue which is calculated for each customer on a separate row, but I'm wanting to total alll the total revnue values together for all customers then divide each indivudal revenue by the toal to get a % per customer, is this possible? thanks
-
Connecting to Pardot in hopes of getting email stats
I've connect to Pardot in hopes of getting email stats. However I cannot get a 'send date' for my emails. There are a dozen different report types to pull, but none of them have ALL of the email data AND a send date. The report types that do have a send date do not have all of the open, clicks, bounces, yada, yada fields I…
-
Deliminator question
I want to count the information but don't want duplicates how can I do this and add the correct info for an accurate count? AHA.10133|1 AHA.101361799|1 AHA.10205|1 AHA.1012178447|1 AHA.10135|1 AHA.10135|3 AHA.10138|7 AHA.103352686|1 AHA.103352686|1 AHA.103352686|1 AHA.10135|1 AHA.10135|3 AHA.10138|7 Want this to equal 1…
-
Is it possible to have a Table chart type with one of the columns displaying a barcode of a value?
Hello, I have a rather archaic entry I have to do in one system based on DOMO data. I'd like to use the domo data to make a table of information where one of the columns displays in a bardoce font so the users can print the sheet and scan the barcode. The limited barcode experience I have is that the barcodes I need are…
-
Collapse and Merge Columns
Hi, I'm trying to join two datasets together with a single shared field. I can do this just fine, but I'd like to collapse one column from both datasets into the same column and leave the rest of the columns intact. Below is an example of the column I'm trying to combine. I don't want to do a straight append though because…
-
R Script Sharing
Hello, Appreciate if there are community members to please share a sample of R Script which you are able to run from Dataflow? I have read the documentation from https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/ETL_Actions%3A_Scripting But i'm unclear on the parameters to call a specified column. [Sample]…
-
How to merge two rows in one?
Hi, Let me show you what my table looks like and what I want to achieve this should be the easiest way to explain: Account SubAccount Integration AccountA Subaccount1 IntegrationA AccountA Subaccount2 IntegrationB AccountB Subaccount1 IntegrationA I then want to create an additional column in beast mode that checks if…
-
Leap year in Magic ETL
Hi all, I'm working on an dataflow (Magic ETL) through which I calculate the MTD, QTD & YTD metrics for both This Year and Last Year data so that I compare the values for each one of these metrics. According to Finance, for leap years, when This Year the last day of Feb is the 28th and Last Year was the 29th, this extra…
-
COUNT(DISTINCT creates An issue has occurred during processing. We... Error
I have created this first beastmode calc, and it seems to work just fine. Case when `Total On Hand` - SUM(CASE when `Planned Shipment Date` < (CURDATE()+ 21) then `Outstanding Quantity` else 0 end) < 0 then `Item No` else 0 end When I add a COUNT(DISTINCT to the end, it does not work and gives me the classic "An issue has…
-
how do you format date for comparison to today
I have tried several iterations to compare the date field to CURDATE, CURRENTDATE, NOW and when I attempt to determine if they are equal, I get an error. Does anyone know the proper MYSQL to format for this comparison? case when DATE_FORMAT(`call_date`,'%m-%d-%Y')=CURDATE() then 'Today' when…
-
How to get the second week Tuesday in a month?
How to get the second week Tuesday in a month?
-
Levenshtein distance in MySQL dataflow
Hi, I am looking to implement the levenshtein distance function (https://en.wikipedia.org/wiki/Levenshtein_distance) in a MySQL transform in order to find similar strings. I previously used Soundex to compare strings but it does not perform well on longer strings. How would I go about implementing this function in the…
-
Convert text into a number
Hello, I have a problem with numeric data being recognized in Domo as text (word) data when I'm trying to build my card. I know this is the problem because the data (which is numbers) is placed under CATEGORIES and it is listed with a T symbol. I need help with a Beast Mode formula that will translate this data into…
-
Can i write a nested "if" "and" statement in beast mode?
here is what the excel formula looks like: =IF(AND(K5=0,L5=0),"remaining",IF(AND(K5=0,L5>0),"resolved",IF(AND(K5>0,L5>0),"no gap","new"))) thank you so much for your help