-
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.
-
'Lookup' in Beast Mode
Hi, I am looking for help to build a beast mode calculation for ColumnA here. ColumnA does not exist in the data and will be built using Beast Mode. The first three values have to be manually input and the fourth value onwards I need it as a calc as shown. Can someone please help me with this? Please let me know if you…
-
Help with beast mode formula - "case when" with date ranges
Hello! A little context about the use of this beast mode in the card: Looking at YOY data with same date ranges Date Ranges: 8/11-10/10 Here is the formula I have created: case when month(`date_purchased`) = 8 and DAYOFMONTH(`date_purchased`) >= 11 then 1 else case when month(`date_purchased`) = 10 and…
-
Why would a copied card have a different Type in a duplicated beast-mode field?
I made a copy of a dashboard that copied all of the data cards as well. The copied dashboard I've been playing around with the tooltips on a map. My modified map is having some different behavior to the original map. In troubleshooting I noticed that the original's field used in Values...is Text, but in the copy, it is a…
-
Beast Mode Manager - Cards using this Beast Mode
I'm working on some consolidation and updates to some frequently used Beast Modes. On the Beast Mode Manager page, one of the formulas in question is used on 103 cards. But the summary only shows 20. Seems the list has a hard cap of 20. How do I see all cards using this formula? Is there a setting to show all somewhere? Or…
-
Help calculating YOY and MOM beast mode calculations to be used in a standard table.
Data pulled in via API. Data using to calculate in use in other cards, so is clean and robust. Just need somebody with a little more expertise.
-
Datediff Beastmode Help
I am attempting to write a beastmode that will give me all cases (tickets) that have not been updated within the last two or more days. Here is the beastmode I am attemping to create but get asyntax error. Can anyone advise? (case when DATEDIFF(`Current Date`, `Date Last Updated`) >= 2 end) Thanks
-
Deleting Beastmodes
I am almost 1 year into using Domo and am in the process of trying to clean up cards and datasets and would like to remove old beastmodes. I am having trouble where Domo is telling me the beastmodes are in use on cards that I cannot find or access in my instance. I am an administrator of my instance so I should be able to…
-
how do you find the maximum number of column value & substrct
Dear All, Below is pivot table created via chart type in domo I want subtract latest week - week 1(e.g. week 4 - week 1 next time week 5 (dynamic) - week 1) next time week 6 (dynamic) - week 1) e.g 1276 - 319 = 957 result simultaneously other line as well in one column Regards
-
Visualizations don't fit into report
I created some pivot/html tables for reporting purposes but they are relatively wide with a few rows. When I try to export it as a report columns toward the right hand side of the table are being cut out from the report. Is there a way to adjust the width of the table so it fits into the exported page width of the report?…
-
Beast Mode - Refer to Other Segments in Case Statement
Basically, what I'm looking to do is create a percentage column in the dataset. For example: Let's say I have some shapes: 'Rectangle', 'Square', 'Small Square' How would you go about creating a variable that shows the percentage of that shape as compared to the next largest category of shape? For example, the column would…
-
relating beastmode IDs between datasets
relating beastmode IDs between datasets Hello! I am having trouble relating beast mode ID between two datasets: the user logs and a Beast mode dataset available via the Domo governance dataset connector (https://domohelp.domo.com/hc/en-us/articles/360056318074-Domo-Governance-Datasets-Connector). In the "beast modes with…
-
relating beastmode IDs between datasets
relating beastmode IDs between datasets Hello! I am having trouble relating beast mode ID between two datasets: the user logs and a Beast mode dataset available via the Domo governance dataset connector (https://domohelp.domo.com/hc/en-us/articles/360056318074-Domo-Governance-Datasets-Connector). In the "beast modes with…
-
COUNT(DISTINCT... CASE WHEN... THEN)
Our company just adopted DOMO and this beast mode is always registering as invalid, but it seems to be the correct syntax (or so I thought), any ideas as to what I am doing wrong COUNT(DISTINCT CASE WHEN `Account.Status__c` LIKE 'Cancel%' THEN 'Canceled')
-
Renewal Rate Calculation
Hello! I have my data set pulled in and I cannot figure out the best way to calculate the renewal rate or churn rate. The calculation is taking a specific timeframe now, say all of March 2022. Then taking that total paid about and then dividing that by the same time period last month. So looking at period over period, but…