beast mode formula
Discussion List

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 82 views 6 comments 0 points Most recent by jaeW_at_Onyx Data Platform & Data Science

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 …

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 445 format. This means we …

% Sold of Available Inventory (aka SellThrough)I am stumped on this one. I have two tables: an orders table and an inventory table. orders contain…

4FIXED Function  Static FiltersFILTER ALLOW/DENY is the most useful piece of FIXED for me. What would juice up its usefulness to t…

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 14day and 30day card fi…

0Allow Graph By in window functionsI'm trying to create a dynamic Beast Mode that uses a window function to select the first value of …

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 51 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 pseudorandom num…