I have read several varying degrees of opinions on when a Beast Mode is actually calculated. I thought a Beast Mode, attached to a card or assigned to a dataset, is calculated at the objects rendering, regardless of if the Beast Mode is actually being displayed on said card. So if I have 20 total Beast Modes, some only…
Hi there, My team wants to create a beast mode that looks at total views in the first 30 days per asset since the video was published. For example, a video was published on March 1, 2024 and we want to know how many total views did it generate through March 30, 2024. We created a couple of sample beast modes that are…
CASE WHEN SUM(Total Weight/Units Received) > SUM(Weight (MIN)) AND SUM(Total Weight/Units Received) < (Weight (MAX)) THEN '1' WHEN SUM(Total Weight/Units Received) <= SUM(Weight (MIN)) THEN SUM(Total Weight/Units Received / Weight (MIN)) WHEN SUM(Total Weight/Units Received) >= SUM(Weight (MAX)) THEN SUM(Total Weight/Units…
I was trying this beastmode formula, and it is giving NULL value for the latest date but when i am putting this formula as filter and selecting this option "Not in" the data shows like "No Data in Filtered Range" CASE WHEN Date = MAX(Date) OVER () THEN 'NULL' ELSE Date END
I used Rank & Window ETL to Rank Districts 1-46 based on a performance value. I need to use the "Colors" feature in Analyzer to color code rows based on a "Tier" I created in a Beast Mode, which is calculated based on percentile. The Beast Mode is as follows: In the preview, this works. Ranks 1-11 are D, 12-23 are C, etc.…
Hi all, I have a beast mode calculation created which I'm trying to find out the monthly average of open tickets between 5 boards for the past 15 months and this is what I have- SUM(COUNT(TicketNbr)) OVER (PARTITION BY Board_Name ORDER BY last_update)/ DAYOFMONTH( last_update ) But I think the calculations are off. Is…
Hello, I am trying to group values into ranges in DOMO, but can't seem to get my beast mode to work. Am I doing something wrong? I am trying 2 different methods: 1. case WHEN `Sale Liability` >= 50000000 AND <= 100000000 then '$50M-$100M' WHEN `Sale Liability` >= 100000000 AND <= 250000000 then '$100M-$250M' when `Sale…
I have a single value card and I'm using the following code to format the dollar value as I concatenate several values into one text value for the card to display. Do you know if there's a way to have the font color display red if the value is negative? Here's a snippet of the code: CONCAT( '$', CASE WHEN…
Is there a way to create a column that can help identify a duplicate from another column? Below is a list of loan ids that we have and some of them have coborrowers but some dont. I dont need to remove the duplicates but I would like to create a new column that can identify quickly which one is a coborrower. Is there a…
I've the following beastmode: case when DATEDIFF(Select Columns.Date,Date) >0 then sum(Select Columns.Totaalprijs)/COUNT(DISTINCT Email) else 0 end But instead of one row I get multiple rows. I tried adding 'sum' to other places in the beastmode but I'm receiving either an error or the same result. Can someone shed a light…
It looks like you're new here. Sign in or register to get started.