Hi, I am trying to create a new column "Previous week's budget" that takes the previous week's budget. For instance Feb wk2 budget is $15, so Feb Wk 3's previous week's budget (column B) should be $15. I tried creating a beastmode with the following formula but it is referencing "fiscal month by week" which is sorting…
I am trying to create a beast mode where when the customer = 'Spektra' then the ConsolidationDay = 'Wednesday, Friday'. I also need this to populate the ConsolidationDay cells with 'Wednesday, Friday' as they are currently null. What would be the correct Beastmode to do this?
My dataset has these columns: year (int), month (int), target, actual I created a BeastMode to return the current month (Aug) value for both target & actual, but instead of showing an actual value for Aug, it shows 0. CASE WHEN month = MONTH(CURRENT_DATE()) THEN target ELSE '0' END Since I want to see the variance for…
I've been trying to find a solution for easily calculating percent change of metrics between two periods and put them in a table. Like "What is the percent change for "costs" between this month, and last month?" Normally this is easy to calculate outside of Domo using the standard formula: (V2 - V1) / V1) *100 However,…
I am hoping someone can tell me a simple fix for why my beast mode calculation is returning an incorrect value. What I am doing is not too complicated, but it is not working and I could use some guidance because I am new to Domo. I have created a column to show the total amount by Quarter using the following calculation:…
Is there a way to show a series of dates in sequential order (either daily, weekly, monthly, etc.) without the date being closely tied to a particular data point?
My question is related to showing Comments/ Verbatim in a Table using a Beast Mode to Apply Business Rule. In Org Survey, we want to make sure that if we have less than 5 unique comments then don't show the comments. If the Business Rule of >= 5 comment is met, only then show the comments/verbatim. Below is an example…
I have an existing simple bar chart that is displaying a count of daily activity. The current fields are Date_StatusChange on my X axis and COUNT of Status_Desc as my Y axis. I'd like to aggregate all dates prior to Aug, 25, 2024 as "Carry-In" so I can display a count of everything prior to that date as "Carry-In" and…
Hi, I have a dataset that looks like this: Network Hour Date Avails A 1 1/1 2 A 2 1/2 4 B 1 1/1 6 B 2 1/2 8 C 1 1/1 10 C 2 1/2 12 C 2 1/2 12 The number of avails is the same for every row that has the same network, hour, and date. I need to write a beast mode that calculates the number of different rows that have the same…
Sounds like ABS can make a Negative value a Positive value, but how can I do the opposite? Need the result from this Beast Mode to be converted to a negative value: SUM (CASE WHEN DATE(`BatchTimestamp`) = DATE('2023-11-22') AND YEAR(`Month`)=2024 AND `FinancialCategoryName` LIKE '%CAPEX%' AND `Portfolio 2024_p`='Rejected'…
It looks like you're new here. Sign in or register to get started.