-
Run rate beastmode calculation
Hi all, trying to formulate a beastmode calculation to give me weekly run rate so I can do a WoW chart. No matter how I modify the query, I keep getting a "Calculation Error : All fields must be aggregated or in the group by clause". This is the first time I am seeing this error. Any insights and advice would be…
-
Beast Mode Calculation ID to Beast Mode ID
Hello, I'm running into an issue implementing Sandbox repositories on objects that have been in production for a long time. Specifically, I'm creating sandbox versions of cards that are using Beast Mode calculations that were originally created on other cards, and therefore they are not migrating to the sandbox datasets…
-
Dashboard Table using previous day values in calculation
Hi, I need to create a Dashboard that calculates oil usage for Engines. Below is the excel table with calculation I need to recreate in Domo. Basically need to take the tank level and oil added to day tank and engine from day before and subtract today's tank level to get daily usage. Also sometimes there wont always be a…
-
Getting syntax error to calculate MOM change
Can anyone help me what syntax error is there in this beast mode calculation? CASE WHEN LAG(Weighted Average, 1) OVER (ORDER BY Sort: Month Number) IS NOT NULL THEN (Weighted Average - LAG(Weighted Average, 1) OVER (ORDER BY Sort: Month Number)) / NULLIF(LAG(Weighted Average, 1) OVER (ORDER BY Sort: Month Number), 0) ELSE…
-
Help in Pivot
Hello, Requesting help on how to resolve this and appreciate your assistance. My data in the table has Year, Quarter and all the measures. But user is requesting the report to be in the below format. Measures/Metrics on he left side while Timeframe on the top as columns. I am unable to do this in Pivot table view in the…
-
Data Structure Issue
Short version: how do I check if a field is a valid date? Long version: Using the NetSuite connector, our data has a field called Period. The connector does not allow me to define the data structure. I tried admin » toolkit » schema management. It doesn't hold. If I force the dataset field to a string, the next run it puts…
-
Compare a beast mode to an arbitrary date range
I've been asked to create a trend that shows the number of open projects (y-axis) for an arbitrary date range(x-axis). A sample of my data looks like this: Project_ID Date_Opened Date_Closed 1 1/1/2024 4/5/2024 2 1/18/2024 4/6/2024 3 2/2/2024 3/1/2024 4 2/9/2024 5 2/27/2024 6 3/14/2024 4/20/2024 7 4/3/2024 8 4/11/2024 9…
-
Beast mode for help Sorting column
I need a beast mode so i can sort a column. I need to take the number out of this Engine column so then can sort in order. I have values like this Engine 1 Engine 2 Plant Engine 1 Engine 3 Plant Engine 2 Engine 4 Engine 5 I figure if i can just do a formula to take out the number then i can sort them together based on…
-
What is the problem with my beastmode?
I am trying to make an outlier flag that flags values 50% above of 50% below the budgeted, or daily goal mount. I made two threshold calculations(dailygoal / 2) & (dailygoal * 1.5). I keep getting an error message, but I am not sure what I am doing wrong. Any suggestions? Thanks, and my sql command is attached below. CASE…
-
Expose date filter's start & end date inside beast mode
The date range filter will always have a start and end date. I would like Domo to expose that start date/end date inside a calculated field as variables. My workaround is to have the same variable for fixed date ranges (MTD, YTD, etc) This would not be the case if Domo exposed the date filter variables inside Beast Mode…
-
Hidden Beast Mode Functions
Hello, I was wondering if anyone created a list of hidden beast mode functions like Partition By which is not shown in the function list, but it works when we actually use it.
-
Percentage of values in a column
Hello, In the beast mode how should I get the percentage of column totals like below, 50 hours worked is the 12 percent of the total hours (410). I need to create a column like % Hours so that I can make further calculated fields based upon that. Provider Hours worked Total Tickets % Hours % Tickets John 50 20 0.12 0.10…
-
Beast Mode Details
Beast Modes tend to be created to test an idea then abandoned. We have several cards with multiple Beast Modes that are not actually used on the card. We would like to see some level of Beast Mode tracking where we can identify those that have been created but are unused either on the card or embedded into another Beast…
-
sec_to_time() Is adding an unnecessary period to durations
I'm using sec_to_time(`SessionTime`) to convert an integer of seconds into a duration however when a SessionTime should end in a single digit amount of seconds say, 5 seconds "12:45:05" the beastmode field is displayed as "12:45:5." This creates an unnecessary period and shows an inconsistent format. The result should show…
-
How to aggregate a case statement that uses a fixed function
Hello, I was hoping somebody could help me understand how to sum the following case statement. case when `Date` = max(max(`Date`)) fixed () then `On Hand by Day - DO NOT SUM` else 0 end I need the calculation to be dynamic and reference the date selected on the card. All attempts to aggregate the case statement fail and…
-
Add REGEX functions to Beast Mode
REGEX functions are currently supported in the MagicETL formula tiles, but not in beast mode. It would be helpful to have these added to Beast Mode.
-
How to extract a substring from an URL
I'm trying to extract the substring from an URL. Input: www.abcd.com/level1/level2 The output I'm looking for is essentially taking from the first character to the position of the second '/' minus 1. I wonder how to write the formula in beast mode. Desired output: www.abcd.com/level
-
BeastMode: New Field with Multiple Column Criteria
Pretty sure doing in ETL would be preferrable however looking for a short term approach as our dev resources are tied up. I have a data set something like the picture below. Its a data set that displays ALL USERS that have access to Application 1 (App 1). It Also shows when a user is a manager and the client they are a…
-
How can I avoid denominator should not get filtered while calculating the percentage in beast mode
Hi, I have a column name 'Order' with 1 to 6 values in it. I need to calculate the percentage of order 1 and show this percentage on a card in the dashboard. This percentage should change dynamically when the data gets refreshed. I am taking unique count of orders having 1 divide by total count of orders. when i am…
-
Beastmode to display Unique Values of a Dimension
In a mega-table in Domo I have a table like in the attached picture, and I want to add another value After "Inquiries", "Core Leads" and "MVA Inquiries". That value is a Dimension called "Creative Name". All of the Creative Names within a given week will be the same. So I'd just like the table to display that unique value,…
-
Expanding Beast Mode to formula
With the new nested beast mode feature, we can use an existing beast mode in another beast mode. But sometimes it is helpful to see the formula of the old beast mode, and not just the name. Adding an option to expand a beast mode field back to the formula by double-clicking the name could be useful in some cases, and can…
-
Percentage of values in a column
Hello I have a data set with a column name Sale_Type. I want to create a beast mode to use in a table chart that shows the percentage of each sale type in the column. Example of what I am looking for below.
-
Step Ratios - Pivot Table
I have a pivot table showing total number of applicants through the recruitment process. I want to be able to show the "step ratio". Pivot Table has Steps in the rows, column is job type, values are a distinct count of candidate ID. Dataset has multiple rows per candidate, each step of the process they've reached. Im…
-
Case Statement - 28 Days from a specific date?
Hi All, I need to write a case statement that would calculate 28 days from a selected date. How would I write that? The end result would be total sales within the 28 days going back in time from the date selected. Thanks, Paul
-
Syntax Error in Beast mode calculation
CASE WHEN Sort: Month Number = 1 THEN NULL ELSE ( (SUM(All Cases) - LAG(SUM(All Cases), 1) OVER (ORDER BY Sort: Month Number)) / LAG(SUM(All Cases), 1) OVER (ORDER BY Sort: Month Number) ) END I'm not able to figure out what is the syntax error over here. Can anyone please help?
-
Show the Average in Bar Graph (Days/Hours/Minutes)
Hello. Can you help us find a solution how to display the output we want to achieve? This is the current output that we have, but we wanted to see a view using bar graph. The problem is that, the values are 'string' and not 'numbers' because of the concat function we used in beastmode to identify whether the computed…
-
Looking for highest volume by a specific day as well as highest volume during a specific week
Hello, I am trying to take the data below and generate which day of the week has the average/max/min on volume. I would also like to know the average/max/min by day of the week and week of the month. How would I go about doing this inside DOMO? Essentially I would like to be able to answer the business question as follows:…
-
Returning a Max Result in a column
CASE WHEN D's % of AOR = MAX(D's % of AOR) THEN 1 ELSE 0 END Some how this is returning the total for the column. All values are returning a 1.
-
Date Beast mode
Hi everyone, I have a pivot table which contains plan data. The key point is we need to allow one month post plan completion to allow for data collection and input. Country Plan Name Start Date End Date Status Delivered data available Austria Plan 1 1st Jan 2024 1st March 2024 COMPLETED YES Malta Plan 2 1st Jan 2024 1st…
-
lookup function in beastmode?
Hi all, I have a table that has these columns: loan number other loan number first principle balance hi type description 2nd mortgage amount is the field we are trying to create The logic is such: when hi type description = '1st mortgage' and other loan number is > 1 then i want to look up the first principle balance of…