-
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…
-
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…
-
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…
-
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.…
-
Sorting Year date Filter in Ascending order
Hi All, I have a beast mode created as CONCAT(YEAR(`pickupDATE`),'-',MONTHNAME(`pickupDATE`)) which in turn returns values such as 2020-April, 2020-june and so on...When I try to display this as a quick filter I get the values displayed in the quick filter in my card in random order -such as 2020-April 2020-August…
-
Pass Logged In User to Beast Mode?
Hi all, I am looking for a way to show total sales performance for various items relative to individual users performance for their own sales performance. Please see attached image for a better illustration of what I am trying to accomplish. In this example, I want to pass the logged in user name into a case statement.…
-
Fix Beast Mode version of YEARWEEK() to match Magic ETL (MySQL)
In MagicETL, YEARWEEK() is a MySQL function. I understand that the function has been re-created for use in Beast Mode. I believe most users would expect the two functions with the same name on the same platform to give the same results. Unfortunately, the results are different. Issues I've encountered: For 2024, the week…
-
Are You Sure? Beastmode Safe Exit
After writing a Beastmode, I shouldn't be able to click outside of the dialog and have the beastmode completely scrapped. There should be a 'draft' option or a 'Are you sure you want to leave?' come on! This is basic UI stuff.
-
beast mode question
Hello everyone, I'm having an issue trying to get this beast mode calculation validated. We have tickets that is suppose to be updated but we want to track tickets that are not updated within 4 hrs. And we want a color change when ticket is about to breach 4hrs with no update. I wrote this but getting syntex error. if…
-
Mega Table Rank interactions with PDP
Hi all, I am trying to build out a dashboard that lets vendors compete with each other in a mostly anonymous way. One example would be a section that shows the logged in vendor their 7 Day Sales Rank, compared to their 28 and 91 Day Sales Rank. Key requirements: Vendors should be able to see their rank only; not any of the…
-
How can I set up a graph to show period over period data in a dynamic way?
I am looking for a way to show a bar graph with sales data by period and a growth rate line with period over period percent change. I have a detailed dataset with a large amount of sales data spanning over multiple years. I am having trouble with how to get the prior period data to be on the same line and to be dynamic so…
-
Multiple results encountered for the same location in Pivot Table indicated by ****
Attached is a sample of my data. I am trying to create a pivot table with the following: Rows: location, week, date, shift Columns: count(unique identifier), count(unique identifier) * shift length In my ETL, I created a formula to handle empty values. It determines whether a shift was 8 hours or 10 hours, based on a…
-
How to create WoW, MoM, QoQ, YoY dimensions to put into variable?
I want to create a dimensional variable that allows users to choose between WoW, MoM, QoQ, and YoY using the chart types below. What is the best way to go about this? Any tips on creating the ETL to create the components above?
-
Best Practice - Columns to Rows?
Community, My data is formatted per my example screenshot below. Is it best to pivot each location into rows, or is there a benefit to maintaining columns for rows? I will need a total number, and then drill down numbers (I.e. Total Net Profit = 30 > Drill Down > Omaha Net Profit = 10)