-
I want to understand average sales within 1 year of client sign up
I have a dataset where each row is an individual sale that contains the sale date, client start date, client ID, and sale total. I want to be able to chart the amount an average client spends within X time of their start date where X is a variable that I can alter from the card. Ideally, I'd be able to split the ouput by…
-
How to calculate % change between these two years in a beast mode on several columns of data?
-
How do I set up a Beast Mode to count distinct events within a date range?
Hi Domo geniuses, I have a dataset with a timestamp 'Start' field that tells me the date and time that a user session began. There's another column for User Session ID, which has its own unique ID. I want to count the number of distinct user sessions in the first year but Domo is having difficulty processing the data. The…
-
Beast Mode
Hello all, I need a little bit of help with this beast mode. I have locations and flags indicator in the dataset. All i am trying to achieve using IN function is, if locations are in A,B,C and flags are Y then HUB else NOT HUB. I just want to bucket HUBS and NON HUBS. The issue there are some that may have both. In other…
-
Calculation inconsistently disconnecting from Date field
Howdy y'all! What I imagine would be a simple Beast Mode formula is confusing me and my team. In advertising data from Facebook, we are making a new field called 'Test Facebook Engagements' that is the sum of reactions, shares, and comments. Here is the formula: SUM(ActionsPost)+SUM(ActionsPostReaction)+SUM(ActionsComment)…
-
YTD Calculation
Hi, I am trying to calculate a YTD number. I have a card that is set to Current Month and im trying to add a column that includes a YTD number. However, I seem to just keep getting this months numbers in that column. I have tried a variety of beastmodes but none seem to work. Ive tried SUM(CASE WHEN Fiscal Months >=…
-
trying to create a beast mode calc
Hello, Can you please assist on helping me with creating a beast mode calculation. I've been trying to create one but it doesn't seem to calculate what I need. The column dimension I have is a ticket count of how many tickets were created on a date entered for each day of the month. The rows are different departments. The…
-
Domo Beast Mode - Formula validated but nothing reporting out
Morning! We are trying to create a restocking report so that our store employees can restock the floor as items sell. Below are 2 versions of the copy of our formula and the report in analyzer. 1st version below - utilizes the filters option and I placed the beast mode into filters and apply a >1 to reflect Qty Sold >0…
-
12 week average for a designated column
Hello, I'm trying to write a Beastmode that calculates the 12 week average. The column I want to average is "Net Cost" and the date column is "Week Start Date". The end goal is to have a beastmode that I can use as a value on a table that shows each distinct "Week Start Date" and the 12-wk-avg of Net Cost preceding that…
-
Highlighting data x location which does not meet a specified target
Hi, I have created a pivot table with a formula 'Weekly Target Flag' which highlights locations which have not met their weekly target of safety Observations. The problem is to get the data to highlight I need to add the formula as a column. The information then appears in the table. How do I create a formula which does…
-
Date Format formula
Need a date format formula to take this date from 24-hour format to 12-hour format so my date and time goes from 11/02/2023 15:53 PM to 11/02/2023 3:53 PM. Thanks
-
Concat Formatting
Hi, I am having a hard time removing the spaces at the end of one of my columns. The beastmode im using is CONCAT(Consignee Address,', ',CONSIGNEE_CITYNAME,', ',CONSIGNEE_STATE). Some rows have a lot of spaces behind the consignee address and ends up looking like this 3835 KNIGHT RD , Memphis, TN
-
Add a color rule when result is a case statement?
I need to add a color rule to a date field where I added a case statement to show no data entered. The color rule only allows me to choose a date. Any suggestions on how to add the color rule when it shows 'incomplete' in the data display? This is the case statement I used: CASE when Oct '23 Required= 'Yes' AND Oct '23IS…
-
How to write a function that returns positive if function contains values from another column?
The title is a little confusing, but basically I want to write a function like this: CASE WHEN `Track Split` LIKE '%AZ%' THEN 'AZ' end EXCEPT, instead of basing it off of a string, I want it to pull values from another column. I have a lot of changing data from row to row, so I want the row to check to see if the data…
-
how do you add the remarks in DOMO beastmode?
I tried to use # but it doesn't work… example: #we don't count unique here becasue there are participants have the exact same name#
-
How do I create a MoM variance formula when the date format and interval varies for all entries?
Here is a sample data, where F11 is for month of November, F10 is for month of October-
-
Date filter
I have data that has reporting data for every day. I need help creating a quick filter on dashboard when i select it and see last 7 days
-
Remapping nulls in Analyzer
Hello, I have a question about the remapping nulls function in Analyzer. Maybe I am not understanding what this function is supposed to do, but basically I am trying to replace all blank cells in a column with another numerical value. However, when I do it through the remapping nulls function, I see no change in the cells…
-
Dates Being Filtered with Fixed
I'm using the following FIXED expression in one of my Beast Mode functions. The function is showing the right numbers, but when I try filtering by errorCode, it only shows attempt numbers for days when the errors occurred. I want to see the number of attempts for each day, regardless of whether an error was selected or…
-
How do I select specific rows in a data set based on a single variable date filter?
We have products that move through different status. As they move through these status a new row is generated in the data set (see example below) with the product name, the new status, the date the status started and end status date (set to 1/1/2050). The end date of the previous status is also updated. As a user, I want…
-
Creating a case statement based on Row Header
Hi, Would it be possible to create a case statement that basically looks at the row label and then takes the variance of the two? For example One column at the end called variance and for loads it takes the variance and for MPL it takes the variance etc.
-
Search for keyword (from text input variable) in a phrase
Hi all, I am trying to find a way in Beast mode in which a user can input a text(keyword) in a box and then the formula would search the phrase to see if that keyword exists. The problem I run into is that I need to add '% and %' respectively to a custom variable as part of LIKE. Can something like CHAR(37)& custom…
-
P&L % of sales
Hello, I have a p&l that breaks out all balances by line item. I am trying to show this cards values as a % of the top line item 'Manufactured' How would I go about creating this beastmode to do this functionality? For example: 2023 Jan shows 2.3 for manufactured. If Warranty cost was .5 then I would like to see .5/2.3 on…
-
Tab Functionality in Beastmode Editors Broken
For years when pressing tab on the keyboard when in a DOMO code editor it has functioned like an auto complete or a tab space entry, however recently this functionality has broken. Tab no longer autocompletes nor does it allow to add quick spacing for code readability. Instead, it moves to the next element in the beastmode…
-
Beast Mode
Hey Guys, Coming today with a beast mode question. See attached screenshot for reference. I have a dataset that looks like the attached and want to calculate the value of those ID's. Here is a catch, I want to count only EITHER unique ID's (those that do not have any Revisions), or the latest revision for a given quote.…
-
Tab Autocomplete Messed Up
Hi Domo. As of a couple weeks ago, when the tab key is pressed to autocomplete the column name in a beastmode, the cursor is automatically moved to the Save button instead of to the end of the column name that was autocompleted. How can I change it back to the way it was before? Is this something I can do myself or is it…
-
Filter Column Data By Value
To preface, I am a beginner at using DOMO so this may be something easy that I overlooked. I've blended two datasets and am attempting to have a column show aggregate data for specific locations based on a particular value. Example dataset one shows KPIs for a bunch of different metrics based on location, all that is…
-
How to use Hyperlinks in Tables
Below I have been given some code by my dev team to add to a table that is to act like a popup window when the user clicks on a certain record on that table. Is there a way to do this in domo? <button onclick="window.parent.postMessage({ type: '___', value: '12' }, '*')">____: 12</button>…
-
How do I calculate these in Beast Mode?
I created the nested beast mode below and got this error message 'An issue has occurred during processing. We are unable to complete the request at this time.' , raised a support ticket and was told that beta feature(nested beast mode) has been closed/ no longer available. How else can I do these calculations: AVG(…
-
Beast mode
How I can limit my percentage calculate to be capped at 100% only for those calculations where its exceeds 100%, if not then it should show the below 100% values?