-
Running Total
Hello, I need help. Wondering why my running total is failing. I have the logic set up in the dataflow. The card returns the the correct value in months where there was production but for months with no activity, the value is skipped but returns the right value in the subsequent period. How do I resolve this? Product mon1…
-
SUM(distinct) Fixed By
I have a column that needs to be a constant value based on two more columns. So I am using this formula SUM(DISTINCT Balance) FIXED (BY Client, Item). This is working fine. However, When I am using the same formula in another beast mode I am getting the below error (1-SUM(Lost))/ sum ((SUM(DISTINCT Balance) FIXED (BY…
-
Rank Beast Mode with Issue
I´m using this formula to make a RANK rank () over (order by sum(NET_SALES_CY)desc) The table show the rank correct. But as soon as I try to filter my top 10 customers on table using the rank, I receive this error message An issue has occurred during processing. We are unable to complete the request at this time. what am I…
-
Beastmode to decide how much to spend per ad in a given category
We have a working beastmode that calculates what ‘n’ should be depending on spend, revenue, and page depth (page depth is in 3 categories – all pages, product, and shopping cart). Here is the formula: = 1 / ((spend / revenue) / (sum (all spend per category)/ sum (all revenue per category))) Note that the category of all…
-
My beast mode is not calculating correctly
SUM(SUM(BILLABLE_ORDERS) FIXED (add COUNTRY_NAME)) / SUM(SUM(ATTEMPTED_TXNS+VOUCHER_TXNS) FIXED (add COUNTRY_NAME)) It should be 0.82 Below is an extract of the data
-
Beast modes with multiple datasets
Hello! Is there a way to make beast mode computations with different metrics from different datasets? For example, I have the below cards that, although the numbers are the same (I am building a reconciliation section of a dashboard), the datasets used to create them are different. Now I'd like to compute the difference…
-
How to count numbers in an email address
I am trying to identify email address with more than 4 numbers occurring before @. I tried the following code CASE WHEN LENGTH( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(…
-
30 Day Interval
Hello! I am looking to create a beastmode that sums video views and revenue separately in the 30-days after the asset is published. While the beastmode is validating and looks to be calculating accurately, the QA is very off. In the screenshot example, I manually filtered the time frame for 30-days after the published date…
-
Can someone tell me where I am going wrong please?
CASE WHEN 'metric'= 'CURR MONTH' THEN CONCAT(MONTH(NOW()),'-',YEAR(NOW()) WHEN 'metric'='PREV MONTH' THEN CONCAT(MONTH(NOW())-1,'-',YEAR(NOW())) WHEN 'metric'= 'THIS MONTH PREV YEAR' THEN CONCAT(MONTH(NOW()),'-',YEAR(NOW())-1) ELSE '' END
-
Changing a column used in multiple beast modes to another column
I have around 10 beast modes that that are based on a certain column 'A' in their calculations but I need to change all of them to use a different column 'B' in the calculation. Is there a way to change this instead of manually editing all the column formulas?
-
Question on acceptance rate calc
Hello, I am trying to calculate total accpetance rate of the students. I have 2 calculated fields Accepted Students: case when (acceptance_flag = 1) then count(students) Total Students: count(students) I am having a table format and calculation for acceptance rate: (case when (acceptance_flag = 1) then count(students)…
-
Top 100 Values
In my data i have a 'client','quarter' and a Beast mode 'Score'. I have created a bar chart with quarter on x axis and Score on y axis. I have to create a card which shows scores for only top 100 clients quarter wise. How i can do that. I am not able to find a way at the moment. If we can do that in Beast modes it will be…
-
How would I filter for Order Numbers that contain UN codes? While keeping all other part numbers
Hi all, I am trying to figure out how to do this in Analyzer via Beastmode or filter tool. I am trying to only filter/display Orders that contain a product with a UN battery code while still displaying all other items in that Order Number. I'm having a tough time finding a function that could do this. Any ideas? Thanks in…
-
Identify if value exists in field to then classify data
Hey community. I've got a data set that is not optimal for what I'm trying to do. My optimal data set is sitting in a backlog and I'm looking to get some preliminary answers while i wait - so frankly, looking for a hack. I have a data set that has all of the participants associated with all of the events that we track. So…
-
Beastmode listagg/group concat
Hello, I usually refer to the list of magic etl functions documentation for functions that I can potentially use in beastmode since some working functions do not exist in the list within the beast mode editor. However, a function that can combine strings from multiple rows into a single string like GROUP_CONCAT and LISTAGG…
-
Calculate a ratio
Hi, I am looking for a calculation that will allow me to look at a requisition number and then look at number of people Forwarded to Hiring manager and number who were hired and calculate a ratio For example the calculation should be able to say 3:1 for the below example 3 forward to HM : 1 hire Sometimes we have more…
-
How to count number of Occurrences in a Column
I have a dataset where I am trying to get a count of each occurrence a value in a specific column has: For the example above I would want the result to return that there are Two : "0's", Three: "Nulls", and Three: "1's".
-
Creating A Date Field
Hi Domo Community, How would I go about creating a usable date field from two columns I have? One column is the year, and the other is the month. How could I create a date field from those two columns? For example, 2/1/2024 from a column that has February and a column that has 2024. Thanks!
-
How to Calculate a rolling 7 day Average and Rolling 4 week average? in a beastmode
Does anyone know the correct beastmode calculation for a rolling 7 day average and a rolling 4 week average of a value? Thanks, Garrett
-
Errors with 'Duplicate Calculation Exist'
I'm currently getting the 'Duplicate Calculation Exists' error. when building and saving a beast mode to a dataset. However this dataset currently does not have any beast modes saved to it. In addition, there are no cards to this dataset that currently use a beast mode with this name. I understand that this error will pop…
-
Calculation error: Duplicate calculation name
Over the past few days, I've been facing the issue of a calculation error: Duplication calculation name. I believe that other DOMO users might have also be experiencing this issue. Despite having different datasets, when validating a BM with the same name, a duplication error occurs. This problem started occurring a few…
-
How can I add an icon representing a file type for a URL into a table?
I have a data set which contains a column for URL's for file a user has upload and a second column that contains the type of file that has been uploaded. I have created a beast mode that displays a thumbnail of any uploads that are images. I now want to display an icon for items that are not images but cannot get the icons…
-
Convert datatype in a BeastMode
I have data coming in from a sql table, and I cannot change the datatype of it at the source. I'm trying to join on the columns but it won't join on certain rows of data b/c One column is varchar25 and the other is nchar10 from the SQL Server side it comes from. They are already string, so when I use the Magic Tile to…
-
Coalesce for a missing month?
I can't seem to get a magic to work, nor can I seem to get a beast mode to work. I am sorting data by month. If though, my data does not have data for May (5) then I want there to be a row for May, even if there isn't data. Somewhat obviously, a case statement wont work because again, when there is no data, then no row.…
-
trx_week not calculating correctly when the week crosses years
I am having an issue where the days in the 12/31/2023 week cross into 2024. I am summing hours worked for the week, but it only returns half of the hours. I have tried creating a new column to concatenate the year-month using various formulas noted below, but I still get the 'The calculation contained a syntax error'. Is…
-
Avg Time Formulas
I am having lots of trouble trying to figure this conversion out.. I have an excel file that I am bringing into domo.. within the card (table format) I am trying to get the average (as the average column already existing cannot be properly summed within domo). I am trying to take the 'talk time' divided by 'call id count'…
-
Array Function in Beast Mode
Hello, I created a card where users can filter multiple IDs at once. This is useful to quickly filter the card based on the account IDs that we got from another card. Users can simply highlight all the Account IDs, copy and paste them in the Input Text Box The variable is called enter_account_ids. Is there a better…
-
beast mode
Hi community, I'm new to domo and need some help. I have a simple data set (see below). I want to only view rows that have an order date. if it's blank, i don't to see it. I was hoping to use the filter but I can't figure out how to exclude blank dates, i only get options to filter by various date ranges. Or, what would be…
-
Returning all the same value.
I got this code to work, well kind of. Its only returning 110 CASE When Actual bid 2 >2700 THEN 120 When (model LIKE '%250%' OR '%2500%' OR '%350%' OR '%3500%') THEN 110 ELSE 110 END Tried this CASE When Actual bid 2 >2700 AND model LIKE '%250%' OR '%2500%' OR '%350%' OR '%3500%' THEN 110 when 'actual bid 2' <=2700 then…
-
I need syntax help. Bit of a newbie trying to teach themselves IF/LIKE/OR
The specific task is to identify if a truck is a F-250,350, 2500, or 3500. The Column is "model" that I'm looking for the partial match in the model column. I keep getting syntax errors. CASE WHEN `model`LIKE ‘%F 250%’ OR `model` LIKE ‘%F-250%’ OR `model` LIKE ‘%F250%’ OR `model` LIKE ‘%E-350%’ OR `model` LIKE ‘%E-250%’ OR…