-
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.
-
Magic ETL or Beast Mode?
Hey everyone, I'm using data that basically needs an (=if) statement like we were going to be using excel-- We have two columns called current income and qualified income. The 'income' column needs to populate with 'current income' if another column, called 'instrument' reads 'first home' otherwise, we need to use…
-
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.
-
Beast Mode to Fix Revenue per Item at the first entry (so compare the rest)?
Imagine the following: Item Revenue (Vs 1st Entry) A 100 0 B 80 -20 C 60 -40 Any ideas on how to write a beast mode that first fixes the first entry of the rows to a constant value for all rows (then writing a companion beast mode of the variance row by row is trivial)? I've tried to SUM(SUM(Rev)) OVER (PARTITION BY Item)…
-
How to calculate % of projects assigned?
Hi there. I'm trying to setup a beast mode calculation but not sure the best approach for it. I have a column that shows the number of days it takes for a new project to get assigned for example if opened on 19 Sep, assigned on 22 Sep - it would show up as 3 days. I'm looking to do a quality check to see what percentage %…
-
Filling blank cells with 0
Hi Team, I've recently started domo to build reports and I'm trying to fill 0 in below blank cells in one of my reports. The thing is, in my dataset there's no data for August month for the highlighted rows. I believe that's why I see blank in Domo. Till here it's fine. Now, I'm trying to display 0 in these blank cells.…
-
Beast Mode Examples
Sorry in advance if this is already a thing but I haven't been able to find it. As a new user to SQL, I understand the very basics. Beast mode provides a really simple and easy way to apply some of what I know and quickly help with new calculations. My issue, and where the idea comes in, is that I don't know where to go to…
-
Date dimension/formula problem
Hi, I'm not sure what I am trying is possible but here goes. I have my data stacked as per @GrantSmith's excellent post. What I need is a calculated column for the last year column that only includes the value if "Another Value" from the This year row = 'Y' So only show 600 if another value =Y from period type this year So…
-
What is the best way to calculate?
So I'm using a grouped bar graph and am looking to try and calculate the difference between two of my columns that were created. My company calculates the average spread on loans broken down by lenders we use. I was able to separate those average spreads by product by adding the products to the 'series' drop-in at the top.…
-
Trying to Find the Top 10 part numbers by $'s for the year for each plant department.
I have a large table showing plant department and their part numbers with the quantity scraped / dollar amount scraped as the values. Is there a way to only show the top 10 part numbers by department in dollars? Trying to be able to always keep track of what top part numbers are being scraped. Thanks
-
Find greatest value for each specific ID
Hi, I have a dataset like this: ID Value 1 5 1 6 1 7 2 23 2 24 2 25 I want to write a ETL formula that creates a third column saying the greatest value for each ID is: ID Value Greatest 1 5 7 1 6 7 1 7 7 2 23 25 2 24 25 2 25 25 Thank you
-
How to create a filter to capture the end of month
Hello Domo community - Good Day! Basically, we want to capture the data from the previous month on the current week. for example, the start of the week is 8/28 and the end of the week is 9/3. we want to capture all data up to 8/31 only. and then data for 9/1 to 9/3 using the start date 8/28 or end date 9/3. Thanks
-
Get the total result based on sum of column 2 / sum of column 1
I wanted to get the result based on Col2/Col1 result, expected result here is .3545, when we do average in last column i'm getting .3788 (1.8942/5). Is there any way to achieve the expected result.
-
how to break a week between months
Hi DOJO - Happy Weekend! Basically, we have a dataset with date columns based on the start of the week and end of the week only. on the example below, I just concatenated the start and end dates so it shows Aug 28 to Sep 03. if its not concatenated, I can put start date and it would show the start of the week which is…
-
Export Beast Mode from Beast Mode Manager
Is there a way to export Beast Mode calculations that users have created? Trying to wrangle document the various calculations in Beast Mode Manager, but not finding an easy to export them so it shows the name, dataset used, syntax, and creator of the Beast Mode. If this is not available, can this be a feature reviewed and…
-
Beast Mode URL via Governance Data
As a Domo Admin, I need a way to use governance data to build a URL that links to a beast mode so that anyone using the card with the link can quickly access the screen to edit the beast mode. Unfortunately, the Beast Mode ID in the URL doesn't match the calculation ID in the governance reports. If I'm writing acceptance…
-
Is there a way to create a static temp table in Beast Modes?
I'm the MajorDomo for a large retailer, and our Fiscal Calendar uses a 4-4-5 format. This means we have a Week 53 this year, and a large portion of our Domo reports are built off of a TY/LY comparison. I'm working on logic to reconfigure our reports always look 364 days or 52 weeks ago, rather than look at the same Fiscal…
-
'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…
-
% Sold of Available Inventory (aka Sell-Through)
I am stumped on this one. I have two tables: an orders table and an inventory table. orders contains a record for each order placed by a customer; and inventory holds a record of how much inventory is available at the start of the period. Note that qtyAvail does not update... it is a reflection of how much that store…
-
Beast Mode Formula for Previous Complete Weeks
I need to display results in cards from the last complete weeks in a dataset. (This dataset is on a 7-day lag. Thus making it not compatible with the Period over Period cards. Which is cray cray to me. There should be an option to align to the data set rather than today's actual date... I mean... lots to love about Domo.…
-
Period Over Period Calculation Challenges
I am trying to calculate the difference between periods for a specific metric and am running into some trouble. (As you can see from the screenshot below, the Beast Mode calculation I am using doesn't seem to be working.) To generate the column totals, I am using this beast mode successfully for each desired date…
-
Ignore Row Context / Power BI 'ALL()' Equivalent?
I mocked up a simple example to illustrate what I'm trying to accomplish. The question is: how to create a beast mode which will ignore any filters and/or table row context applied to a column, in this case `Store`. The goal is: calculate Average Order Value for the entire dataset (Total Company), so individual Stores can…
-
Date Filter Card Will Not Toggle
Hello! This is my first time posting on the Dojo. I am trying to set up a 14-day and 30-day card filter for my org. The one used at the moment does not toggle. So if I select the 30-day card filter, it will stay at the 30-day filter if I deselect the check box or slide the slicer. It will only go back to default if I clear…
-
How can we download list of beast mode made on particular Dataset ?
Like I can see the list of all beast mode on a particular dataset on beast mode manager .But I want to download them also as per the particular dataset . Suggest me some way if there is any .
-
Creating a Link Field in Domo
Hi All, I was trying to have a hyperlink embedded inside a Domo Table/MegaTable and I used the following method. CONCAT('<a href="https://na132.salesforce.com/', `donation_link`, '" target="_blank">', 'Donation Link', '</a>') Now this is working perfectly on Domo but one major problem I'm facing is when I export the data,…
-
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…