-
How to create a filter to capture the end of month
Hello Domo community - Good Day! Basically, we want to capture the data from the previous month on the current week. for example, the start of the week is 8/28 and the end of the week is 9/3. we want to capture all data up to 8/31 only. and then data for 9/1 to 9/3 using the start date 8/28 or end date 9/3. Thanks
-
Grand total instead of running total with Count in Rank & Window?
I was trying to get a total number using Count with Rank & Window in Magic ETL but I can only get a running total instead of the grand total repeated across the rows. My output looks like this: jane doe, item a, 1 jane doe, item b, 2 jane doe, item c, 3 But I wanted this: jane doe, item a, 3 jane doe, item b, 3 jane doe,…
-
To Avoid in the title
How to avoid in the title while sending to report (Card) to multiple user via DOMO ' Ignore as follows :- "Including 5 cards Sent by ----------* " detail:
-
Parsing Dates with Different Formats
Does anyone have any guidance for using a formula/function in a beast mode or using the regex functionality to ensure Domo recognizes all of the dates below as the same? 5/12/2022 5/12/22 2022-05-12 5.12.2022 5.12.22
-
how to break a week between months
Hi DOJO - Happy Weekend! Basically, we have a dataset with date columns based on the start of the week and end of the week only. on the example below, I just concatenated the start and end dates so it shows Aug 28 to Sep 03. if its not concatenated, I can put start date and it would show the start of the week which is…
-
Programmatic filtering
We are trying to to embed domo in our web application, Is it possible to use Programmatic filtering without the use of the yarn server and log in users ? We are using SSO so want to just get the domo access token through an API call and create an embed token with filter values will be retrieved from our back end
-
help needed to create weekly cohorts
I'm working with a large dataset that contains time-stamped user sign up data. I'd like to use ETL to define weekly cohorts based on when a user signs up. My goal is to use these cohorts as a foundation for beast mode calculations like "growth in weekly sign up cohorts over time", and when joined to tables containing…
-
ML model null values and unknown error message
We are trying to create a machine learning workflow wherein we are trying to predict by feeding in several rows of data to train the model and use that as base to get the predictions. We were able to run the same model (with samechosen parameters) in Python and get an accuracy of upto 95%. When we try to replicate the same…
-
Merging Outlook Meeting & Sales Lead Data
Hello there, I am trying to create a sales pipeline, and have two key datasets that I need to join based on the prospects email adress... Outlook Meetings: CC Emails, Categories (Attended, Booked, No-show) SalesForce Lead Data: Keep all data, looking to transform Lead Stage. The idea is to join both these datasets based on…
-
Group columns without stacking data
Is there a way to group numeric columns without summing the data? I want to group five columns, but simultaneously be able to view the data for each individual column in the group. In my dataset, I have 15 columns of data: five columns represent the past populations of five bird species, five columns represent present…
-
Is there a way to create a static temp table in Beast Modes?
I'm the MajorDomo for a large retailer, and our Fiscal Calendar uses a 4-4-5 format. This means we have a Week 53 this year, and a large portion of our Domo reports are built off of a TY/LY comparison. I'm working on logic to reconfigure our reports always look 364 days or 52 weeks ago, rather than look at the same Fiscal…
-
Moving the position of DOMO page and subpages within the same page in DOMO
Hi All, Can you please let me know how to move the position of DOMO page and subpages within the same page in DOMO Thanks, ozarkram
-
How to skip nulls in rank and window?
I have a dataflow that is joining multiple datasets with information about a set of schools - 29 elementary schools and 3 high schools. One of the data sets is specific to tests scores that only the elementary schools take, so the high school rows are "null." This dataflow that I am creating aims to generate separate…
-
Count number of character occurrence in string
Trying to see if there is a way to achieve this. I have a column that has something like the left column here Is there a way to achieve the right side column by looking at maybe the number of commas + 1 maybe? Doing this in ETL formula tile would be best for me if possible
-
Dashboards/Sub-Dashboards Management
I built a dashboard before I realized I needed to make a bunch for the entire department, and so I wanted to create a nesting in the dashboard management, but from my testing and efforts, I can only reorder them, not drop them into a different sub-dash area . Is there a way to align them, like Parent Dashboard = xxxxxx ?
-
Drill down linking to Salesforce
Is there a built-in way for us to take a user to the data that they drill down to, and in my case, using the Case Safe Opportunity ID field, have it be clickable to launch them into SFDC to view the opportunity/account details?
-
Add formula syntax error
Hi all, I am brand new and trying to swim in the deep end and don't have knowledge of SQL so struggling with how to write a case/formula for one of my ETL transformations. I want to create a column with a constant based on values in a column, essentially: If the value of column A equals ONEY or CMDU than 45, if not than 30…
-
Combining data into one pie chart
I'm looking to combine data from 6 sources into one pie chart. All data will be coming from Pipedrive but each dataset uses different filters. I have setup an ETL which goes through each filter, I'm stuck on working out how to combine the data into two columns (stage and number of panels). Is there an optimal way to…
-
Calendar Creation
Hello - Can I create a calendar table based of a start date and end date? I have the start date and end date that encompassed a week, and then the columns for sunday to saturday what I am trying to achieve is, to put dates as well to the columns for sunday to saturday for example: the start date is 9/4 and end date is 9/10…
-
Find most recent transaction - Dataset View
I have a dataset with item receipt dates by branch. I need to find the most recent receiving event for each item by branch. The dataset has about 7M rows, and my thought was to do a dataset view, rank the receipts by branch & item descending on the receipt date. I can't seem to get the calculated column to work. Any help…
-
Calculate one value against multiple values in different columns
I'm trying to find the min. the value between column 1 and a range of numbers in different columns. For example, is the difference between column 1 and column 2 less than the value between columns 1 and 3? Any suggestions on how to do this?
-
Aggregation on Lag/Lead functions
I used the Lag function to operate a subtraction between data point and previous data point. However now I need now the average for that new column (which I am not able to do in Beast Mode) Any suggestions
-
Datasets join issue
I'm trying to create a card that can be used to present to budget owners how much they have currently spent for the month compared to the budget they've been given. In order to do so, I have to create a dataflow that involves joining 2 datasets; One is Netsuite, which stores all the journal entry transactions, and the…
-
What is the best way to parse URLs?
I currently am bringing in data from google ads and one of the columns is `landing page url`. I am trying to parse this row from: https://m.ufhealth.org/uf-health-pregnancy-care?utm_source=google&utm_medium=tj%20ppc&utm_campaign=fy21%20ob%20services&gclid=EAIaIQobChMIo7Hl4pCq8gIV_21vBB1iYQ_JEAAYASAAEgJD3fD_BwE to uf health…
-
Attempting to create unique rows for each possible value in a chosen column
Our business model currently offers multiple product options. I'd like to create brand new rows for each customer, 1 for each product, whether they own that product or not. My thought is to use new columns and then use a dynamic unpivot. Need help creating the new columns first though.. Currently have this: Account Product…
-
Joining 2 datasets based on between condition.
Hello, I have two data sets that i would like to join based on a between condition. The "Join data" available in the ETL shows only inner & outer joins. Where can i do custom joins? Here is the detailed scenario. dataset A has 2 columns - clicks, date dataset B has ID, start date, end date. I need an output with B.ID,…
-
Join with Between Clause in Magic ETL
I am working on converting some Redshift dataflows to Magic ETL 2.0 dataflows. I have a join statement in Redshift that looks like this: SELECT d."province_state" , c."Category" as SeverityRelativityCategory , n."Category" as SeverityRelativityCategoryMinusNY FROM "ihme_covid_19_population_death_shares" d JOIN…
-
Reduce ETL Processing Time
Hi Everyone. I'm looking for strategies to reduce the run time of Magic ETL 2 data flows. I'm working with several left joins in sequence on about 17 datasets of 1 million rows each. Beyond this, the ETL performs no other operations. I'm curious if anyone has experience with these options: Data fusion Adrenaline Redshift…
-
Division of Values
Hello Domo Ninjas - I'm trying to get a new value from a dataset, where I'm dividing 1 column by another. Its a strange way of measuring how much Sales is adding on Services to Product deals. I'm getting errors both in Beast Mode, when I try MOD(ProdSales,SvcsSales ) And in DataFlows when I add a Calculator, attach it to…
-
Python Tile
Tring to split the values in a column into multiple rows using explode and I keep getting an error. I am not too familiar with the python tiles... The value in my row will be "A<br>B" and I want them to appear as two separate rows, one with A and one with B. Getting error: "00:00:01.817 domomagic: Version 0.3 00:00:01.819…