-
Getting the last field of a character-separated string
I have a field that has an odd structure. It looks like this: asdfas\\qwerqwer\\..\\vcbnvcn To be clear, the .. means that there's an arbitrary number of double-slash separated strings, not a literal double dot. Also, each field can be of arbitrary length. I need the last field. In the example, I need to return vcbnvcn.…
-
DOMO Groups filter
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'…
-
Need help with Weighted Average
I have only been working with domo and formulas for a little over a year. And some formulas are really mind boggling. For Example, I am trying to get the Weighted average for an employees overall all performance. Normally in Excel it would look like below, I have searched through this forum, and on Google, to see what…
-
Line graph - two date ranges
Hi, I have two date ranges (Planning Determination Date & Appeal Determination date) that I'd like to display on a line chart. The Y axis will be from the same column. What would be the best way for me to do this? Attached is an example of what I'm looking to do.
-
YOY count
Hi all, I am trying to get the loan count of this year / the loan count of last year and for some reason, I cannot get an output - here is what i have tried so far. Any recommendations on the syntax?
-
Current date and before end of the month
I'm looking to work out the number of remaining installations left in the current month. I have two columns which have date values (KPI Completed, Completed Awaiting Power). How would I show data that is greater than or equal to the current date and less than or equal to the end of the current month? Cheers
-
Beastmode calculation
(CASE WHEN `Current Month`='Y' THEN SUM(`Monthly HC Calculated`) END) - (CASE WHEN `Prior Month`='Y' THEN SUM(`Monthly HC Calculated`) END) correct one.. but output is zero. we are subtract Current month vs previous month column might be null value is there so there is no output.. pls check what i am missing.
-
Making a bucket list of defects
I am trying to make a bucket for sentence long defects and put them in a column that is easier to filter by and group the defects into a certain defect code. I was able to get this working on a beastmode perfectly but when I try to add this in my ETL it gives me the code Failed to turn value string into Boolean. Here is…
-
"Request for data took too long causing a timeout." Issues in DOMO's Dashboard
I have a dashboard processing an extremely large volume of data behind. And many tables of my dashboard just kept returning a message "Request for data took too long causing a timeout." (just like in the image below). Refreshing card is not helping by the way. Besides, some complex calculations in Domo, presented in table…
-
Formula IFERROR Calculation Error
I am attempting to convert a text field of 8 digits into formatted date. The majority of the entries are in yyyymmdd order, but more than a few are in yyyyddmm order, so the original date_format formula is erroring on the rogue entries. IFERROR should return the result of the first formula unless it errors, in which case…
-
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?
-
Filter for Top 10 Values in Hor Grouped Bar (Similar to Top 10 Excel Pivot Table Function)
Hello everyone! I've read a lot of posts and YouTube videos in regard to Rank and Window functions within DOMO Beast Modes and I feel like I'm so close to nailing down what I am looking for and was wondering if anyone would be able to help me out. I am basically trying to duplicate the Top 10 function in an excel pivot…
-
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…
-
Need help with beast modes to show yesterday's invoice total amount, and previous year, current date
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…
-
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 create a period over period/Day over Day/Month over Month graph as show below.
i would like to know whats the calculated field or beast mode to create this % Sales growth on DOMO. I am not sure how to Syntax is. From my view in my work, it should be something like ("Count of Records(Date())"-"Count of Records(Date()-1)")/100 ...not sure how the syntax should be:(
-
Assigning people based on the ZIP
Hello, I'm coming with a following question. I'm working with inconsistent dataset. My Domo dataset has an individual assigned to a sale based on the ZIP within a region, which is incorrect. Within that region there is more than 1 person who sales there, that info is based on the ZIP code. I have the correct ZIP code file…
-
Guidance on Proper Beast Mode Syntax for Nested Cases
Hi everyone. I am trying to build-up a series of "cases" that will identify if our shipment is either "Hit", "Miss", or "Risk" in that order. "N/A" if shipment does not satisfy any of the 3. We have created a logic for each identifier. It is showing as validated but we are not getting the expected results with a lot going…
-
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…
-
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…
-
Need help with beast modes to show yesterday's invoice total amount, and previous year, current date
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…
-
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…
-
Sum if using Case When
How can I write this formula in an effective way? (CASE WHEN `Data`= 'Goal' THEN SUM(`Total`) ELSE 0 END) (CASE WHEN `Data`= 'Pipeline' THEN SUM (`Total`) ELSE 0 END) (CASE When `Data`= 'in P&L' THEN SUM (`Total`) ELSE 0 END) I need to create for every name, but it only works with the first one that I created
-
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…
-
Help With Creating % Of Total Column
Hello! I have a similar following dataset: Group | Claim Amount: A | $75.00 A | $20.00 B | $100.00 D | $200.00 C | $100.00 C | $30.00 A | $400.00 Total: 7 Claims I am trying to figure out how I can create a beast mode that will give me a percentage of total claims by count. So, trying to add a column that would output the…
-
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.
-
Beast Mode Delete Button
Hey all, Has anyone heard of any rumblings about adding a Delete Button in Beast Mode Manager? I have a customer claiming they were told that was coming so I wanted to bounce that off someone.