-
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?
-
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…
-
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…
-
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:…
-
Beast Mode: Why am I not getting the correct number of enrollments per academic year?
I created a Beast Mode calculation to extract the academic year based on term codes. For example, to derive the academic year 1955-1956, I identified these three term codes: 1555, 1561, and 1563. 1555 is Fall 1955. The 2 digits in between are the year. (The last digit ‘5’ represents Fall). 1561 is Winter 1956. (The last…
-
Multi-value Columns Gauge Card | Compare between Current Headcount vs. Dynamic Historical Month
I have a situation where I am trying to show how the Headcount moved by comparing Current Month Headcount with any of the historical Month which the user will select. The problem that I am facing is that when any period gets selected Current Month Headcount calculation becomes Zero. My dataset is very complex and massive…
-
CurDate Beast Mode Showing Tomorrow's Date
Is there a way that I can ensure the curdate function always uses EST time zome to return the correct date? For instance, at 8:50 pm, the cur date function is displaying 2/4 when I want it to display 2/3.
-
Custom Formula Default Selections for Slicer/Filter Cards
Currently, Domo’s slicer/filter cards require manual selection of default values, which can be limiting for use cases where the default selection should change dynamically based on the current date or other conditions. I propose the ability to set dynamic default values for slicers using conditional logic. For example,…
-
Need help with specific code that is not working in either beast mode or magic etl formula tile
Hi the following code I am using as a filter on my card and have it set to "on list" its called skus to be purged "CASE WHEN On Order = 0 AND (Future Demand = '' OR Future Demand IS NULL) AND (Future Books = '' OR Future Books IS NULL) AND (Reserved + WMAVAIL <= 10 AND WMAVAIL > 0) AND WAREHOUSE_CODE = 11 THEN 'On List'…
-
How to get Prior Year Values on the same table row
I’m trying to create a row which shows the “Prior Year” value against a field for comparison, simply a 12 month offset of the data as shown below with the "Value" field. This would later enable me to create YoY differences. I will also note that I'm looking for a solution that should be able to transcend filters i.e. you…
-
Is beast mode needed?
Hi Everyone, I created a card that uses a date_time_start dimension along with a ticket count on a metric table. This card shows the number of tickets that have a scheduled dispatch showing date and time. What we want to do is turn past tickets to red except for today's and we used the Last 7 days by hour but the date…
-
When a value in column B appears multiple times against a value in Column A concatenate those values
Hi I'm really struggling with my dataset as I have a many to one relationship between the DIVISION and CUSTOMER columns which causes issue with grouping later in the ETL How do I write a formula which will affix the Customer name with the Division name if the customer appears against 2 or more Divisions else if the…
-
SUBSTRING Query (9 day n00b question)
Hi I've only been using Domo for about 9 days so still very new to this but I am trying to use the SUBSTRING function to return the values in my ID column to ignore everything before and including and underscore as this value varies in character size (example EN_, ENR_, ENO_) How do I get the ID column to return the values…
-
How to Implement Pagination in Table card of the Domo?
I have a dataset with columns: country, state, city, area, population, latitude, and longitude. I want to create a visualization in Domo where: A slicer filter is available for the 'Country' column. Below the slicer, there is a table that displays data for each state in the selected country. The table should show one…
-
Beast Mode Help - Pull Last Day In the Period
Hello DOMO Community, I have a dataset that keeps a running total of users by day. I need a beast mode that pulls the last value from the running total column for the filtered period based on date. EX if the filtered period on a card is 5/25/24-11/16/24 I need the beast mode to return the running total value from 11/16/24.…