-
Formatting Multiple Summary Numbers with Commas
Problem To build summary numbers with multiple metrics, one needs to use the CONCAT operator, which converts the entire output to a string. This means that numbers won’t contain comma’s. In this case, a solution is needed to dynamically add comma’s to these numbers based on their length. For example, in the Summary Number…
-
Adding Budget Rows to Actual
Hello, I have an original cases database in DOMO each row has a case submission and case start, and then I later replicate it all the columns and added the budget we have for the year. I had to unpivot this data in order to create graphs that will put both dates in the same axis. I would like to show the budget as a third…
-
Comma Separated Field to Child Table
I've written a connector to query a remote API, the data has come in correctly but each row can have many labels, because the connector will only create one table at a time and I don't want to query the remote API twice I've created a comma separated field. ID, Name, Labels 1, "Hi there", "hi, welcome, hello" 2, "Over…
-
Getting Previous Year Actual Sales to Populate
Hey all- I'm sure this will come off relatively simple but this one has me stumped. We switched ERP systems and I'm trying to get previous year sales to populate in a bar/line chart that shows current sales (by month in the bars) and previous year sales (by month in the line). I cannot get the new ERP system data to load…
-
Magic ETL Nested Case Statement
Hi all, I am trying to create a nested case statement (I 've provided an over simplified one that I've been experimenting with, but I have the same issue): (CASE WHEN `Specific Category`LIKE '%People%' THEN 'People' WHEN `Specific Category`LIKE '%Unknown%' THEN (CASE WHEN `Platform` LIKE '%Amazon%' THEN 'Amazon Likely…
-
Averaging multiple Percentile rankings
Hi Everybody. I am stuck with a problem. First of all, thanks to Jae Wilson for the percentile rank video. It help me solve one part of the problem. My data looks lik attached The data is pulled from Google Analytics and modified using Magic ETL. It contains page title, Month, and other metrics. The task on hand is to rank…
-
Combining datasets by looking for strings in one column
I have a couple datasets... 1) Product IDs with information 2) Google Analytics data with URLs that contain the product IDs on product pages I'd like to join the first dataset to the GA data to include product information that aligns with the product page. Is there a way to join these datasets in which I have the second…
-
Levels of Data in separate columns, bottom top approach
Hello, I am working on a request to provide all level of parent values for each individual child value. It is kind of bottom top approach. I have to start from a child ID column. For each child I need multiple cols of Parent ID. Something like below: The current data looks like I am trying to solve this in ETL. Any…
-
Number of Months Left As Displayed in Table
Is there a dynamic beastmode that counts the number of months displayed in a table?
-
Rolling Percentage
I want to have a rolling percentage of a value across a series of values. I want to be able to choose the value and the size of the series. Here is an example where I want to know the percentage of Oranges for the last 5 values. Also, Is it possible to do a running percentage of the value? Just thought of that. Ideally I…
-
Invalid date in MySQL datafow using Hubspot
Hey there, I'm attempting to join HubSpot data with another datasource using a MySQL dataflow but running into an error. In the HubSpot dataset, the closedate field is recognized as a timestamp, and looks great. In the data preview it filters correctly. When I add the HubSpot data to a MySQL dataflow, the column previews…
-
Trying to condense / group rows to remove nulls, any help appreciated
Hello, I am working on a data flow that needs to perform various substring functions to isolate data from a large xml string. I have gotten it close, where the data is linked to the log / time / user in in the sql database, and i am able to separate values into appropriately named columns. I would like to know if/how to…
-
Curved line + stacked vertical bar
Hi, I have two question for the card of Curved line + stacked bar(Vertical bar) I would like to change curved line "A" to "BGT". Please let me know how to change.(Question1) Now I have only one curved line in the card. But I would like to create two curved line of "BGT" and "B" in the card. ( I want to set "A" as vertical…
-
Does Domo have the equivalent of a SQL Server "View"?
Maybe I've spent too many years deep in SQL Server. SQL Server has the concept of a "View", which is really just a query, usually containing a join. Instead of having to write a query to join tables, I can just query the view without needing to know the underlying relationships. I don't see any equivalent in Domo that…
-
2 editors for 1 etl in domo
Is it possible to have two people have the ability to edit an etl?
-
How to indicate the values of two columns on Y axis
Hello, When I use the card of Curved line + stacked bar, it is possible to indicate the values of one column divided to Var and curved line by series on Y axis. But it is impossible to indicate the value of two column on Y axis. Please let me know how to indicate the values of two columns on Y axis.
-
Adrenaline Dataflow: Inequality Correlated Subqueries Unsupported
Hello, I'm attempting to perform a correlated subquery using an inequality as shown in the below example. SELECT a."Opportunity ID", a."Owner ID", a."Created Date", a."Close Date", a."Snapshot Date", a."Last Modified Date", a."Next Step", a."Competitor", a."Amount", a."Stage", (SELECT COUNT("Opportunity ID") FROM "pushes"…
-
Group SLA case age into 24hr intervals
Hi, working in Support, the time to resolution is a key metrics for us. We measure how many cases we close within 24 hrs, 48, 72 etc. In Exel, there is a quick and easy way to group the Age into e.g. 24hrs buckets. Is there something similar in Domo? I started creating a Beast Mode, but this would get very long. (CASE WHEN…
-
Metadata clean up card created reveals 2 user ID's and both Cards & Pages not in Admin Portal
I attended the Virtual User Group conference on 1/12 and created the dataflow shared by John Stevens in our instance. Incredibly helpful! However, it revealed a number of pages and cards with no 'Display Name' (owner). Within the admin section, I am not able to find the pages or the cards using the filters. When I search…
-
Beast Mode formula: not calculating/populating
Hi - i created several Beast Mode formulas (TQ, LQ, QoQ). I have no issues adding TQ and LQ to a Pivot Table chart. When I add QoQ beast mode to the Pivot Table, no values are populated. The QoQ formula is a difference of TQ and LQ. I can add TQ to TQ, or LQ to LQ and get a result. I just don't get a result if I mix TQ and…
-
How can I group multiple columns by year-month in the dataflow?
So I have a dataset that looks kind of like this: Date. A B March 2, 2020 2 10 March 14, 2020 4 20 Feb 12, 2020 3 8 Feb 21, 2020 1 4 Jan 3, 2020 6 10 Jan 17, 2020 3 5 I'd like group the rows by year-month essentially stripping the day from the date column while simaltaneously summing the combined rows within that month.…
-
Rolling 12 Month Avg
Hi all - Currently I have a dataset that contains a date (by quarters), brand, sub-segment, sample type, and a NPS column. Using a Beastmode calculation, I take the favorable responses and divide it by the total number of responses to get a NPS score. This data is granular (many NPS respondents, by brand, by segment per…
-
Adding Missing dates between start and end date for each category
Hello, I am trying to add missing dates from Start and End date for each category in Magic ETL. I tried to bring in Domo Calendar but confusion is what column from my dataset should I join with Cal.dt? Should that be start date or end date? Also, Then how would I create an output column which will have start date, missing…
-
How to append monthly data?
Hello, Please let me ask how to append monthly data to accumulated data. I want to append monthly data using DataSet via Email Connector on the accumulated data from January to April. For example, I upload May data by using email connector in May, the output dataset will be for January-May data. However, after that I…
-
PDP Policy Simple Filter - don't see value in dropdown list
I am trying to filter by store number (Store No) for a particular PDP policy and I'm searching "8". The value is definitely in the dataset, but it does not appear in the dropdown list and I'm assuming this is due to some sort of limit on how many values can be displayed in it. Is there a keyword or phrase I can add to the…
-
Case Statement or Formula for creating a flag
I have to create a flag in a dataset where (IF columns A.a and B.a = A.b and B.b ) then I have to check cols A.c = B.c or A.d = B.d My Data is like Can someone help me in case statement. The one I have is not showing correct results. First two columns have to match to figure out discrepancies in next cols. If cols match it…
-
Can I make a period over period pivot table with a dynamic date range?
I had a need to create a pivot table that has our % change ( this year sales - last year sales / last year sales). I was able to create an ETL that accomplishes this for any date this year. I am able to filter any date this year (MTD, QTD, YTD, etc.) and a beast mode will take the above formula to calculate my % change. I…
-
Issue with dates in ETL
Hello everyone! So we use filters similar to this in Domo and noticed that for some reason all results are being returned. What is happening below is we apply a filter on the rule to only look at 'Y' results that should be only applications hired this year, but instead we receive everything. We are working through it on…
-
Data Overview
Dear Community. I am trying to get an overview what data we are currently importing to DOMO due to data privacy evaluation. There are a lot of Data Sources (54) and a huge amount of respective Data Flows (1.9K). My question is if there is a functionality or app supporting me with listing all data schemas/column names per…
-
GA4 (Google Analytics 4) in Big Query - best practices for unnesting in Domo?
Hey everyone - first post here! Curious if anyone is using GA4 data stored in BigQuery inside Domo, and if so, are you unnesting things after connecting to BigQuery, or are you doing that in BigQuery as a pre-process step? Any best practices to share would be very much appreciated!