Dataflows
For all your Beast Mode, Magic ETL & Dataflow Questions.
Discussion List
-
Is there an alternative of distinct on for redshift?Hey, I am trying to build a dataflow using redshift but distinct on is not supported. It's a simp…
-
How can I create a new column with extracted numbers in SQL or ETLI have a column called 'description' which can contain multiple elements. One of them is 'Order #1…
-
Cumulative Count by MonthI am looking to obtain a count of all dates that are less than each month on a table. Please see at…
-
What are best practices for combining huge datasets in Domo?We have been using Domo for nearly a year now and are heavily utilizing DataFusion and Dataset View…
-
Record count for prior month or prior quarter at start of the yearI have a Beast Mode that I've been using that was working fine up until January 1st. The issue is t…
-
How to build data and rankings for pivot tables in DOMOHi guys, looking to build week on week report, but not sure what type of DATA format I should pre-c…
-
Calculate percent of wholeI have rows of client data with 2 fields `weeks` and `recommended_weeks`. I would simply like to k…
-
Using PyDomo to get dataflow informationI can pull down the dataset list just find, but the metadata function doesn't return anything about…
-
How come MySQL does not support window function, specifically lag in dataflows?Hi, I am currently building a dataflow and trying to get the best out of both sql dialect. I us…
-
Reference dataI have multiple datasets and cards. In one dataset I have a beastmode where I calculate the Custo…
-
Max Case StatementHello! I would like to create a beastmode that will calculate the case fill percentage for the …
-
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…
Hey, Stranger!
Categories
- 5.5K All Categories
- 10 Domo News
- 8.2K Using Domo
- 1.5K Dataflows
- 2K Card Building
- 1.1K Connectors
- 298 Workbench
- 640 New to Domo
- 78 Dojo
- Domopalooza
- 1K 日本支部