-
RANK Issues
Hi I'm trying to create a Rank, but sometimes it works others it doesn't don't know why, I have customers and I want to be able to filter by the top 5 customers based on Shipments I have tried multiple formulas and the validation works, sometimes the table works but the filter does not work: This are the formulas I have…
-
Calculating a % based on multiple dates
I would like to create a beast mode that calculates the % of the way we are into a campaign. In Excel, I would calculate this as =(TODAY()-'Start Date') / ('End Date' - 'Start Date') Here's what I have so far (I want this to return a %): (SUM(IFNULL(CURDATE(), 0) - IFNULL(`Start Date`, 0)) / NULLIF(SUM(IFNULL(`End Date`,…
-
Beast Mode is Inaccurate
I have 2 Beast Modes that are returning inaccurate results. If I place each Beast Mode in a separate column in my table, they both return their respective values of 01 or 02 for every line even though they are opposite and even though not every line meets either criterion. Any suggestions? Thanks! CASE WHEN GL Group Code…
-
return a percentage for a measure
I am trying to create a calculated field that will give me the percentage of share for the column total i.e. taking the unit from one data point of measure and dividing that data point by the total of that measure. Is that possible?
-
Real null count in dates
Hello everyone, I am trying to get an accurate count of the number of blank cells for a column inside an ETL prior to using a formula to estimate the date in the event that it is blank. I included a test output dataset inside the ETL to track the number of blank cells as well the estimation before/after creating a new…
-
Average Count Distinct across Date Range
I am working on Turnover metrics and need to capture the average unique headcount of employees over a user selected date range. Here is what I've tried, but Domo keeps giving errors: COUNT_DISTINCT(CASE WHEN (Team Member status = 'Active' OR Team Member status = 'Unpaid Leave') AND Date BETWEEN 'start_date' AND 'end_date'…
-
Turnover Beast Mode: Avg Distinct Count / Days in date range
I am attempting to create a Turnover Rate beast mode that would take the Average Distinct Count of employee IDs, then divide it by the number of days in the user selected date range. I've tried the following syntax, but I receive an error: Raw syntax: AVG(COUNT(DISTINCT CASE WHEN Team Member status = 'Active' OR Team…
-
Calculation error: Duplicate calculation name
Hello, sometime ago I noticed that when I am trying to update the existing beast mode calculation on validation step it shows me error message "Calculation error: Duplicate calculation name". The calculation itself is working and when I create a new calculated field with same formula but with different name I can validate…
-
Check for condition against the whole
Assume the dataset I am given looks like the following (below). My downtown store was flooded in 2023. Some of my customers may have moved their shopping uptown. I need to filter the list so I only see customers that had "Downtown" amounts in 2022, and also had "Uptown" amounts in 2023. In the scenario shown, I expect to…
-
NESTED BEAST MODE
Hello guys, I am little confused with how this new nested beast mode function behaves. My understanding is this was here to help using other beast modes in other calculations easily. I have a beast mode calc which works perfect: To prevent me from retyping the case statement above in another beast mode, I could just call…
-
How to calculate count of Devices as per country using beast mode ?
In above screenshot, I want Italy should show 4 Devices Thank You!
-
Validate Syntax
Good day, Just want to confirm if my syntax is correct? CONCAT(FLOOR(([record_age] / 86400000)), ' days, ', FLOOR((([record_age] % 86400000) / 3600000)), ' hours, ', FLOOR((([record_age] % 3600000) / 60000)), ' minutes, and ', FLOOR((([record_age] % 60000) / 1000)), ' seconds') I was intending to convert a milliseconds…
-
Using pfilters with more than one value
Hi, we have this dashboard with several card filters and we want to click in one "button" that would open the same dashboard with all the filters applied. We know that this is able to do it easily by creating a BeastMode with pfilters as shown here and in the @MarkSnodgrass video. However, we are not able to find a way to…
-
Creating a Beast Mode to calculate field sums for remainder of year
Hi - I am trying to write a beast mode calculation that sums a field from an as of date until the end of the year. The variable is indexed across the year and want to count how many are left depending on what date is entered. For instance if 1/22/24 was the date it would count all the values indexed for the variable until…
-
Beast Mode for same date check
I have a list of companies and their create date. I want to create a beast mode that checks if a list of companies has the same create date. Any help here? Would this need to be done in Magic ETL?
-
Average Loan Size
How do I calculate the average loan size using a histogram
-
Date Reference Exclusion/Inclusion
I'm attempting to write a beast mode that checks a static date with a dynamic minimum date. If the static date is greater than the dynamic minimum date it would be classified as 'No' and vise versa. The beast mode formula: CASE WHEN Onboarding Date <= (MIN(MIN(Report_Date)) OVER()) THEN 'Yes' ELSE 'No' END When I use the…
-
beast mode calculation
Hi Everyone, Thank you for assisting me the last time and hoping the community can assist me once again. I have a table that shows the rows of sites along with columns of how many tickets are associated to the sites and the ticket numbers. The data I need are only for sites that have 3 or more tickets. I've tried filtering…
-
A filter based on weekday or wknd
I have a column with tasks and there are certain tasks I want to see if the current day is a weekday and if the current day is a weekend day id like to see other tasks. Could someone help me with this?
-
Min(Date) Question
I'm having issues getting my beast mode to show the earliest displayed date. In the attached screenshot I would like the "Test - Min(Report_Date) column to all be the same date (2023-01-01) I've tried the "Min()" function and it appears to only check for the earliest date in each row, not displayed date on the card. Any…
-
Calculate correlation coefficient in beastmode? Do not want to use correlation chart.
Hi, I need a formula in beastmode to calculate the correlation coefficient between two variables? Thanks, Paul
-
SEC_TO_TIME Not Displaying in HH:MM:SS
Hello! I am attempting to use the sec_to_time to convert my duration in seconds to HH:MM:SS although, I can not sum duration as it duplicates and when I apply just SEC_TO_TIME(`duration_seconds`) the calculation displays as 'count' and does not display as HH:MM:SS. When I do (SEC_TO_TIME(SUM(`duration_seconds`) it…
-
Column Total Greater than Sum of ROWS
Why is "# Houses" Column Total Greater than Sum of ROWS on "Closed Punch Tickets by Plumber" Card BEAST MODE for "# of Houses": COUNT(DISTINCT(CASE WHEN JT158_WTParent = 'Y' AND HdrParentItemCode = 'ZPUNCH' THEN SalesOrderNo END))
-
Column is Adding rather than giving Average
Why is AVG Punches Per House giving a total of Column and not Avg but PUNCH SCORE Column Total is giving AVG. PUNCH SCORE Beast Mode 10 * (COUNT(DISTINCT SalesOrderNo) / COUNT(DISTINCT sonum_wtnumber)) AVG Punches Per House Beast Mode (CASE WHEN HdrParentItemCode = 'ZPUNCH' AND JT158_WTParent = 'Y' THEN…
-
Pfilters
Hi, I just watched Marks video about how to use pfilters so I thought id give it a shot with this beastmode. CONCAT('<a href="https://trimble-tt-16502962.domo.com/page/2050403531?pfilters=[', '{%22column%22:%22Lane%22,%22operand%22:%22IN%22,%22values%22:[%22', `Lane`, '%22]}', ']" target="_blank">', Lane,'</a>') The output…
-
Average Date Calculation
Hi, Is there a way to do an average date calculation in Domo? I am working with a table that has close to 30k rows and all we are trying to do is get an average date for the date column. Is this possible? I looked in the beast mode functions and could not confirm it was in there. Thanks
-
Difference of values between 2 months
I have a value column named 'Value' and a month column named 'Month'. I want to create a beast mode to calculate the difference between values of the last two months. So if we have two months in the dataset - Nov 23 and Oct 23. I will want to calculate the difference in value between both months. It is a month-to-month…
-
I want to understand average sales within 1 year of client sign up
I have a dataset where each row is an individual sale that contains the sale date, client start date, client ID, and sale total. I want to be able to chart the amount an average client spends within X time of their start date where X is a variable that I can alter from the card. Ideally, I'd be able to split the ouput by…
-
How to calculate % change between these two years in a beast mode on several columns of data?
-
How do I set up a Beast Mode to count distinct events within a date range?
Hi Domo geniuses, I have a dataset with a timestamp 'Start' field that tells me the date and time that a user session began. There's another column for User Session ID, which has its own unique ID. I want to count the number of distinct user sessions in the first year but Domo is having difficulty processing the data. The…