-
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…
-
Variables Don't Have Filter Settings
I want my variables to only affect certain cards. The Filter settings are available for normal filters and on the cards themselves, so this doesn't seem like a heavy development lift.
-
NUMBER_FORMAT function
Please consider the implementation of a NUMBER_FORMAT function in Beast Mode in the same vein that we have DATE_FORMAT and TIME_FORMAT. This would take a number, and based on parameters, format the number (add thousand separator commas, percent sign, currency sign). Numerous discussions have been had in the forums about…
-
Color Rules for Gauge
Request to add color rules for data points calculated using Beast Mode as opposed to data included in the chart for the Filled Gauge chart. In an effort to create a dynamic color rule for the Filled Gauge chart, I created color rules that correspond to a Beast Mode ratio of new users / day. However, the Gauge Values need…
-
Global Column Rename
Idea: I’d love to see a feature in Domo that allows us to rename dataset columns once, and have those changes automatically reflected everywhere that column is referenced (cards, drill paths, ETLs, beast modes, etc.). Problem Today: When we want to rename a column (for example, changing “Parent Account” to “Parent…
-
Adding Calculated Total Rows in a Pivot Table?
My sample dataset: Pivot table using Region Code Name & Account as Rows, MTD as Value will show just like the picture above. However, I want to add calculated total rows, so that my pivot table would show like this: individual Region Code then the Total for each Account as each row. Is there away to do that with Beastmode,…
-
Incorrect total when the field used is a beast mode using a case statement
I have the below beast mode that is created using fields that are all fixed by their various dimensions. `Expected Cost` CASE WHEN SUM(Revised Estimate (fixed by Estimate)) = 0 AND SUM(Cost to Date (fixed by GL)) <> 0 THEN SUM(Cost to Date (fixed by GL)) WHEN SUM(Cost to Date (fixed by GL)) > SUM(Revised Estimate (fixed by…
-
Beast Mode Folders
Hi, It's been more than a year since this post (https://community-forums.domo.com/main/discussion/66358/navigation-q-a-from-domopalooza?utm_source=community-search&utm_medium=organic-search&utm_term=beast+mode+folder ), I'd like to check if the folder functionality for beasts mode has been implemented. At my organisation,…
-
beast mode below works but is erratic
((SUM(CASE WHEN Disconnects IS NULL THEN 0 ELSE Disconnects END)) / (SUM(SUM(CASE WHEN ServiceStatusValue IS NULL THEN 0 ELSE ServiceStatusValue END)) OVER (ORDER BY BillingPeriod) + SUM(CASE WHEN Unique Count ServiceID IS NULL THEN 0 ELSE Unique Count ServiceID END))) * -1