-
window function
I have the following table and i would like to understand how to get the difference between dates: id | status | date 1 | disconnect | april 4 1 | reconnect | april 7 2 | disconnect | june 4 I would like to understand the average days that persons reconnect in the entire dataset. Can a partition function work here? The…
-
Include Data for a specific date range
Hello - newbie here - I need to know how to only include data that falls within my defined start and end dates columns. There are multiple flight dates, so I need to be able to bucket the daily delivery data within those defined dates. It just pulls in all of the data for each flight and I cannot seem to get it to work. I…
-
Prediction Tile into a Self Serve Prediction Calculator
Hi, has anyone had success with creating a dash for users to make numerical and categorical selections for a dash predictive calculator if you will? I'm referring to the data science tile - "Prediction". I'm able to create magic etl for this type of work but wondering if i can setup a self serve prediction input for our…
-
Removing duplicates
Hi, I need help coming up with logic for this problem. I have a dataset that looks like this: ID Source 1 A 1 A 1 B 1 B 2 A 3 B I want to only remove rows from source A IF that same row is also in source B. Otherwise I want to keep rows unique to source A and unique to source B. The output should look like this: ID Source…
-
Multiple Split Columns
Hey, so i need to split numerous times within a column of data. i'm on the split column tile now, but i don't want to enter 100 new columns to create for each split. is there an easier way to split all of the data in the 'tags' column?
-
Comparing one month's EOM data to previous month EOM data in same row
Hi, I need to do a calculation so I can subtract previous months hours (4/31/2023) data from this month's hours (5/31/2023) data. This is how data is organized. This just a small example of how it is. Without changing the structure of dataset how can i get all the 4/31 data on the same row as the 5/31 data? I have been…
-
How do I alter Date (in Text format : 01.09.2023) to Date format?
How do I alter Date (in Text format : 01.09.2023) to Date format? I need it to be in a Date format such as 2023-09-01 instead of 01.09.2023
-
Approach to logically group data via inference of similar text strings
Hey all. I'm not looking for the detailed solution here as I know it will be complex, potentially require purchased add-ons and most definitely will require my dev team. But I'm hoping someone can guide me to general approaches and Domo capabilities that would be leveraged - if even supportable. We've got a large data set…
-
How to add hyperlink in the table
I have the data of different segments and want to represent it in a single dashboard. To make it user-friendly, I want to make an index table stating all the segments and I want that when I click on the name of that segment or the link (which can be created in beast mode) from the table, to navigate to that particular…
-
I have a file that has Date, Batch_Id and Active users. I need to keep the latest row in the file
I am trying to do this with magic ETL but I am not having much luck.
-
Warning: Not all the data is shown | Calendar Card
Hello, I'm having a problem with the Calendar card. It's supposed to display the count by day using data from the last 6 months. However, I keep getting a warning saying that not all the data is shown. Does anyone have any ideas on how to handle this? Maybe there's something I'm overlooking in the ETL process that could…
-
Grab value from one column and add it to another dataset?
This is probably a simple question but it eludes me since I don't use DOMO regularly. I have 3 datasets. A, B, and C Dataset 'A' has all the metrics for a specific ad set ID but no information for the campaign. No campaign ID or campaign name. Dataset 'B' has all the high level details for the ad sets which include the ad…
-
Not in formula filter on ETL
Hey, I am attempting to use the not-in function to filter out reversal charges. I have a reference column and a memo column. The reference column has a transaction ID and I want to filter out the charge and the reversal. I am writing a filter Memo Number not IN(Reference Number) but it only outputs the reversal only. see…
-
Magic ETL Creation from Card Filters Applied
I'd like to see the ability to create/save magic etl's straight from a card that has been filtered. This will make life simpler for magic etl manual creation.
-
How do you build a filter for a date range?
I need to build out a forcasting dashboard for my purchasing team. They need to look at the last 3 months sales for some items and I was able to get a filter to give me that range in my ETL. However, the other metric they use for some items is a term called "forward 3 months". This means that they need the next three…
-
Case when SYNTAX
Hi all, I am trying to write a case statement for a column when we see a null to grab another column. I am not sure why I am not getting the output expected. Can someone take a look and maybe advise? Essentially 36534370 and 36534369 from the investor_loan_id column should be in the left column as well. **I've tried to…
-
How do I fill text/values down in the same column for different partitions
I am trying to fill the text/values in "Drillable P&L Group Names" and "Sort Order" down in the same columns and can't figure out how. Keep in mind that the attached dataset is a single partition of a much larger dataset that contains multiple Client Names, GL Accounts, etc. And I'm trying to find a solution that would…
-
Looking on a specific date
Hi all, I am working in Magic ETL. I have group two different datasets on their 'lock_dates' I have created a calculated column where the number of locks are counted in each data set. Then I created a column that told me if dataset 1 matched dataset 2. All of this is shown below The issue I am running into is seeing that…
-
Is there an alternative for the add constants tile?
Hi Everyone, I'm trying to establish a new column with the same value for every row. But instead of a manual floating decimal input through an add constants tile, I'd like to generate the value from the magic etl auto calculation every time the dataflow runs. I know there is a simple way to do this, but the solution…
-
How can I convert an Excel date code into a normal M/D/Y formatted date?
Hi All, I have some data that I link to DOMO via the Google Analytics connector. It's provided by a 3rd party and contains dates in Excel codes in their 4** format. Is there a recommended Beast Mode or other way to fix the date formatting? Due to IT policy, I can't access google sheets to change it manually. Plus, I would…
-
How do I create a matrix from two unique lists in magic ETL?
How do I create a matrix as shown in the "Result" image based on the two input lists provided (zeros filled in the field)? I am trying to do this in Magic ETL. Thanks in advance! Gregory
-
How to Unpivot or Explode Variable-Length Lists in Domo to Flatten a Table?
Hi Domo community, I have a dataset in Domo where the number of postcodes in a cell can vary. Here's an example of my input data: Network State Postcode A VIC 3000, 3001, 3002 B NSW 3011, 3021, 3001, 3004, 3012 I need to transform it into the following format: Network State Postcode A VIC 3000 A VIC 3001 A VIC 3002 B NSW…
-
LEAD IGNORE NULL in Magic ETL?
Hi there, I am trying to rewrite a Redshift Dataflow into Magic ETL. I ran across a specific function that was available in Redshift that I dont think is possible in Magic ETL. I wanted to get the community's input and advice to see what you guys think. This is the function found in Redshift: LEAD(CASE WHEN t2."channel"…
-
Comparing Datasets to Determine Variance
Hello everyone, I am working on comparing data from a previous data input, Universal Analytics, to a new one, Google Analytics 4. Basically, there was an update and data is formatted differently. I am attempting to join the two datasets to compare the month of A ugust for variances, but the closest thing to a unique column…
-
Long Running Dataflow Alerting/Auto-Restart
We need to have the ability to understand when dataflows are running longer than the average duration. We would like to set user defined alert criteria based upon the dataflow's duration. For example: alert when dataflow has been running 15min, 1hr, etc. longer than the average for the dataflow. Having the functionality of…
-
In App Editable Data and Real-Time Visualizations
Hi Everyone, If users wanted to be able to edit the data that goes into a visualization, and then see how that edit impacted a visualization (and all of it's great metrics), what would be the idea way to do this in Domo? I was thinking that you could use a Domo Webform to let users plug in new data/edit data, and then use…
-
How do I remove the 'Total' row from a data import?
I am using a connector to pull data in from one of our web analytics platforms. The problem is that it pulls in a 'Total' row which I can not suppress at the source. Using an ETL how do I remove that row? I've tried to use the Filter Row tile but perhaps I am doing something wrong there because I have not been able to…
-
Can you use Magic ETL to 'explode' table of transactions to all days?
Table A has transactions that show an item's "Old Status" and "New Status" along with the date of the transaction. For example, row 1 shows that item XYZ changed from "Regular Price" to "Promo Price" on 1/1/2023. Row 2 shows that item XYZ changed from "Promo Price" to "Regular Price" on 1/4/2023. Row 3 shows that item XYZ…