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 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… -
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 14-day and 30-day 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 pseudo-random num…
