-
Dynamic variable used in Beast Mode but does not need to be visible on the individual card when e
The variable is currently used in a calculated field on the card which makes the dimension control visible. It needs to remain available for dynamic selection but the selector itself does not need to be displayed on the card during drill-down. Controls cannot be removed from the card unless the variable logic is first…
-
Annualized Trailing Twelve Months Financial Reporting
I need to know if there is an easy way to create, either within Analyzer or using an ETL, that will allow me to create a financial report showing an Annualized trailing twelve pivot table (or just a table). The attached example is showing a trailing twelve months (one month per column), but I want the columns to show the…
-
Conceptual Understanding - Group Bys & Aggregations
Hi Domosapiens, I've struggled with this concept since I was a wee lad in the data world. All these year later, and it still doesn't make sense to me. This table has the raw data in "Charge Total Amount". The "Monthly ROI Numeraor" has the Charge Total Amount TIMES the Variable that is open input. (for reference, in the…
-
Issues with Pivot Tables - Comparing multiple years financial data by month
Hello, I am struggling to get my data to show up properly in this pivot table. Not sure why, but I am getting an error that Multiple results have been encountered.. Somehow it is getting a total for the 'NewMonth' field, but it can't pull the individual Fiscal Year totals. Happy to give more information to the calculations…
-
Beast Mode Created & Modified Date in Domostats?
Can we get the created and Last Modified Dates added to Beast Mode Domostats report as this is needed for auditing and validation? Thanks
-
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.