-
Group By -- all additional columns
I have a data set that looks something like this: Rep Name --- Department --- Month 1 --- Month 2 --- Month 3 etc. I want to do a 'group by' as some reps appear on multiple rows and I want to sum the Month total for those reps. That part is easy. Is there a way to automate that all future months added also get that…
-
Unique ID within parameter
I'm working on an ETL. I want to create a unique ID for each row of data with the caveat that the ID should be the same as the previous value if a value 0 appears in a flagged column. I was thinking of doing this through a window function of row number and then a function tile, but I can't figure out how to achieve this…
-
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…
-
Recommendation for Social Media Scheduler that Integrates Easily with Domo
Hi, I work for a parent company where one of our subsidiaries uses Sprout Social to schedule posts. We are opening a new subsidiary and I was asked to advise on a Social media scheduler app. I find Sprout Social to be great, though a lot of the bells and whistles can also be done in Domo, and it does not have an easy…
-
Pivot Table Static First Column
Hi all, I am working on a pivot table that has all Sales Reps and Counts the number of call that they've made. It accomplishes this by COUNT of Phone call, COUNT of Zoom meeting, etc. (each its own column) My columns are : Date / Call Category / Count of each type of Call. Problem: When I filter by date, anyone who has no…
-
Subtracting Dates Based on Other columns
I currently have a data set that looks something like this: I want do compute a Date Diff for orders from the same account between orders 1 and 2. So-- find accounts that have the same number in column A Determine which two orders (rows) to pick, based on column B Subtract the corresponding dates in column C Example: Find…
-
GA Advanced Connector and Domo (Demographics)
Hi all, I am trying to figure out some way using the Advanced Google Analytics connector to link demographic data (gender, age, affinity, in-market and other) with transaction IDs. I looked at the API documentation, and it seemed that it should work (https://ga-dev-tools.web.app/dimensions-metrics-explorer/). I tried…
-
Google Analytics Transaction ID failed to Parse
Hi all, I've read through the other replies on this topic, but none seem to help. I am attempting to join our CMS data with Google Analytics via 'Transaction ID'. When I do so, I continually receive the error message: Failed parse text '1234567890-loc' from column 'Transaction ID' as type 'Integer'. *sample number, not the…
-
Seeing more rows in ETL preview
Hi all, This is likely a basic questions, but I can't figure it out. . When I run a preview on my ETL, regardless of how many rows I chose to run it on, I can only see 100 rows. Is there a way to see more? There are anomalies that I need to be sure are accounted for in my algorithm and the preview doesn't always show these…
-
Rows Gone Missing in ETL
I created an ETL. The final step -- where it leads to the output suddenly causes ~20K rows to go missing. Any insights? Thanks!
-
How can I create a new column with extracted numbers in SQL or ETL
I have a column called 'description' which can contain multiple elements. One of them is 'Order #1234567890' (or other digits). I want to create a new column that just extracts the numbers in SQL or Magic ETL (so that I can do Beast Modes etc. on it afterwards). How can I create this column? Numbers may exist in other…
