-
newbie - Simple beast mode calc not showing in Summary number
Newbie here... I am simply trying to divide a field by a number to convert total seconds into Hours: `calendar_duration`/3600 Calendar_duration is a number. The calculation works but does not show as in the summary number section. Must be simple syntax to fix this. Sorry I am new to SQL code Thanks,
-
Combining Beast Modes - Converting Week
Hey everyone! I am trying to combine these two beast modes but am having a hard time getting it to work. DATE_FORMAT(SUBDATE(`Submit Date`,WEEKDAY(`Submit Date`)-1),'%m/%d/%Y',DATE_ADD(`Submit Date`,27 day)) Is the beast mode I am trying. below is the two separate that I am wanting to combine. DATE_FORMAT(SUBDATE(`Submit…
-
Beast Mode add output to input
I am trying to make the output of an ETL the same as the input, the idea is that this runs once a month and adds the month stats to itself, and just build up. However when I set the output to the same as the input it doesn't like it and renames it. How can I have one Dataset which I add data to ? Thanks
-
Using average formula for a calculated column having sum and count
Hi, I am trying to get an average of a calculation having a sum and a count used in it. something looks wrong considering it is looking at the avg and then sum, can someone help me with this? or suggest an alternative if possible? AVG ((CASE when SUM(`ext_sls_a`)/ COUNT((CASE when `listing_status`='APPROVED' AND…
-
Custom Sorting
Hi Everyone, I followed the steps outlined here: https://dojo.domo.com/t5/iSolveditwithDomo/How-do-I-Create-a-Custom-Sort/m-p/45500#M13 but cannot get my custom sorting to work. Chart: Heatmap Data: Google Ads Data, broken out by date and hour. I attempted to do custom sorting for Day of Week (using a date transform) and…
-
How to add month over month and year over year column to data table
Is it possible to add percentage %change for current vs previous month in a column next to my current table data? My current data set is set out as shown below. Any help would be greatly appreciated! Domo analyzer view:
-
Date_ADD / CONCAT MONTHNAME - Syntax Error
Hey Everyone! I am trying combine two different beast modes I am already using and keep running into syntax errors. DATE_ADD(`Submit Date`,21 day) - Used to add +21 days to submit date for new date I am wanting to add CONCAT(MONTHNAME(`Locked`), (CASE WHEN DAY(`Locked`) <= 15 THEN ' 1st - 15th' ELSE ' 16th - EOM' END) ) to…
-
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…