-
Rolling monthly target
I would like to insert a rolling monthly target into a table for each location. e.g. Location 1 - monthly target is 5. First of the financial year equals 5 then the next month add another 5 which equals 10. Jan - 5 Feb - 10 March - 15 April - 20 and so on. Location 2 - monthly target is 7 so, Jan - 7 Feb - 14 March - 21…
-
Month Over Month Calculation
Hi, looking for help to calculate the Month over Month (MoM) with the metrics and months as above. I had successfully created my metrics by row, and Months by column in DOMO, however, I failed to create the calculated field for MoM Difference, and Mom % Difference as red in sample above. starting with 01-May because May is…
-
What is a Beast Mode to calculate days and months between dates?
I am trying to calculate days between dates; Current Date and Start Date. I need the length of assignment in days, and then eventually months. I am using the below Beast Mode, but my Length of Assignment in Days is off. The current date is 4/8/2025 for all, but I cannot figure out what the problem is. Any ideas?
-
Beast Mode- SQL code to count how many updates in 6 hour intervals
Hello, I'm in need of assistance please of creating a beast mode but can't seem to write it correctly. I have a table named updates with a column time_start that stores the timestamp of each update. the Rows will be the ticket numbers And I want to group the updates by 6-hour intervals, and count how many updates fall into…
-
Nested Beast Mode With Variables
I am trying to build a dashboard that will allow the user to select a customer, date range and metric to return a value that will be compared in a table to another value which is average of that same metric for a of predefined group of customers over another date range. The data for this currently resides in the same data…
-
Got a fun one for grouping Columns together. Need help building
This one will take some setup. I have a card by Style and Color, with values of Total AVAIL STK and then broken out by Size columns, and TOTAL WIP and by Size columns. The issue is when we filter to a style, we don't need to see the sizes it doesn't have. If we're viewing a purse, it only needs to show "1SZ" since it would…
-
beast mode to show how many updates every 6 hours
Hi everyone, I was hoping to get some assistance on creating a beast mode please. We have a data set that calculates how many updates a ticket has from when a ticket is open to close. And now we are trying to get a more precise count on when those updates are taking place. We are trying to get a count on how many updates a…
-
How can I write this formula in beast mode?
Hello, I am trying to write this formula from google sheets in Beast Mode DOMO but I can't get to make it work. Does anyone know how to write it correctly in beast mode? Take into consideration that Year and Tons are columns. (SUM(IF(Year = 2025, Tons,0))/(SUM(IF(Year = 2024, Tons,0))))-1 Thanks for your time in advance!
-
Variable Response in Beast Mode
In the Beast Mode below, End Date 2, Start Date 2, Measure Selection and Client Select are all variables. For the Measure Selection and Client Select, is there an alternative to hardcoding the literal value for each Client Select & Measure Selection permutation? Is there a way to take the variable response and feed it into…
-
Writing a google sheets formula in DOMO beast mode
Hello, I would like some help writing this formula from google sheets in DOMO Beast Mode or any other option available in DOMO, please. Take into consideration that Year and Tons are columns. (SUM(IF(Year = 2025, Tons,0))/(SUM(IF(Year = 2024, Tons,0))))-1 Thanks in advance, and have a nice day!