beast mode formula
Discussion List
-
Is there a way to aggregate the output using a FIXED function used in a CASE statement?I'm a MajorDomo in a large retailer, and I'm working to rewrite our TY/LY Beast Modes to calculate …
-
How to compare Value ColumnsHi, Beginner to DOMO so excuse the question. I've created a Pivot table with 2022 sales vs 2023 p…
-
Removing Duplication and Ordering Objects within a Concatonated FieldHello, Our company offers several different product lines and I am attempting to count how many tim…Answered n____l____ 71 views 4 comments 0 points Most recent by n____l____ Data Platform & Data Science
-
How to create a column which SUMS based on the grouping of another columnHello, I am trying to write an ETL which sums a value based on the grouping in another column (inv…Answered Mattwjones 35 views 1 comment 0 points Most recent by MarkSnodgrass Data Platform & Data Science
-
Trying to Count the number of Appointments in my dataI feel like this should be simple but I'm struggling with how to write the beast mode to where I ge…
-
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 ha…
-
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 …Answered ✓ damen 131 views 6 comments 0 points Most recent by jaeW_at_Onyx Data Platform & Data Science
-
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 …
-
% 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 contain…
-
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 …
-
Date Filter Card Will Not ToggleHello! This is my first time posting on the Dojo. I am trying to set up a 14-day and 30-day card fi…
-
How do beastmodes handle filter context?Please can someone explain what happens under the hood when we slice beast modes (BMs) by dataset f…
-
How to remove empty columns from a dataset?I am using a DOMO connector to import Salesforce data. The imported data has 30+ columns with no va…
-
Filter to show blank cells?Hey! I am looking to filter data to show columns that have empty cells. For example showing all res…
-
Dynamic Target Based on Current DateHello all, I am currently utilizing a gauge card with a target metric. What I would like to do is h…Answered ✓ user02769 82 views 2 comments 0 points Most recent by user02769 Data Platform & Data Science
-
Beast mode formula: Case When with distribution pointsHi, I have a question about my beast mode formula concerning a distribution calculation. Currentl…
-
How can i write this sql statement in domo?where a.Customer NOT IN(select distinct Customer from CustomerSalesData where InvoiceDate < '202…
-
Table vs SQL Data Flows and which functions does Domo not recognize? (I'm confused)Hi, My CSM informed us that window functions are enabled. I would like to write the following via E…
-
Can I nest a Select Distinct function in a beastmode?Relatively new to all of this, but I'm working on a beastmode that calculates the average tenure of…
-
Rolling 30 Day Formula in magic ETLHi, I am trying to write the formula above within magic ETL. Column A consists of static values. C…
-
-
Beastmode YoY Variance CalcHi All, I am working on a beastmode that I thought would be relatively straight forward, but is giv…
-
Beast mode calculation for aggregating dataHi, I have a numeric field called "days until due" which contains negative numbers for ou…
-
How to aggregate CASE Statement values?In my dataset, I have three different tests that aggregate the field Forecast differently. Here's …
-
Convert string to numberHi, We have one column name "Count", in this column, we have majorly two values zero and …
-
How exactly does the rand() function workBased on my testing it seems like the rand() function returns a guaranteed set of pseudo-random num…
-
How can I compare YOY data with an offset of a couple of days?Hello, I'm 100% new to DOMO and I'm looking for some assistance. I'm trying to compare data from 20…
-
I am trying to get the timecards created this quarter for last quarterI am trying to get the timecards created this quarter (Q2) but for last quarter (Q1) the reference …
-
Separate Date from the textHi, I want to separate the Date from the text and put it in a new filed called "launch Date&q…Answered user041053 51 views 2 comments 0 points Most recent by jaeW_at_Onyx Data Platform & Data Science