-
Failed parse text 'NULL' from column 'Column Name' as type 'Date'
Does anyone know how I can solve for the error msg below: Failed parse text 'NULL' from column 'Column Name' as type 'Date' I get this error msg when the ETL finds a NULL value in a column with data type 'Date'. Thanks in advance.
-
Reg. Expression to replace a list of names with a single character.
I have a column that is in a string format, and of course contains names. Majority of the rows are an empty string. What I am looking for is to take the rows that do contain a name and replace them with a 1. i have been trying to use replace text tile then trying to use a regular expression in the 2nd step, then replace…
-
Can I dynamically group data to two periods (Current 12 month and Prior 12 months) ?
Can I dynamically group data to two periods (Current 12 month and Prior 12 months) using window function so I can select time periods to compare. Client wants to be able to select months in the past and compare rolling 12 month as of the last date select date. I tried this formula for Current period, but it doesn't…
-
Changing a value to an integer in the ETL
I have a column that uses an 'x' as a flag, any row that isn't flagged with an 'x' is left as an empty string. What I need is to replace the 'x' with a '1' to be used in a later count. this should be straightforward but I keep getting my wires crossed with the order of operations.
-
Previous day values - Following Day Values Restart Calculation Each Month
Hey guys, I have a dataset that appends each day to include the daily downloads, and resets the calculation on the 1st of every month. This issue is, it's cumulative totals, so if yesterday we had 40 downloads and the following day we had 15 downloads, the total for the following day would come in as 55 total downloads.…
-
Assembler Upsert Date Column
Hi. I need to take a snapshot of today's data in order to compare it with tomorrow's data once it will be available. The problem is that the SQL dataflow and Magic ETL only can use Replace method. I need to find a way how to append the data each day to the already existing historical table. I created Assembler and I chose…
-
I need help creating a retention chart
I am trying to do an analysis to show users who came back to make 100 api calls after the making their first 100 api calls. For more clearity, "100 api calls" is a key activation metric for us. The way I plan going through this is to use a line + grouped bar chart where I'll have the 100th api call date as the X axis and…
-
Where can I find the logic for custom built dimensions?
Hello, I'm having an issue tracking down where, exactly, I can find the logic for these custom-built Dimension Segments. Any tips for where I might find it? Thanks!
-
Swapping Pivot Table Rows with Columns
Hello, I am trying to create a table where the columns are a categorical variable and the rows are a quantitative variable, such that the intersection of each row and column will provide the relevant quantitative value for each categorical value, however I am finding that I am only able to create any sort of chart that…
-
Time Format
Hello, I am combining date and time in one column but once is combined the date format is ok but my time format is all zeros. is there something I am missing? Thank you!
-
Date Diff - Tenure
Hello, I am looking to build a tenure-based view for a list of employees. I have a hire date field and I want to create a filter to show some categorized options. Can someone validate if this is possible and any ideas will appreciated Employees that have 3 weeks of experience ( Something like if datediff today()- HireDate)…
-
How can I split 1 column into multiple columns
Hi, Is it possible to split 1 column to multiple columns by specifying the splitting character? For Eg, I have column named Campaign and the values in the column follow a standard format like 'Campaign Date_Campaign Name_Campaign Type_Source_Language_Status' Is there a way to split this column by '_' ? Thanks, Angel
-
Redshift Unable to create database.
We are getting the below error when trying to build a Redshift dataflow: We are unable to run previews, and we are unable to run the dataflow itself. It fails every time we try to run. Any idea what is causing this issue?
-
Beast mode with multiple case statements
Hi, I would really appreciate help with a beast mode that I am unable to resolve even after looking into many answers on dojo. The beast mode looks like below: CASE when (CASE when `Cost Type` like 'Fix Price' then (CASE when `End Date` < CURRENT_DATE-3 then `CPM` else (`CPM`/(DATEDIFF(`End Date`,`Start…
-
Getting a Sum of Values for X Days When There are Gaps in the Dates
We have our dataset of transactions for a large number of SKUs. Dataset is over 1 Million rows. We want to examine the date of each transaction and go back 30 days to get a 30 day average of sales for each SKU based on the date of that record. Normally I would be thinking Row and Window tile in Magic ETL. But here's the…
-
what does the delta symbol mean on my data flow ?
I checked all the flows and tables involved in building this flow, but I cant find any mistake or warning. What does that orange delta symbol mean ? it doesnt give any info when i hover over it or when i click it. thanks for the help.
-
How to use programmatic filter with domo
Hello devs, I need help over adding multiple i frame with programmatic filter, after reading docs https://developer.domo.com/docs/embed/programmatic-filtering and trying out the JavaScript filter code (https://github.com/domoinc/domo-node-embed-filters) i am not ure how it working for different filters neither the code is…
-
How to use case statements within Filter function in Magic ETL 2.0
Hi Team, Trying to use case statements within filter function in the ETL 2.0. ' For instance, I want to only filter out records for specific dates for only specific people. However when I use the following formula : case when member = 'John Doe' then date > '1/1/2021' ELSE NULL END It filters out everything from the…
-
Regression Line Missing From Multi-Line Card
Hello all, I am trying to add regression lines to a multi-line chart, but no matter how I configure the option, the regression line does not appear. In fact I can't even get an average line or a median line to appear when choosing one of those under "Grid Lines". See below for my card:
-
Multiple conditions using case statements but not getting correct results
Hi Domo Community, In Beast mode, I've been trying to parse out some data for visualization but cannot get domo to display the right numbers. For example, with the data below, domo only returns the entries for one of the lines for Marketing and LeadIQ for SDR - it won't give me the sum of Display, Direct, Event or the sum…
-
Sharing favorite filters in data center to colleagues
Hi all, I have been using tags and favorite filters as a way to group my team's datasets and dataflows into collection. Just until today I realized that the favorite filters I created for my dataflows are not visible to my colleague (while, strangely, the filters for datasets are). My colleague and I are both in the same…
-
View Epxlorer crashed
Did anyone have the similar explerice recently: It happended to me in the last few days. I have been making udpates with some of my viewExplorer datasets, such as added a filter, created a new formualr etc, then I saved the file. However, once I reopened the view to edit, it shows me the error: invalid query. Check your…
-
Magic Replace Text REGex, remove anything outside of delimiters
Hello! I am trying to use the regex replace text in magic and am having difficulty getting the desired result. I need to capture a string between two delimiters and delete everything else. An example being: "EM|CX-001|Test Campaign Name" and grabbing only "CX-001". I cannot use a substring as the number of characters…
-
Is it possible to indirectly calculate a Rolling Maximum in Magic 2.0?
I know the in-built "Rank and Window" tile in Magic does not allow for Max/Min window functions -- is there a work-around that anyone has found, however clunky? Raw data essentially is a variation of: 1/1/2021 | $100 2/1/2021 | $200 3/1/2021 | $180 4/1/2021 | $190 5/1/2021 | $220 Appreciate the help, thank you!
-
Beast mode Training
Hi I am a fairly new user of DOMO, I find very difficult to sort out in complex calculation the parentheses in Beast mode Bearing in mind that I am an advanced user of Excel but never worked with SQL, I wanted to ask what would the best training to understand better Beast mode coding. I did all the trainings on DOMO. Thanks
-
How to SFTP file in DoMo
Hi All, I need to sftp file on other server. Could anyone help me with the steps/connector that can be used to achieve this? -Guest1298
-
Convert Timestamp to CST, UST, MST, EST Python
I have a data set like the following: start_time_UTC 2021-09-16T12:00:00-05:00 2021-09-15T19:00:00-05:00 2021-09-16T08:18:00-05:00 2021-09-16T12:22:10-05:00 My default time is UTC, but I would like to create multiple columns based of the start_time_UTC to create cst, mst, and est. from domomagic import * from datetime…
-
"Invalid Schema, Check Your Dataset Query" error
Hello, I only saw a few questions related to this on Dojo and figure I might ask. My dataflow has always ran fine (created in May 2021) but yesterday there was an error that showed up. I'm not able to preview the dataset, and I tried to refresh the ETL multiple times and reset the schema (deleted all columns from the…
-
Can you create a beastmode CASE when for values between two numbers?
I'm looking at influencers and their number of followers and want to group the data: number of follower: 1-50000, 50000-100000, 100000-200000 and so on. I was going to use the case when beastmode but cant find a between function to select the relevant numbers. Any help?
-
Views Explorer - Invalid query, check your DataSet schema
I have created a simple dataset view that I would like to use in another dataset view... when I attempt to open it in views explorer I am getting the error message: "Invalid query, check your DataSet schema" Suggestions on how to trouble shoot? The steps I followed to created the dataset view: Filter to exclude one value…