-
Beastmode for multiple row comparisons to one source row?
I'd like to add a third column in a table visualization that displays the % change for the current week to each previous period listed. What's the best way to create a beast mode for this?
-
Comparing monthly income in a certain year to the same month income in previous year
Hello! I have a dataset which contains departments, dates (several years, daily) and income per that department & date. I'm trying to build a table that has departments in the rows and monthly income as values. The columns are a certain year and the previous year. Tried with Sum and Lag. How do I do that?
-
How to compare Value Columns
Hi, Beginner to DOMO so excuse the question. I've created a Pivot table with 2022 sales vs 2023 preorder sales by account and would like to add in a % difference column at the end that shows whether an account is up or down for 2023. How do i go about adding that?
-
I need to create a dynamic report that shows me data between 2 and 5 days ago
I've tried a variety of methods but can't get seem to get it accurate. Any help would be appreicated.
-
Capture Duplicates in DOMO
Hi DOMO - Is there a way to do this excel formula in Beastmode? =COUNTIFS($A$2:$A$8, $A2, $B$2:$B$8, $B2) basically, it shows the duplicates based out of 2 columns. what we have is the Name and the Title and the location we want to see how many names have the same title for example: Peter Manager San Francisco Peter…
-
I'm stuck. Sum of a Windowed/Partitioned Sum???
I keep running into a wall with this. I think there is an easy answer, I just can't find it for the life of me. My dataset contains one row per store, per day. I want to display -- by region -- the count of stores with an average order value (AOV) less than $20. In order to do that, I first need to calculate AOV by store…
-
Filtering Rows without Displaying Them / Same-Store Comparison
I have a dataset of sales data with one record per store, per day, across multiple years. I used @jaeW_at_Onyx's offset date table solution to get YOY and POP comparisons; but I'm not positive that's relevant to my [hopefully simple] question. I'm trying to create a filter for same-store comparisons. I am defining…
-
Removing Duplication and Ordering Objects within a Concatonated Field
Hello, Our company offers several different product lines and I am attempting to count how many times each combination is owned. There is a field that comes through to Domo from a SFDC connector with this information, but there is a ton of duplication within as a customer can own multiple of 1 product. Example: I'm…
-
How to create a column which SUMS based on the grouping of another column
Hello, I am trying to write an ETL which sums a value based on the grouping in another column (invoice number) which yields a column with the total quantity for each invoice. i have attached a simple table as an illustration of what i am looking to achieve. I do not want to write a formula where i have to continually…
-
Convert all dates to last day of year
I am trying to convert all my dates to the last day of the year in a beast mode. I have a column in my dataset that is already showing the year for the data and have tried this STR_TO_DATE( CONCAT(`YEAR`,'-',12,'-',31),' %Y-%m-%d ') It doesn't seem to work. Any help would be appreciated
-
I have an unexpected outcome of a beast mode calculated column, can you help?
Hey, I've been working on a dashboard that has a radio selector to select which project the dashboard presents data from. In this process, if an option is not set on the radio selector, my dashboard populates with "Please filter on Project" on most of my cards except one which is not behaving as expected. For context, each…
-
Beastmode for Datetime to Group by Month in a Mega Table
Hi. I need to create a Logins by Month Mega Table. I have a datetime field for each login. I want to create a beastmode for the month of the login so that I can count by month. I want this column to sort correctly. I am having some trouble finding a good way to write the sortable beastmode for Login Month. Any ideas?
-
DOMO Groups
Hi DOMO Team - Good Day! I just need some help with regard to groups. we created a list of new groups for all our people and created a card to show all the groups that they are in and it shows that including the new group that we put them in. we would like to create a Beastmode where, when this person is in their 'legacy'…
-
Beast Mode Case Excluding Certain Strings
I'm trying to build a beast mode that outputs a value when one string of text is found and another string is NOT found. How do you do that in Beast mode? See example of what I'm trying to do down below. I included that minus in front of the semi to indicate that I do not want that string of text to be included. CASE WHEN…
-
Is there a way to filter out integers that are longer than 7 digits?
Hi all, So I am working through an ETL and the logic needs to be able to include the bottom two values into a bucket but take the top two out. I am using a formula that looks something like this: what it really need to be is: when `loan number` like '5%' and less than 7 digits then '' is there a way to program that into…
-
How to count distinct based on the sum of another column?
I dataset with a list of "pulls" for each day and the "setter" associated with that pull. I have a calculation through the ETL for this dataset that sums up the total sales per setter for the previous 30 days. My objective is to count the number of distinct setters who have a sum of 0 total sales for the time range…
-
Waterfall/Retention Ratio in Beast Mode
Here’s the situation I’m in: Let’s say I’m trying to create a visualization for hiring positions for a team. The dataset I’m working with has each observation as an interview. So the columns of the dataset would be something like: Name, Gender, Location (State), Education Level, Interview Round. Interview Round is one of…
-
Export card to Excel using API
I have a card containing numerous beastmodes and I can export to Excel through the UI and maintain the look of the card as well as all the filters. Is it possible to do this same action through the API? From the documentation I only see the option to query datasets, which we have done extensively, but I would want to query…
-
how can i create a calculated field based off buckets?
Hi all, Recently I created pricing buckets for the amount of loan a borrower took out. This works Right now, we have two different visuals that show 2021 vs 2022 This is ok but we would rather be able to see both of these graphs in one with the different years in different colors. Is there any way to do this? The only way…
-
Beast Mode FIXED functions multi-field question
So we're all aware of FIXED Functions and how neat they are as outlined in domohelp. But one example that I have not seen yet and I'm not entirely sure how to do is a multi-field FIXED function. In this example I have a simple dataset that's Halloween themed The question is: "Everybody always yells 'wherewolf' but nobody…
-
Ghost Beast Modes can not be viewed or archived in Beast Mode Manager
When executing bulk archiving for a client, we found a few ghost Beast Modes that no longer exist (or are not accessible in the Beast mode manager or cards). They are still selectable in the Beast Mode Manager, but can not be archived or viewed. The error message we received when click this beast mode is :…
-
How do I write the syntax for YOY % change?
Hi all, I am trying to create a calculate field where I am able to see only the change from year to year in average purchase price. I understand the math to be purchase price1 - purchase price 2 / purchase price 1 but I am not getting the correct output when I try the syntax Here is what i have so far: Any suggestions on…
-
How do I format?
Hi all, I am working to generate a report but am not sure how to calculate in Domo to get the visualization right Right now, we are looking a property type breakdown by year - included on the y-axis is the number of loans we had each year. We are trying to keep the years on the x axis but only show the property type…
-
Trying to Count the number of Appointments in my data
I feel like this should be simple but I'm struggling with how to write the beast mode to where I get a whole number and not an average. I'm trying to count the total number of appointments in my sales data. This is what I've written: Count(`Bay Text`)/(COUNT(DISTINCT`Invoice #`)) I've attached a photo showing what the data…
-
Need help with beast modes to show yesterday's invoice total amount, and same day last year
I'm trying to create 2 beast modes to show yesterday's Total Invoice Amount and same day last year's Total Invoice Amount. For example, 10/27/2022, and 10/28/21 Yesterday: case when year(`INVOICE_DATE`) = year(CURDATE()) and MONTH(`INVOICE_DATE`) = MONTH(CURDATE()) then `INVOICE_TOTAL_AMOUNT` end --- This formula works…
-
Can someone help me with the syntax?
I am trying to get the percentages of each of our fields displayed in a table but I have to take column 1 (delinquent payment 2) and divide by column 2 (loan id) when I run just the first line, I am able to get the correct calculation but I need to get all of the values calculated so I can display them on one table. Any…
-
How to make my BeastMode dynamic
Hello DOMO Dojo - I have a beast mode that deals with dates, I am wondering if there is a way to make the date dynamic Here's my formula>>>> (case when (`TC: Created Date` >= '10/1/2025'and`TC: Created Date` < '1/1/2026') and (`TC: End Date`>= '7/1/2025'and`TC: End Date`<= '9/30/2025') then 'Q4 2025' when (`TC: Created…
-
Card updates later in the month than other cards - Beast Mode to keep previous value until update?
Good morning, I have a dashboard with cards set to update once the month turns over - however several of the cards display data that update about seven days post-month change. During that seven-day period, the cards display no value. Is there a Beast Mode that would allow for the cards to continue to display the prior…
-
Calculating percentage corresponding to blank cells
Hi all, I want to calculate percentage of the events count in my dataset like below Here, we can say for the month of August, there are 67 events with flag=true. Hence, we can see 100% displayed next to it. Similarly, for the month of September, there are 3 Outcome2 events with flag=true. And the percentage comes out to be…
-
New Beast Mode Format - Save as calculation on dataset
I think the 'Save as calculation on dataset' should be up next to the 'SAVE CALCULATED FIELD.' I've already forgotten to check the box numerous times because the notifications cover it at the bottom.