-
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…
-
Sending email alerts to specific users based on dataset email field
Hi everyone, I have a dataset which looks like the following: EmailRunning Latest VersionVersionfred@email.comYes2.1bob@email.comYes2.1angela@email.comNo1.0tran@email.comNo1.5 I would like to do the following: If someone is not running the latest version (Running Latest Version = No) then send an email to the person as an…
-
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…
-
Beast mode to calculate month over month user count changes
One of the metrics we calculate as a business is our user change month over month. Our main data set we work off of is an activity log dataset which contains the date of the activity, the user id, and details about the activity. For active users we calculate the distinct number of users for that time period such as the…
-
Nested IF AND for Columns in a Pivot Table
Hi, I have an IF AND nested Excel formula I am trying to recreate in Domo. I want to create a new calculated field that classifies the order submission activity for the prior whole 7 months. This is what the result would look like for each of the options. Assume that May just started so we are just counting October through…
-
Creating Buckets in Beast Mode
Hello! So I'm trying to create temperature buckets in beast mode. Here's my formula: case when (`temperature` >= '33' and `temperature` <= '39') then '30s' when (`temperature` >= '40' and `temperature` <= '49') then '40s' when (`temperature` >= '50' and `temperature` <= '59') then '50s' when (`temperature` >= '60' and…
-
Create Data that does not exist
Hey all, I am working with some usage data for some of our products. What I am trying to do is be able to flag if there is zero usage on a account. our daily files only include usage but not if there is no usage. I have contract End dates that I can use to say something like if contract is active with no usage pull that…
-
Rename the week # for the X-axis
I have a bar graph showing data point in a weekly basis. I did graph the chart by week so the x-axis is showing week #1, Week #2 and so on. When the week # gets bigger it gets harder for people to know which week lands on which month. Is there anyway to relabel the week # to say week 27 of June 28th with a beast mode? or…
-
Fusion, how many rows is too many?
I have been watching @jaeW_at_Onyx on Youtube and am seriously excited by his data fusion methods. I would like to mimic his how to build a Trial Balance, Income Statement and Balance Sheet with no ETL but have 28 million rows in my GL. Would it be more efficient to split said 28 million into yearly chunks, first using a…
-
Beast Mode % of the total in Chart
I want to create a calculated value that show the % of the total. I have done this: SUM(Case WHEN `Country` LIKE '%In' then `Value` ELSE 0 END) / SUM(Case WHEN `Country` = 'TotalIns' then `Value` ELSE 0 END) But it displays anything although the formula is correct. I tried using only the first part of the formula and it…
-
nested if statement
I am trying to write a beast mode that would replace the following nested if statement out of excel: =IF(I8121="Total SS",M8121*12,IF(I8121="Total PODZ",M8121*12,IF(I8121="Total 5+1 ",M8121*2,IF(I8121="Total 3 Pack",M8121*4,IF(I8121="Club Pack",M8121*360))))) how would I format that beast mode? thank you for your help!!
-
Prepare Trial Balance using Oracle Managed Cloud data
We have migrated Oracle Managed Cloud data to DOMO and now trying to develop a Trial balance report. I have added an attached query to create Dataset. When I run the data set it is running continuously and no completion. I tried creating a small query to run but still the same issue. I am using MYSQL for the query. The…
-
ETL Addition empty fields
I am using addition to calculate 2 columns into a calculated column "Total 3". Example: Total 1 | Total 2 | Total 3 1 | 2 | 3 2 | 2 | 4 1 | | 4 | 1 | 5 Problem is I don't have data in every row. So as you can see the third one here results nothing instead of 1. 1 + "blank" is still 1. But it returns an empty field. Any…