-
Is AS valid in Beast mode?
Good afternoon, Can AS be used in Beast Modes to create aliases? It doesn't seem like it but I might also be super bad with SQL. Thanks! -Joe
-
Beastmode. How to create a CONCAT URL with several variables?
Want to build the following link on a card =CONCATENATE("https://b2b.officedepot.com/rest/ODServices/api/product/priceAvailability/xml?zipcode=",`CONSTANT1`,"&sku=",`COLUMN`,"&billto=",`CONSTANT2` ) The URL is a constant as well as "CONSTANT1" and "CONSTANT2", but also need "COLUMN to change depending on the value of the…
-
Rolling Average for Each Category
I have a dataset containing total monthly units by month and by person. I'd like to calculate the 3 month rolling average for each person. How should I group the data so that the rolling average calculation goes by person and not by date?
-
Calculating existing delays , Off delays and new delays on manufacturing data
Hi All , I am new to Domo and I am trying to create a beast mode for the following type of data... I have a manufacturing plant data on a daily basis and specific vehicle (denoted by sno) belonging to a specific category (mmodel) that can go on a delay due to some issues. Now my Input tab has the snapshot of this data on…
-
Can I make a "mother row" to assign values from?
We are a music library company, and as such a large amount of our income comes in as small royalty payments that add up incrementally. The information comes from 15+ different collection sources, and in general the only thing consistent between them all is the track title. That means that the information from the royalty…
-
Replace Text Regex - IP Address Regex
I need some help. I'm trying to find an IP address in a text string and pull the IP value out. I was hoping to use ETL 2.0 formulas, but to start was trying String Replace with the REGEX feature. REGEX FORMULA. (my IPs start with 199.15): 199\.15\.[0-9]{1,3}\.[0-9]{1,3} REPLACE WITH: (I'm trying to pull the first match) $1…
-
Rolling Average Calculation
I have a set of monthly data and would like to calculate a 3-month rolling average. For example: Jan = 30 Feb = 32 Mar = 34 April = 36 Rolling average for March would be 32 ((30+32+34)/3), for April would be 34 ((32+34+36)/3). It is probably something fairly simple, but I'd appreciate your help. Thank you.
-
How to set the time for hourly data refresh?
I have a dataset that refreshes every hour. However, it seems to follow the time when I initially created the dataset. For example, I first uploaded the data at 9:20PM and now it refreshes every hour at 20 mins. How can I change it (Say 9:10pm) ? Thank you.
-
Right way to utilize string operation on long date.
I have a long date that I have converted to a text. Now I want to use the string operations tile to cut off the tail so I can have a nice clean date. the way it looks now in a string format is: 2022-02-24T12:08:34 What I want is: 2022-02-24 What I have been trying is: But it leaving the date unchanged and that timestamp at…
-
Filter a DataSet with values from a Google Sheet?
Hello, I have a dataset that I would like to be able to dynamically filter based on values in a Google Sheet. This feels like a fairly simple MagicETL to me but I'm stumped at the moment. In short, the PROD dataset is good to go and I would ideally be filtering one column from the PROD set based on values in one column in…
-
Domo not capturing all data despite data range being correct
Hey - Appreciate your help. I have a spreadsheet that is about 380 rows long The first 370 rows are individual locations, and the last 6 rows are "Region" rollups for the 395 centers above. I made sure the data range includes through row 379, but these don't show up when I try and filter by column A, only the first 370…
-
Right way to utilize string operation on long date.
I have a long date that I have converted to a text. Now I want to use the string operations tile to cut off the tail so I can have a nice clean date. the way it looks now in a string format is: 2022-02-24T12:08:34 What I want is: 2022-02-24 What I have been trying is: But it leaving the date unchanged and that timestamp at…
-
Best Practice: ETLs Vs SQL ETLs
We are trying to rebuild a tool Domo Tech built for us called Domo Stacker. Its main purpose is to aggregate many datasets together. Our current datasets are 250+ recursive ETLs that output a dataset that is growing (think: historical + appended new data) for four buckets of categorized data (four separate outputs when…
-
Adding Space to Postal Code TEXT String in Magic ETL
Hi, I might be missing something but looking for some help to add a space to a postal code text string using Magic ETL. I am trying to change a postal code from S4L1A5 to S4L 1A5. thx!
-
Adding business days to a date via MagicETL
Hi, I'm currently calculating a deadline using a dynamic formula in MagicETL. It looks like this: CASE WHEN `issue` = 'bug' THEN ( CASE WHEN `priority` = 1 THEN ADDDATE(`CreationDate`, INTERVAL 4 DAY) END ) The calculation works great, but I was wondering what would be the best way to update it to 4 business days, rather…
-
Creating buckets for unique ids to fall into, based on the sum of donations of those unique ids
Capturing donor frequency: We want to count the number of donations a donor has given per procedure. The amount of donations is the bucket I want donors to fall into. So, if we had 100 donors give 4 donations, we want those donors to fall into the bucket '4', and then we would count the unique donor ids. The part I am…
-
ETL Formula to Change a column of city, state, zipcode to Just portray State
I am trying to write a formula in ETL to change a column the has for example "Los Angeles, CA 90001" to preview as just "CA"
-
Forecast based on last month
Hi, I'm working on ETL created by someone else connecting 9 data sets. This is for a forecast, the March 29th, 30th and 31st are missing as the Feb only have 28 days. I'm able to join the Domo calendar and get the missing dates. For query we are using the date operator and adding the next month to it. I'm not sure how to…
-
Magic ETL Formula Editor Tile - Minor glitch
I am just wondering if anyone else has been experiencing this. I couldn't find any related posts. In the formula editor tile, I will literally click on the column name from the list below. When I am done with the formula and click "validate" I get an error regarding the column I selected and it says "table doesn't exist"…
-
Pulling out UTM parameters for new columns
I'm working with Google Analytics 4 data and am noticing some gaps with the campaign metrics. So, what I'd like to do is reference the page URL to look up UTM parameters and identify. In case you aren't familiar with UTM parameters, the way it works is you'll add a '?' and add these to your URL. Later in GA, you can tell…
-
Calculated Column Syntax Error
Trying to create column(s) in my data set to see if payments were paid early, on their due date, or late. I already have a column 'Due Date Minus Payment Date' 'DATEDIFF(`due_date`,`payment_date`) but for some reason this next column keeps giving me an error saying "oops something went wrong.) It seems incredibly basic, I…
-
Combining Row Data
Hi everyone, I've looked through all of the resources I can and can't find an answer to my issue so hopefully, someone here can help. I am working with student data from a university and am attempting to combine classes and labs into one row while maintaining data from columns. I have a unique identifier for each student…
-
Formula where value contains a single quote
I'm looking to write a formula where the value I'm searching for contains a single quote. Because Domo views single quotes as the start and end of my value, I receive a syntax error. Any known workarounds so that I can include a single quote without throwing off the formula? This is the formula I'm going for: (CASE when…
-
How to identify unique values in the column
Hello all, I want to label the unique entries in the column as unique and repeated entries as duplicate by using beast mode. Could anyone please help me on how to do this.. Attaching screenshot of the expected result table : Thank you
-
Count of date instances "last week"
Trying to visualize a sales funnel via Hubspot data and running into issues. I need to create a calculated column counting instances that a date field falls in "last week". Is there a quick calc for something like that?
-
Is there a way to show averages for last day of month
I have data (cumulative totals and averages) for a dataset by day for various products... I'd like to create a bar chart that shows the collective sum of the cumulative totals and collective average of the averages for the last day of each month... Can anyone advise on how to do this?
-
Filling in data in ETL for missing dates
I have a bunch of data which shows cumulative reviews on each product (on indirect ecommerce channels). However, if there were no reviews for a particular product on a specific date, my dataset will not show the cumulative review for that product.... so for example, I may have the following data for Product A - in which…
-
Can you find a Beast mode by it's function?
Hi We have a primary data feed and that datafeed contained a 15 digit ID. We recently updated the datafeed to the updated 18 character Account ID and in Domo we used to perform a String Operation that performs a left trim from 18 to 15 characters prior to using a Join Data tile. We wanted to find all of the Beast Modes…
-
Group by Percentage
Hi there! I'm trying to figure out how to get the percentage of rejected x-ray images by reject reason. I built a simple ETL that gives me the count of rejected images by reason for each type of x-ray (body part) along with the total # of x-rays for that body part (Acquisition). I'm stuck on how to get the % of rejects per…
-
Collapse all Subtotal Rows on mega table?
I don't see a way to collapse all subtotal rows, and it's frustrating. Without it, it's death by 5,000 clicks.