-
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…
-
How to Deal with Multiple Date Fields
I have a perplexing issue I'm trying to solve. I have data coming from several different data sources (all parts of Zendesk), each of which each represent a different kind of user interaction. For example: Email, Chat, Phone Calls These are all related to a master "Tickets" table, so they can be joined based on a Ticket…
-
Any chance I can add in a percent change over various fields in a pivot table via window funciton?
I am doubtful that it is possible, but I'm holding out hope that somebody might have some insight. In excel I can take the values of two different cells per row to calculate a percent change, but in SQL I only know how to do this when it's isolated across a single dimension. Below is a screenshot of two pivot tables with…
-
Page Level Date Filter nulling when not available in every dataset
I have a dashboard with cards running on multiple datasets (5+). To make date selection easier for users I've created a beastmode titled exactly the same across all datasets to show Q#-YYYY. There are instances where a there will be records of that date in some datasets and not others, the issue here is that I assumed as…
-
Trying to hide past months for one value in a beastmode
I am trying to use our actuals to track past month/current value and our forecast to use future month value and I am having trouble writing the beat mode to do this. CASE WHEN YEAR(`Period Date`) <= YEAR(CURDATE()) AND MONTH(`Period Date`) <= MONTH(CURDATE()) THEN 'Hide Future Months' ELSE 'Show Future Months' END Here is…