-
Getting no data in calculation in my beast mode.
I am trying to calculate the %age change in headcount with respect to the previous vs this month but by using below beast mode I am not getting any results in the trend line. It gives 0 as a value. ( (SUM(CASE WHEN MONTH(Date) = MONTH(CURDATE()) THEN Headcount END) / COUNT(DISTINCT(CASE WHEN MONTH(Date) = MONTH(CURDATE())…
-
Help with Beast Mode Formula
I need help doing a complex sum in a beast mode, as when I do it I either get an error or a totally wrong number. The formula I was given reduces to A/(A+B-C), and sums across the entire data set for whatever date range the user chooses. Each of the letter values will be either a zero or one for a given record based on…
-
How to calculate against row values, instead of a summation, when using a beast mode within a pivot
I'm currently using a simple beast mode within a pivot the table. The beast mode calculates the percentage change in the values from two columns. The issue is that, for subtotal and total, the beast mode is summing up all the percentage change values above it, therefore returning inaccurate values. Is there a way to…
-
Adding link to card name
I have this BM here that I have used in the past to link to data sources in tables so I can go directly to the respective dataset. Currently, I have developed a table card that includes card name and views in the past 365 days. I want the card name to be linked to the card itself so I can quickly click the link and delete…
-
Is it possible to calculate ROAS and WoW change in the same beast mode formula?
I'm working on a pivot table and I want to show the % change of ROAS from last week vs. two weeks ago. My dataset does not contain a 'ROAS' column so I'm trying to calculate it within the WoW beast mode formula. If I breakout the formula below into two parts (LW ROAS vs. 2WA ROAS), the first part will correctly give me…
-
Dataset Beast Modes and Sandbox
From a sandbox perspective, I know that it doesnt actually promote/copy datasets from one instance (dev) to another instance (prod). However, we have some Dremio federated datasets currently in dev with a bunch of dataset calculations on them and we're trying to avoid having to re-create all the beast modes everytime we're…
-
Apostrophe messing up formula
I have a datarow with an apostrophe, but the apostrophe it messes up my beast mode formula. Any ideas on a workaround for this, I do not have access to change the incoming data.
-
Granularity Issues in Domo
Hello, I have a dataset that I'm working with that has my data at a granularity that is quite large. I then want to be able to group that by each individual session that happens on our website and sum the total time spent for that session. I then want to take the average across all sessions. But I want to be able to do…
-
Calculate the average normalized score in Beast Mode
Hello, I have data in this format: I want to perform the following calculation in Beast Mode and create a chart out of it: 1. For each Product, calculate the maximum possible score within that Product. 2. Divide the score of each employee (Name) in each Product by the maximum possible score for that Product. This is giving…
-
how to exclude all last Wednesday of every quarter?
How can I create a beastmode that exclude these dates from showing up in a card» 3/29/23 6/28/23 9/27/23 12/27/23 but also make it dynamic so that I dont need to hardcode these dates but it will exclude all last Wednesday of every quarter? thanks!
-
Domo IDEAs Conference - Beast Modes - Number Formatting
Greetings! This is another post highlighting a beast mode from my Domo IDEAs conference session. This one covers how to format numbers a number when concatenating with a string. Problem: When concatenating a string with a number the resulting value is a string and unable to utilize Domo's built in formatting. Solution:…
-
Beast Mode calculation
Hello, I'm creating a visualization that aims to show orders that have a specific piece of equipment in it. My database has multiple rows of 'SO #', 1 row for a different type of equipment ordered. I want to see how many orders out the total have number '100' in column 'Equipment #'. In other words, for each 'SO #' I want…
-
Get value for first day of the month
I need to be able to create a beast mode that does the following: for any given month sum up columns A, B, and C, then get the value D for the first day of the month, and implement the following formula: (SUM(A) + SUM(B) - SUM(C) / D for the first day of the month I can do it in an ETL, but that involves aggregations and…
-
How do you change a date to a digit to get a sum?
I have a column that has the completion date. I'd like to change that to a number 1, so I can calculate how many have been completed. If completion date equals 6/12/2023, 6/13/2023, 6/14/2023, 6/15/2023, or 6/16/2023 then change each of those values to the number 1
-
Smart Text / Summary Number
Hi Friends, Requesting for your help on this, please. Example I have three columns, 'Student IDs' and 'Course Category' (Science, Math, History) and another column which is 'Location' which I have it in filter Now I wanted to write in a text box. (Dynamic) Location has more number of Course Category students. Example : NY…
-
Beast Mode calculation works but when trying to insert into a card, I get an error.
Good day, I have a beast mode calculation that I believe can calculate the sum of accidents over the previous 12 months for any given month. My data set goes back 3 years on a month by month basis. Here is the current beast mode that works when I validate it: SUM(SUM(fieldsAccident Count)) OVER ( PARTITION BY…
-
How do you perform a calculation within a pivot table?
I have two rows on my pivot table—one for revenue and one for costs. Trying to get to profit. Is there a way to perform the profit calculation using a beast mode, and then making that beast mode a row? Picture attached for context. Thanks!
-
WOW comp calculation not correct
Hello, I am looking at this Domo Card and the WOW Comp calculation looks incorrect. Last Week Spend is $0 and Spend 2 weeks ago is also $0 but WOW is not 0%. Does anyone have any idea why this can be the case? For reference: LW Spend calculation: sum((CASE WHEN ((FY Order = 0) AND (Fiscal Week No = (Current Week - 1)))…
-
Dynamic Date and Time
Hello All, I'm working currently on a report that would need data for just a specific date and time. Would you give any advice on how to create a beastmode script that will show the time between 6am on the previous day to 6am on the current day. Here is what my column looks like,
-
How do I Compare Column A vs Column B in the same Value?
I have one value that goes back several years and id like to compare TY vs PY. How do i write the calculation in beast mode to subtract A vs B and finally show the % ∆? Thank you.
-
How to create a filter using Beastmode?
Hello and TIA! How can I create a beastmode for a filter? These names are always changing and I have to go into every card where I need this filter and update them when one changes. If I had it as a Beastmode, I could just update it once.
-
YEARWEEK Function and Modes
Hello all - I am looking for some help with the YEARWEEK() function. I see that the function syntax is: YEARWEEK(`dateCol`, mode) where 'mode' defines the starting day of the week with '11' meaning Sun-Sat and '22' being Mon-Sun. I found this in the Beast Mode Functions Reference Guide but it doesn't expand whether other…
-
Date Transform
I Have a year and a month column in my dataset which are in the format of integers. I want to create a beast mode calculation to concat them and have them as a date field. How can i do that?
-
Beast mode calculation
I want to create a beast mode calculation which should be something like this Value for current month this year - value for current month last year / Value for current month last year How can i do this?
-
Beastmode subtotal not calculating correctly
Hello, I am trying to figure out what is wrong with my 3 beastmodes. One for this year's email sends, one for last year's email sends, and one for this year vs last year's difference. Currently, the chart looks like this and the beast mode doesn't seem to be calculating correctly in each row plus the subtotal. This Year…
-
Omitting rows in pivot table
Any way I can omit this section in a pivot table but keep the 2021 Total?
-
Totalling certain rows
I have a question about totaling data in tables. I have two sets of data from different time periods 2021 & 2023, and I'd like to sum the respective metrics for each. I have two different tables present that may aid in getting this solution done. For the first image I want to add a column after the 2021-12-01 column to…
-
Case Statement with YTD
Hi Folks, I'm trying to derive this through Beast mode calculation. Requirement: Case statement Score 1 - If my error % is 0 - 75% Score 2 - If my error % is 75.1% - 95% Score 3 - If my error % is 95.1% - 100% (Includes 100) Score 4 - If my error % is 100% (YTD) Finding difficulty in writing a case statement for 'Score 4'.…
-
FIXED BY Beastmode trouble shooting
Something is not working quite right and I am having a hard time figuring out what is going wrong. We're trying to see the % of registrations by year, by day of week (sun, mon, tue, …), by hour of day, and then to be able to filter by locations. So in ETL, for the numerator, I am grouping by Year, DayOfWeek, Hour of day,…
-
Build a Data Time field from columns containing date, hour, minute, second
I've got a data source that has separate columns for date and time that I need to combine into a single data time field. The length of the time field differs based on the hour (sometimes 1 digit hour, sometimes 2 digit hour). I have split apart the time field based on LENGTH() into separate columns for hour, minute, and…