-
If date falls within the current month
I am trying to calculate the # of visits (that a therapist does) per working day against a goal of how many visits per day we budgeted them to do in a month. I am running into an issue with the calculation for the current month. For example, the goal for June was 22 visits a day and we had 733 visits in the month of June…
-
Slicer Question
I need to show the following slicer options: Amazon Mendel Amazon US Amazon International Amazon Project Maya I created a beast mode, only the 1st three options are showing. Amazon Project Maya does not show up in the slicer options. Does it have something to do with the one's highlighted below? The thing is, the Cust ID…
-
Filter Select: 2-day or 3-day data
Hello, is there a way in DOMO beastmode that we can filter cards and show past 2-day or past 3-day data? For example, the current date is 7/21/23: If I select past 2-day data: this will only show data from 7/19 and 7/20. If I select past 3-day data: this will show data from 7/18, 7/19 and 7/20.
-
How to edit DATEDIFF to calculate beyond calendar year
Hi, I have an argument where I am attempting to calculate how many consecutive days have occurred since the last specific event (See pic below). But when the 'Year' filter is applied to the dashboard and also filtered by a 'Region' and the event occurred in the prior year, I get a "no data in filtered range". Is there a…
-
How can i use alias with concat function in beast mode?
-
Combining Multiple Flags Using Concat() and case stmt
In my dataset, I have a multitude of different holds, and if more than one hold applies to the given order number, I want to have them all listed in this 'Hold Name' column i've created using a beast mode. However, when I start adding multiple case statements, the hold name column turns blank. How would I approach getting…
-
Need to create a ticket card which shows all raised, closed and backlog tickets
Inflow : Total tickets raised in the week Outflow: Total tickets closed in the week Backlog: Incremental open ticket count required as per week Beast mode created : inflow: count(CASE WHEN `status` <> 'Cancelled' THEN `incidentid` END) Outflow: count(CASE WHEN `status` = 'Closed' THEN `incidentid` END) Backlog: COUNT(CASE…
-
How to create a rate by specific selection criteria in Domo
Hello again community. So I work within a healthcare organization and I have a domo grouped/stacked bar graph built currently from an etl that has columns regarding patients readmission start date, account number, discharge date and attending providers(previous admission). The card breaks down the readmit percentage rate…
-
Aggregate a Beast Mode
Hello, I am working with a retail dataset and need to calculate beginning and ending inventories based on a user selected date range. The calculation is straight forward but the problem is aggregating the result so it displays on one row per item. The goal is a table card of items reporting beginning inventory, ending…
-
Calculated Column Errors - count conditions when like this but not like that
I would like to create a column in my dataset with a count of distinct session_id's where column event_name is 'search' but does not have an event_name called 'select_item' present as well. Hoping a beast mode will work because this is a gigantic dataset that takes hours to run. let me know if you think adding directly to…
-
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.