-
Fiscal Year filter filtering Score Card dynamically?
I have a dataset with these column: Month End Date, YTD_Amount, Month, Fiscal Year, FY End Date. I want to make a score card that show the YTD amount dynamically by Fiscal Year. For example: - if FY = 2025 (FY Year End Date = 2025-01-31) → score card should show the YTD_Amount when Month End Date = 2025-01-31 - if FY =…
-
Beastmode DomoStats Dataset?
I know that Domo has a beastmode manager where you're able to see all beastmodes. However, I'm wondering if there's a domostats dataset where I can see all the beasmodes created, who created them, and if they're saved to the dataset or not. If not is there a way to export the data within the beastmode manager? I'm trying…
-
Beastmode Editor Resizing
Could the beast mode editor be made resizable in Analyzer? We often need to see fields or data in the analyzer chart / table whilst editing but as this is not currently resizable we have to close out of the editor each time we want to view the data. This simple addition would save time and effort. Thanks
-
Sales Modeling Correction Calculation in Pivot Table
I am doing sales modeling in Domo and have a column for model (`Account Payments (cash, model)`) and a column for actuals (`Account Payments (cash, actuals, projected`). For my forecast I project the actuals to the model for the months that have not yet occurred. My issue is that my actuals are outperforming the model and…
-
YTD calculation breaks when using Month filter in Domo – best practice?
I have a YTD Performance card that includes the following metrics: Actual Budget Projected EOY Accruals Variance (Actual vs. Budget) On the dashboard, there is a Month slicer that allows users to select values such as Jan 2026, Dec 2025, Nov 2025, Jun 2025, etc. Requirement The requirement is to display Year-to-Date (YTD)…
-
Card filtering to the most recent row based on rank
What I'm trying to achieve: Get the rows with the latest/smallest rank per user based on a given date. I created a calculated field called "Indicator" and I filter on it as "Indicator = 1". I wanted this field to indicate 1 when a transaction is the smallest rank number for a user and 0 if not. What my calculated field…
-
Why does my Beast Mode concatenation fail when individual elements work?
Hello. I have a Beast Mode calculation with the following general structure: CONCAT( DATE_FORMAT((CURRENT_DATE() - INTERVAL 1 DAY),'%a'), ': ', COUNT(CASE WHEN (DATE(`Opened At`) = (CURRENT_DATE() - INTERVAL 1 DAY)) THEN `Opened At` END) ) Note that there are just two calculations there. The full version has many more, but…
-
Business days only gets 72 hours not 96 as it should for 2 weekends 1,7 twice
Case when Days Calculation_Trouble3 = 'Business Days' then SUM(ROUND(DATEDIFF(End Date2, Start Date2) * 0.7142164 + CASE WHEN WEEKDAY(End Date2) IN (1, 7) THEN 1 ELSE 0 END * 0.5004537 + CASE WHEN WEEKDAY(Start Date2) IN (1, 7) THEN 1 ELSE 0 END * -0.2910912 + 0.4646935,-0.2910912 + 0.4646935)) / COUNT(DISTINCT LocateID)…
-
Make Dynamic Date/Time Functions Respond to the Company Time Zone
The dynamic date and time functions—such as CURRENT_DATE() and NOW()—are represented in UTC, regardless of the Company Time Zone in your Admin Settings. This creates a problem during the hours of the day when the UTC date and your company time zone's dates are unaligned. For instance, say you have a Beast Mode that uses…
-
Domo Community Declining - Oliver to Blame?
Hi my fellow Domo Sapiens, I've noticed a drastic drop in community activity now that the chat agent, Oliver, is present on the landing page and able to help answer questions. "Softball" questions (easy ones that I could answer) are less common now that Oliver handles the easy ones. While I do appreciate the efficiency of…
-
Filter Out Incomplete Months
I'm having trouble with this line chart. I need the line for the current fiscal year to terminate on the last completed month of the fiscal year. I'd even be okay if it terminated at the end of the current month. As you can see in the screenshot, it graphs to 0. I'm not sure what the best way to do this is. I'm also…
-
Using email connector- Gathering data from Subject Regex
Hi guys, I'm using the email connector to obtain my data. In the subject of the email, it displays a different version number for each email. Within the email connector settings, I'm using the "\d{2}Q\d)\s+Version\s+(\d{3} for the"Attachment Name Expression" section.. However when creating my cards and a data table, I…
-
Beast Mode for Rank
I'm trying to create a rank from highest to lowest based on a value, but my dataset does not have a date field. Most community examples use date based window functions. Is there a way to rank values without a date column?
-
Issue with CASE WHEN statements -
Hi, I keep getting a syntax error notification for my beast mode, but cannot figure out why. Could someone tell me what I am doing wrong? I am trying to write a forumla to obtain the count of all records where column_a = value_1 . Can you tell me where my syntax error is? COUNT(CASE WHEN column_a = 'value_1' THEN 1 ELSE…
-
Selection of Beast Modes in Beast Mode Manager
Hi, If I have to transfer Beast modes to another dataset, at moment we can only select 100 beast modes at a time. We need select all or deselect all beast modes option for a specific dataset. Thanks, Tejal
-
Keyword filtering on all columns..it just works
Hi all, just sharing a solution I worked through a couple of weeks ago that was intended to allow the user to filter on a keyword or partial word as a dynamic filter on any or even all columns in a dataset. You will need the following: Free Text Variable – This is what the customer will interact with Coalesce() – Returns…
-
Search for keyword (from text input variable) in a phrase
Hi all, I am trying to find a way in Beast mode in which a user can input a text(keyword) in a box and then the formula would search the phrase to see if that keyword exists. The problem I run into is that I need to add '% and %' respectively to a custom variable as part of LIKE. Can something like CHAR(37)& custom…
-
Paired coloured brackets in formulas
Would it be possible to implement paired coloured brackets into beast modes and Magic ETL formulas (a la Excel)? This would make it far easier to work with large and complex beast modes, especially with only single-level nesting currently available.
-
Calculating A Total Time Based Off Multiple Values
I may be overthinking this but hopefully someone has a suggestion. I have a dataset where I need to take the total time of two tasks, only if they are part of the same ID and completed by the same Name. (ID is based off of an overall order where the task is one task within that order.) Screenshot below shows that I would…
-
Beast Mode Data Type filtering and reporting
Could the Data Type of beast modes be added to the Domostats report and also added as a filter property in the Beast Mode manager?
-
How to get YOY NRF Comp date data next to Filtered date
Shopify Created/FC Order Entered Date NRF Order Enter LY Date TY Units Booked(Order Entered) LY Units Booked(DesiredOutcome) 11/7/2025 11/8/2024 966 1,200 11/6/2025 11/7/2024 1,295 1,201 11/5/2025 11/6/2024 1,154 1,202 11/4/2025 11/5/2024 1,130 1,203 11/3/2025 11/4/2024 1,479 1,204 11/2/2025 11/3/2024 2,475 1,205 11/1/2025…
-
Can you change the number type using variables?
I want to change the number type when using variables (switching from currency to percentage to numeric) depending on the selection. Is this possible? If so, how?
-
The Comparative Gauge chart is showing the % change incorrectly
The Comparative Gauge chart is showing the % change incorrectly in my card. I set the Previous Value to 6-week Average Sales and the Current Value to Last Week Average Sales. Both Beast Modes work correctly on their own, but the Comparative Gauge is displaying the wrong percentage. For example, last week’s sales were…
-
Visualizing a Case Statement into a Table
Hello, I have a beast mode that utilizes a case statement that groups all results that have 'Unknown' in the name to be mapped to 'Unknown' else it'll show 'Known' I am trying to figure out how I can represent each count and % of Unknown and Known by US state within a table. Ideally there will be 4 columns: 1 column to…