Dataflows
For all your Beast Mode, Magic ETL & Dataflow Questions.
Discussion List
-
Return AVG DayNameHey I was wondering if there is a beastmode windows function that would allow me to return the avg … -
% of TotalHey there, I'm trying to create a % of total column for my dataset with various domains. Issue is,…
-
Beast mode for rolling count of purchasing customers within a specified period month over monthI'm trying to develop a beast mode formula to help me derive count of customers who have purchased … -
Beast Mode Appears to only be Calculating First PartI have a beast mode that calculates the number of units based off the Period (month) and how far in… -
When x is null and y and z is not null then case statement - multiple parametersHey there I'm trying to perform a case statement in magic etl using the formula widget. I'm trying…
-
Beast Mode duplicated in New CardHello, I'm relatively new in DOMO and while creating new cards off other existing cards the Beast … -
Year filter on YOY comparisonHi All, I have card that I need filtered by chosen years. I have a 5 year data (2017-2021) and… -
Ignore some filters (not all) in Beast Mode aggregationHello, I have been searching around for a similar posting, but have not been able to find one descr… -
Need to pull specific months from my Date column using BeastmodeHey there, I'm trying to pull all dates from October and another from November. YEAR(`date`=&qu…
-
Cumulative total of users with activity dateI need want to see how many active users we have over time. I have a field "last_activity_at&q… -
Long running ETL flows alerting strategiesAny strategies i can employ to alert myself whenever a query that generally takes seconds to run r… -
Error in Case statement in BeastmodeHi there, I'm getting this error when creating a case statement in Beast mode. Hoping someone can h… -
How to read and understand error messages in Domo dataflows? (Redshift)Hey, I am creating a dataflow and using redshift for my transformations. I am getting this erro… -
Card from Outer Join Two Datasets ETLI'm trying to join two datasets, each dataset has a date field, how can I join the date field to ge… -
Prior month metrics beast modeHi, I have a pivot table card which displays Last month projects, Projects 2 Months ago, Delta Pr… -
Round to Millions in ColumnHi, I want to round currency to millions ("$1,500,000" becomes "$1.5M") for… -
Redshift does not sort properly in a dataflowHi I have the following query, which I sort by id and date. The id is sorted properly however the d…
-
Time Difference larger than 24 hoursI have two date columns, and I want to find the time difference between them. Sometimes the differ… -
Breaking out a stringHi, I have product information that is a string seperated by commas. I wanted to take the firs… -
Simple DATEDIFF QuestionAs I understand it DATEDIFF will return (in number of days) the difference between two sets of date… -
Dropping rows with null values (postgres)I am building a redshift dataflow and found that the following statement allsow you to delete whole…
-
Copy Beastmodes to New DatasetI have a case where I have a dataset that has to large of a date range that is causing a query to r… -
Creating a Table in a Redshift FlowCan I create a table, insert rows and call it, all in 1 transform in a redshift dataflow? -
Alternative to beast modesHi, We have a few beast modes with pretty lengthy list of our clients and we update it frequent…
-
Agrupación de varios datos en categoriasNecesito ayuda para agrupar datos en categorías. ejemplo: 1. Lic tiene 50 datos disprsos y de… -
Where Do SQL Transform Changes Take Place?I am currently building a dataset that requires me to insert a dummy row if a specific date does no… -
ETL Pivot HelpGood morning, I have something I'm struggling with. In my screen shot attachment, the top t… -
Beast Mode Calculation for Specific Email DomainI have a column called Owned by Email and I want to create a calculated field that displays "Y… -
Unique Records in Beast ModeI have three topics/cards with id's 11631,11634 &11636 and I have many users who completed thes… -
Copying dataset pdp settingsIs there a way to copy pdp settings between datasets?
