-
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…
-
Is there way to extract week of quarter from a date column?
The default week() function extracts the week number from the start of the year and runs 1 to 53 or 54. I need to show week number within the quarter, running 1 to 13 or 14 within each qtr. Is there a way to do this using beast mode or using the formula tile in Magic ETL ? Thanks!
-
Fiscal calendar - select like other date-related filters, bulk enable on cards, apply to beast modes
We want to use custom fiscal calendars in our subscriber instances, so our customers can have their fiscal calendars. However, a few limitations of the fiscal calendar in its current form will prevent this from being useful for our published content. We want users to be able to choose if they want to view a visualization…
-
Dynamic Segments
Looking to create a segment calculation that essentially becomes the leftover rows of what is filtered. So lets say you have 5 zones and someone filters the page on Zone 1. I want the other zones to show up for comparison. The filtered zone will be highlighted. This is a workaround attempt at highlighting page filtered…
-
How do beastmodes handle filter context?
Please can someone explain what happens under the hood when we slice beast modes (BMs) by dataset fields and/or when a filter is applied to BMs (categorical field filters/date filters) BMs using SUM() or COUNT( DISTINCT() ) when sliced or filtered don't behave as expected. (expectations being the issue). In one case, I had…
-
Filtering table -- cells can have multiple values
I have a dataset table with filters. Some cells have multiple values. Say I have a column called "Device." Row 1 can have "Desktop, mobile" and Row 2 can have "Desktop." I want to have a filter called "Desktop" that shows all rows containing any instance of "Desktop." When I do the beast mode formula: case when `Device`…