-
Rolling Averages Feature
I was looking for a more flexible way to create rolling averages. Of course possible in a Domo Dataflow/Magic ETL → but then you need to fix it on the periods you want to "roll over". Is it possible in a beast mode or is there maybe a card type/feature that makes it even easier?
-
Beast mode referencing
Hello, I wonder why this won't work. I get that the CASE WHEN can't have MAX() within it, but I thought by referencing the beast mode that uses the MAX() would process it as a subquery that references the output value instead of the formula MAX(). If this wouldn't work, is there an alternative to this? I needed the…
-
Nested fixed functions
Hi All - We are using fixed functions to calculate the average LTV per year for certain audiences. In the end, we want to be able to sum up the averages into a total 4-year LTV for the audience, which requires another fixed function. However, we're hitting errors when we wrap our calc in the new fixed function to sum up…
-
Returning the number of days in the selected date range
It would be great to be able to call for the specific date range (and number of days) selected in a beast mode so that my visualization would dynamically update the calculated field as the date range was modified. My recent use case was a turnover rate calculation where I ultimately had to divide by the number of days in…
-
Branching/Hierarchy in Pivot Table, Mega Table
Hello, Is there a more elegant solution to create Branching/Hierarchy in a Pivot Table (or any other table)? Something to look similar to this: This was created using the Formula Editor in ETL, but I don't like the solution and was hoping for something more elegant and flexible:
-
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…
-
Starting Day of the Week - Monday
Hello, can anyone help me find a solution on how I could start with Monday for the weekly data? My data is dynamic, so it has to update on a weekly basis - I used Last 4 weeks. I have a table with weekly data showing like the one below, and when I created a bar chart in DOMO, originally, when graphed weekly, it will start…
-
Dynamic Goal line on a bar chart
I need to create a goal line dynamically on a bar chart. I have used scale marker in properties, but it is giving a static line. Can someone please suggest how can we achieve dynamic goal line. Thanks
-
Need help with Date Range/ Period to Date
As you can see top right, Domo has a selection Date Range, Period to Date, and if I click on Week to Date, my 3 cards will update date dimension to current Week to Date, Month to Date, Quarter to Date. I'm trying to create a filter or a button to do same functions Period to Date: WTD, MTD, QTD, YTD without clicking on Date…
-
Beast Mode Syntax
Hi, I am trying to create a column that shows the year that a financial instrument was created and then I need to add 3 to it. It is going on the bottom of the x-axis so it will show up like '2022-2025' , '2023-2026', '2024-2027', etc. The problem when I go to write the beast mode below is that it thinks it is a math…
-
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…
-
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…