-
Case within case in beast mode
Hello, can someone help me with an issue with beat mode - I am able to successfully validate the formula in the beast mode, however when I use the calculated column to the chart, it throws an erro - would you'll know why this happens? (CASE when DAYNAME(WEEKDAY(DATE(`itm_snapshot_date`)))IN ('Saturday') and…
-
Create a dynamic date range with a beast mode
Hi, I want to create a dynamic date range to capture the following period: 100 days ago excluding the last 4 weeks (28 days). The date I want to use is signup_date. Is this possible with a beast mode?
-
Domo Governance Datasets
Hello everyone, Just found out this amazing Domo Governance Dataset connector. I was looking through it and wanted to see if this connector can answer the below question. Is it possible to see all the datasets which has a particular segment(adobe) or metric. Please let me know if any one have tried this. TIA
-
Select specific columns for join in Magic ETL
Hi, I am using Magic ETL for the first time and I am using two datasets and a left join to combine the two. I only want to left join one column from the 2nd table, but I cannot find where I can select for that in Magic ETL
-
Changing the order of a name - from surname, first name to first name, surname - can it be done?
Hi, I've got a dataset that has the first name and surname comma separated but with surname first ie: Lewis, Danny Whereas I ideally want Danny Lewis Is this possible in Beast Mode? If not how would I transform at ETL level? Many thanks in advance! D
-
Power Users
Hi, I need to create a chart as the one attached, this is a “Power User Curve” — also commonly called the activity histogram or the “L7”. It’s a histogram of users’ engagement by the total number of days they were active in a week, from 1 day out of the week to all 7 days. The difference with WAU is that I will need to be…
-
ETL Missing Data - Assistance Needed
Hello, I am in need of assistance on trying to figure out why my ETL is some data. (I have tried a Data Fusion as well) I have two tables/datasets where it is from tblCoverage left joined to tblProfile. Both tables are linked by a unique vendor code. tblCoverage has a column named 'State' where it shows what state a vendor…
-
Need to control a recursive with a Timestamp
@here I'm doing a recursive to build client data over time and using the Date of incoming calls as the match column to determine duplicates to be excluded. However, sometimes the data changes, so what was going to be 2.7% on 8/15 has been changed to 3.5% on 8/15... hence the datestamp. How do I build into my recursive the…
-
Bar Chart with pre-set category
I have data in the following format: PersonStarting PointCurrent PointJohnUnit 1Unit 4JaneUnit 2Unit 5JoeUnit 1Unit 3SueUnit 4Unit 8 I would like to create a bar chart showing all the units (50 of them) with the number of people who started in each unit and how many are currently in each unit. There will be some units with…
-
Conditional ETL Run
Hey experts I have Sales data for US states with two columns - State, Sales. The data is received in Google sheet and I want to make sure that there is no typo in the State column, prior to using it in Magic ETL. I created a master data that contains all the correct state names. I then right joined my Sales Data with…
-
Recursive Data Flow Renaming Output DataSet with "1" Rather than Input
After running the ETL and Adding the Output as an Input, Existing Output is renamed rather than the Input. Why is this occurring? See attached.
-
Help with Beast Mode
Hi there, I'm a newby with Beast Modes and could use some help please! I created this Beast Mode which tells me the reject % for January. It works fine but I would like to modify it so it gives me the YTD average. Any help would be really appreciated. THX!!! CASE WHEN ifnull(SUM (CASE WHEN `Month` = '1' AND `Event Name` =…
-
Salesforce with date stamp
Anyone has any experience visualizing salesforce data with date stamp? I am trying to see how our total # of leads is progressing for each month. It seems to me that I have to join the salesforce data with domo calendar to do so. Basically, I need to be able to see what was the # of active leads in any given month in the…
-
Simple beast mode - two case statements inc IN wildcard
I've hit a roadblock on a very simple beast mode I'm trying to create. I wish to sum a value based field based on two filters, one of which has a wildcard required, due to messy data (to be fixed at a later date). Where I've got to is: SUM(CASE WHEN `Budget Segment` IN ('%REL%','%SMB%') AND `Advertising Line` = 'Non…
-
Beast mode calculation based on Time range
I have a data set which consists of two columns - user_Id and visit_date on the site. the user id remains same for each user i.e if a user login in January for the first time and user_Id 123 is assigned, then for all the subsequent visits on site, the user_id would remain the same irrespective of the visit_Date. My…
-
Date Range Buckets
Hello, I am trying to create a way to look at upcoming estimated shipping dates but I keep getting an "error during processing" . I have made buckets for WIP based off days in shop field and basic case formulas in the past with no issues (See attached). I think I am having issues with my approach due to this being dates…
-
MySQL Recursive CTE - Date Range Split
Hi, I am having trouble setting up a recursive CTE with MySQL dataflows, I have seen various articles on recursive dataflows on Domo but do not think they will be much help here, so I am turning to SQL. We currently have budgets corresponding to different campaigns over various date ranges. And example of this is below:…
-
Percent Rent Change by date period
Hi, I am trying to show how much the rent increases by a percentage each year/month. Would like help learning how to create beast mode to show this change. Please see attached image! Thank you very much
-
Hide a column data fusion
Hi, Currently handling tremendous set of data in the data fusion, I would like to hide some useless columns. I went to the edit DataFusion where the joins are made and below it should be the place where we are able to hide the rows. However the display won't show. I wonder if it was because of the amount of data that I…
-
Shopify - Month over Month % Change Beastmode Help
Hello, I've tried to use this formula but it isn't working: I'm trying to calculate the % change MOM for count of customers. This using Shopify orders datasets. (COUNT(DISTINCT CASE WHEN ((year(`processed_at`)=year(curdate())) AND (month(`processed_at`)=month(CURDATE()))) THEN `customer_id` END) / COUNT(DISTINCT CASE WHEN…
-
SQL Data Troubleshooting: Neither Date Filter Nor Conversion Rate DataFlow Calculation Working
Hello DOMO Community, Questions: 1. Can you tell me why person_created_date is not filtering >= 01-01-2019 results? -As you can see in the screenshot, the person_created_date is returning results prior to 2019. 2. Can you tell me why my SQL is not grouping the data by lead_marketing_channel in Domo Analyzer? -As you can…
-
Differences in values in columns that were pivoted using ETL Pivot option
I am trying to pivot a column in order to aggregate the corresponding values, but I'm noticing big differences in each of the columns in preview or when I download the data onto an excel file.
-
Option to Remove the 10,000 Duplicate Error for ETL
Because of how fast/easy ETL flows are, I prefer to use them for most flows. My problem is that sometimes I hit the following error, "Error joining data. The left input cannot include over 10,000 duplicates. Please switch your inputs, group your data, or remove duplicates before joining". The Dojo suggests that this error…
-
Concat Summary # Issues
I'm having challenges getting my custom summary # to populate correctly. Below is my calculation, removed secure info with xxxxx. The formula is valid, but I'm just getting a result of 0 on my summary # without text or calculation. What am I doing wrong? CONCAT(avg (CASE WHEN `Offering Class Number` = 'xxxxxx' AND `Dim -…
-
Beast Mode windows function
Hey there I am trying to do a 5 day rolling change in value based on usage. I want to show previous five days compaired to the newest date. I have tried this beast mode: ((Lag (`QUANTITY`,5) OVER (Order BY `TimeStamp(use)`) +Lag(`QUANTITY`,6) OVER (Order BY `TimeStamp(use)`) +Lag(`QUANTITY`,7) OVER (Order BY…
-
Percent- Count Greater Than - Beastmode
Hey everyone, Please view screenshot below. I am trying to find the % of `Secondary Paid` that is above 0. I have been able to break it down with a few different beast modes but I am still not able to get the % of the total that is above 0. Paid = When `Secondary Paid` >=1 then 'Paid' Test = When(`Secondary Paid`)> 5 then…
-
BM Calculation Aged Incidents
Hi I am trying to calculate which of my incidents are Aged (over 30 days old from the current date), I have cobbled this together but it can't be working as I change the number and get the same result CASE WHEN DATEDIFF( CURDATE(),Max(`created_at`)) > 30 THEN 'Aged' ELSE 'Not Aged' end Could somebody help please? Kind…
-
How to transpose rows to columns using ETL
Hi, I have a large dataset that has thousands of rows, most of those rows have the same value for most columns except for one. I'm trying to transpose the value from the rows that are in one column to multiple separate columns, removing the duplicate lines. I know the "Pivot" function in ETL is what i need to use, but i'm…
-
Beast Mode: Sliding Window Function with Partition?
@jaeW_at_Onyx this is probably right up your alley with recent Dojo solutions and videos you have put together. Please see my video linked below, and attached sample data. https://youtu.be/Y21fV4t5kGk I have been able to do this with an ETL so for those that want to know how that is included in the video. I would prefer to…
-
Visitor Frequency Beast Mode & Card building
I have an activity log for every activity a user creates on our website. I want to calculate for a time period the number of users that have visited once, 2-5 times, 6-12 times and 13+ or some such off the activity date and user ID. In SQL I would create a dataset of visits by user ID then group by that - however I want to…