-
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…
-
Null Values Beastmode
Good evening, Community, I am creating an app that will be pulling data down from Domo and I seem to be running into some issues with some beast mode logic. The beast mode (Open Rate): COUNT(CASE WHEN `activityName` = 'Open Email' THEN `activityDate` END) / COUNT(CASE WHEN `activityName` = 'Send Email' THEN `activityDate`…
-
ETL Value Mapper
Has anyone noticed that the value mapper tile has stopped working after one tile? Whereas it would perfectly work on the third tile in creating a new column for your new values and "if no match is found in row write no" and vice versa. It was working just fine last week
-
Row Numbers from original data
Hi there! Huge fan of the forums and hoping you can help me with something that previous posts and many late night Google searches have eluded me on... We have an email connector pulling in many CSV files from attachments and appending them one after the other in the order received. The order of the data within each CSV is…
-
Long Execution
Hi people! I'm here again! This time, i have a e long execution problem! I have a table with raw data with 46 million lines, approximately. Here is my first question: When a create a dataflow that process that 46 million rows and generates a output dataset, that dataset is a physical table or anytime i use that output…
-
Is there any way we could replicate Multi-Row formula tile of Alteryx tool in Domo?
This tool is very good to fill in data gaps (if any) based on logic.
-
How to Trim a column with multiple words in it using ETL
I need to Trim extra spaces, How can I do that in ETL? I used the replace text function, but it would remove all spaces. So, if the column contains " Josh Smith Jarrod ", I want "Josh Smith Jarrod" but I am getting "JoshSmithJarrod". I am not looking for SQL solution as the end user need it through ETL. Thanks in advance.
-
DOMO Regex Extraction ETL
I'm looking to extract a work order number which contains the letter W followed by 15 digits (Ex. W571191476628566). The order number lies within a string containing notes content that has been exported into domo. (Ex. "Customer called in to discuss work order W571191476628566, and asked about order status"). In the domo…
-
calculate difference between two dates
Hi, We have one filed name "Inquiry Date". and we wanted to calculate the difference between the two inquiries. we need output like mentioned below screenshot (Difference between two dates) eg: (01/01/21) - (01/01/21) = 0 (02/01/21) - (01/01/21) = 1 (07/01/21) - (02/01/21) = 5 (15/01/21) - (07/01/21) = 8 Please suggest a…
-
Beastmode | Exclude data based on dates
Hi all, I'm probably missing something small here but I'm using the following beastmode: (case when `Date` >2021-07-01 then (case when `company` like '%company1%' and `ConversionTypeName` like '%product1%' then 'exclude' else 'include' end) end) But when I use it as a filter it excludes everything and not only the sales…
-
Make title column of a mega table wider than the successive columns
Hello all, Is there a way to make the title columns of a mega table wider than the successive columns so that the generally longer titles don't have to wrap and make the rows double wide? I see there is an option to set column widths, but I can't seem to figure out how this setting functions. Can someone provide an example?
-
Help with Beast Mode field please!
Hello Community, I have a beast mode field that is working great when I am using a single number chart looking at the total for the current quarter we are in. The problem I need help with is, what can I update or what am I missing from the below Beast Mode field that will not allow me to show each month in the current…
-
Is there an easy way to calculate the days left in the month to insert in a Beast Mode equation?
I'm working on a Beast Mode where I have a given an amount of production that I want to divide by the remaining days of the month. The method I have below doesn't function the way I want it to. My code segment is below. Is there any easier way to go about doing this? Thanks in advance. (SUM(`Goal`) - SUM(`Production`)) /…
-
Please I need help with setting up a retention chart
Hi Domo gurus. I'm trying to create a "line + grouped bar chart" similar to the ones attached below. My goal is to create a chart that shows monthly cohorts of users who have made '100 api calls" and showing x% who returned to make other 100 api calls at the interval: 31 - 60 days, 61 - 90days, 91 - 120days, 121 - 150days.…
-
Grab the most current entry
I have a dataset with a list of activities. For each opportunity I want to grab the most current update/activity show those notes. so for a proof of concept, I might have the following: Activity Date. type description 1/1/2021. environment buildout. Built stuff to support POC 1/5/2021 project kickoff things are going…
-
Can you remove duplicated rows of data in a data set?
We have a data set that is updated from a Google Sheet. I see that back in June we have duplicate entries for June 22 and June 23 in the data set, yet the data in the Google Sheet is not duplicated. Is there a way to edit the data that is in the data set to remove these duplicates?