-
MTD and YTD TOGGLE
HI Team, I have a date field and what I'm trying to do is write a beastmode that looks at YTD and MTD without years. I have successfully done that in 2 separate beastmodes to give my a 'Y' or 'N' toggle. However when I try to combine them into one where the user can toggle 'YTD' or 'MTD' the 'MTD' isn't the issue.. it's my…
-
Replicating multiple Excel Calculations as rows of data - Beast Mode?
Hello, I've got multiple datasets (actually customers) that we calculate a few things with separately. I was able to get all of the datasets (customers) combined so they could all be on one table: Typically what I do in excel is from those numbers I'll pull a few different things out: I'd like to basically mimic these…
-
Combining Filtered Rows to one table
Hello, I am using one dataset for all three cards shown below. I have them on separate cards right now as they each are filtered to different things. Is there a way I can combine them so they would all show on one card/table together with one heading but show the three rows one under another with their filters still…
-
Calculating YTD for each week in table
Hi, I want to replicate a table that looks like this: My dataset currently has date, impressions, and goal, and in ETL I've mapped the dates to a week by joining with another table. How would I use beast mode to find the impressions to date for each week, as well as the delivery percentage of goal?
-
How can I set up a text box Variable that can search for a text string in a field?
Hi Domo Community, Like the title says, I'd like to set up a Variable to be used in a dashboard where users can input text and it will search for the text string in related reports and return the results. For example, I have a "Description" field for items. I'd like to search "6mm bolt" in the Variable/text box and have it…
-
Dynamic Positional Inventory
Hi, I am looking to create a pivot table that is able to handle positional inventory dynamically. For example, if I have 3 weeks in my filtered range, I want to only show the data on the last week. I am using the below. CASE WHEN Week ending date = MAX(Week ending date) OVER () THEN SUM(ifnull(EOH Qty,0)) ELSE 0 END This…
-
Cumulative Sum for the Year on a table card
I want to create a table card that has a line for each month-year for all sales and show total $ for the month, a running total of $ for the year (up to that point), total quantity sold for the month, and a running total of quantity sold for the year (up to that point). Example: Month-Year | Monthly $| Running $ | Monthly…
-
AVG() Beastmode Handling 0s?
Hi All, If have a dataset with duplicate IDs (required) and a metric - let's call it "total apples" against each ID (so also duplicated) The goal is to get the average of this meric but only considering the trend of distinct IDs overtime. I've labelled each distinct ID (using row_number over create date partition by id)…
-
MTD and MTD Last Year, leap year problem
I want to show sales MTD and MTD Last Year as of Feb 28, 2025 so I created Beast Mode: MTD = CASE WHEN CURRENT_DATE >= SHIP_DATE and CURRENT_DATE <= LASTDAY(SHIP_DATE) THEN 'sales_amount' ELSE 0 END MTD Last Year = CASE WHEN DATE_ADD(CURRENT_DATE, INTERVAL -1 YEAR) >= SHIP_DATE AND DATE_ADD(CURRENT_DATE, INTERVAL -1 YEAR)…
-
Customizable Average Calculation
I have a graph that calculates the hours of different job types. Since DOMO has a label feature for %_PERCENT_OF_CATEGORY, it would be helpful if DOMO could add in the grid line settings an option to allow users to choose different options for calculating the average. In this example we are calculating the average value in…
-
beast mode using window function as a filter
Hello, I have a beast mode that's very important to calculate the summary number correctly. I can't find any alternative to this. However, it is using a window function and I'm wondering why it won't appear if I tried to add it as a filter in the card or dashboard. I can add it in the quick filters pane of the card, but…
-
Setting up a rolling sum based on date
Hello, We are trying to set up a beast mode or ETL Formula that will be able to calculate a rolling average of leads based on the last 30 days and the last 90 days. Ideally we would want to be able to compare the average number of leads for the last 30 days to their rolling 90 day average to see if the client's lead…
-
Filter Line without Column Turning Blank
Hi All, I'm using a calculation with a variable (see below) to select designed time periods and need to remove my revenue line (Hierarchy = Revenue) however, when I add filter "Hierarchy Not In 'REVENUE'" the column using the below formula returns BLANK for every row in that column but does not cause any of the other…
-
Apply a % Model based on an identifying field
Hi All I've got a challenge when trying to apply a sum(max()) value to my card as there is a variable I can't identify correctly In my data (anonymized) I have the following columns I need to use for this: [Customer], [Model Type], [Model %], [Master Description], [Sub Description] What I need to do is, when a [Customer]…
-
MTD & MTD Last Year Beastmode that calculate the ratio
so I have a beast mode that calculates the ratio of committed orders % committed count = SUM(CASE WHEN % complete > 0 THEN 1 ELSE 0 END) / COUNT(Order #) but I want to create a Beast Mode to calculate the same ratio but just for this MTD, so I tried this, but it return 0 CASE WHEN YEAR(CURDATE()) = YEAR(MONTH_END_DATE) AND…
-
HTML Beast Mode help
Is there a way to add a colored line below a number value on a card? or even a "line break" colored line? I am trying to use beast mode/html to create a blue line to add below the SUM value of the card. I am currently using a single value card with: 'CONCAT( SUM(Actual_Count), ' <hr style="border: 3px solid #30B0E0; width:…
-
How to Filter for "Today AND Last 7 Days" in Domo Visualizer?
Hi everyone, I’m trying to implement a date range in Domo (using `Reservation Start Date`) that includes both Today AND the Last 7 Days at the same time. This will be for a weekly scheduled send. I know Domo has built-in filters for "Last 7 Days" and "Today," but I can't find a way to combine them in a single filter within…
-
Beastmode to flag an item if the date is longer than a week from the current date.
Hello, I am trying to write a beastmode to 'FLAG' and item if the submission date is longer than a week from the current date. How would I proceed? See below for my current beastmode that flags something if it does not fall into the current week of the current date. My thought process is if the date is longer than the…
-
Using Average on Beast Mode
I want to calculate the average number of semesters that students with bachelor's degrees have completed. Below is my Beast Mode calculation. However, it currently counts all semesters (or terms) a student has attended, even if they pursued additional degrees after earning their bachelor's. I only want to count the…
-
Running Into Error with BeastMode and Table
I'm working on a beastmode where I am trying to assign a label to individual orders based on their price_tier and their Product Name. If an order's price_tier is equal to the MAX of the price_tier for a Product Name, I want it labeled "Sold". If an order's price tier is less than the max, I want it labeled "Discount". And…
-
How can I utilize double case statements in a beastmode
I want to create a beastmode where it calculates something like the below: when segment = A then calculate the amount moved from A to B when segment = B then calculate the amount moved from B to A (image below) How can I calculate this using the beastmode functions?
-
Datasets API - Get Metadata - RequestedParts
The documentation for the dataset-get-metadata endpoint here indicates that the "requestedParts" parameter can be used to specify which parts of the metadata are needed in the response. However, the documentation does not indicate list of accepted values. The sample request below also indicates a different param named…
-
Omitting rows in pivot table
Any way I can omit this section in a pivot table but keep the 2021 Total?
-
Beast mode - no aggregation
Hi Everyone, I created a pivot table that will show the cost of dispatches. Please see below: one of the values that we are using is called Number of Ports ( blue Value that says COUNT of Nu. ) and for some reason the number does not populate any data even though on our tickets it shows a number. And maybe because that's…
-
Seeking Best Practice Advice: Reporting Financials in Domo
Hi community, What is best practice for reporting financials in Domo? Currently, we have raw financials, account by account, fed in through a simple CSV. There are no summaries in this CSV, so I have to aggregate them with Beastmodes to get to summary numbers. For example, EBITDA is calculated as such (see code below) This…
-
Running Total Beast Mode with Fixed Functionality
I’m working on a running total Beast Mode that tracks ticket sales by event. My current formula works fine: SUM(SUM(tickets sold)) OVER (PARTITION BY EVENT ORDER BY DATE ASC) However, these events reoccur yearly, and I want to compare ticket sales pacing to previous years while maintaining drill-down and filtering…
-
Partition in Beastmode or Possible Another Solution
Hi, I have a dataset that joins spends from our Facebook account by date with leads that came in that day. Since we have multiple leads per day the "Facebook Spend By Day" will be in the data set multiple times. In a beast mode I want to get a look at the total Facebook spend all time. I am using this right now:…