-
Available work day
Hi! Is there a way to get available workdays onto a dataset? For us, that is basically M-F every week of the year regardless of holidays. The current field in here now called 'Date Worked' assumed the person entered a timesheet for that day. we want to capture the 'date worked' regardless of whether they did a timesheet…
-
Issue with Nested Case Statements
I have a dataset of call records. I am attempting to filter out records that fall outside of business hours when the 'Call Result' is 'No Agents in Queue,' based on the product the call was associated to. I have created the following Beast Mode calculation to do so: CASE `Last Leg Product`WHEN 'NPAC-CCS' THEN (CASE WHEN…
-
Beast Mode - forEach
Hello. So I have this dataset where I get item, work order and the quantities both planned and actual. This is to calculate manufacturing absorption %. Is it possible, via beast mode, to tell the function that for each distinct work order, it sums its quantity and displays it as the total of Actual production? If I do an…
-
Beast mode - Age buckets / grouping
Hello everyone, I am having trouble with a beast mode grouping outstanding records by age bucket. I am looking to calculate the number of days a record has open and then place the record within a range. Below you will find my existing beast mode which is an "Invalid formula". If someone could assist with the formula…
-
Create a dynamic date range with a beast mode
Hi, I want to create a dynamic date range to capture the following period: 100 days ago excluding the last 4 weeks (28 days). The date I want to use is signup_date. Is this possible with a beast mode?
-
Date Range Buckets
Hello, I am trying to create a way to look at upcoming estimated shipping dates but I keep getting an "error during processing" . I have made buckets for WIP based off days in shop field and basic case formulas in the past with no issues (See attached). I think I am having issues with my approach due to this being dates…
-
Pivot Table Average Summaries instead of Totals
Hi all, With the new pivot table card designs we can add Totals and Sub Totals which is great and sums values into collapsable groups. I can't seem to see a way to set a similar summary using a different aggregation like average, count, min and max. For example, I have data showing a number of staff working hours which are…
-
Visitor Frequency Beast Mode & Card building
I have an activity log for every activity a user creates on our website. I want to calculate for a time period the number of users that have visited once, 2-5 times, 6-12 times and 13+ or some such off the activity date and user ID. In SQL I would create a dataset of visits by user ID then group by that - however I want to…
-
Beast mode to calculate month over month user count changes
One of the metrics we calculate as a business is our user change month over month. Our main data set we work off of is an activity log dataset which contains the date of the activity, the user id, and details about the activity. For active users we calculate the distinct number of users for that time period such as the…
-
Data Aggregation issue in the Beast Mode Calculation while using Sub-Total and Header Row.
While we use the CASE statements the Aggregation in DOMO first performs SUM and then looks at the condition inside the CASE statement. This means that the following two conditions will provide similar results on the row level, but when the data is aggregated the 2nd condition will only look at the bigger value post SUM()…
-
Beast Mode Cumulative Sum Calculation for given scenario
Hi Team, Request you'll to provide insights and case statement to get to the attached desired results. - Cumulative Amount Current Year-2020 - Cumulative Amount PreviousYear-2019 - Cumulative Amount for last 5 Years-(2015-2010) - Cumulative Amount Lifetime Thanks in advance.
-
Account Ledger Running Balance Beast Mode
Hi All, I am having trouble coming up with. beast mode to create a running balance for an accoutn ledger. I have all of my charges and reciepts but i cannot create a running balance to show the correct totals. Any help with this would be much appreciated. I have atached a picture showing the card i am working with. As you…
-
Beast Mode "Share Calculation on DataSet" vs. Calculating in Data Flow
Hi all, Are there performance advantages to using the Beast Mode "Share Calculation on DataSet" to create a metric for a DataSet compared to putting logic/formula in a DataFlow to have the metric added as a physical column on the DataSet? Curious to learn others thoughts/approachs as to balancing when logic should be part…
-
MAX of SUM in Beast Mode Windowing Functions
Hello! Our org just had our windowing functions for Beast Mode turned on, and we're hoping to utilize it to calculate our MAX messages per second. Below is the logic I've gotten so far, but it does not work unless the table has all of the fields in it. We want to display the value dynamically, so we need to stay within…
-
Domo Governance Datasets Connector Beast Mode not stored on Drill Levels
Hello I have been working with our Governance Datasets to do clean up and review on our beast modes. I am finding that I cannot locate any beast modes on the drill levels of cards that are not saved to the dataset. I have reviewed the data in the 3 different datasets that contain beast mode data and I am not able to locate…
-
OFFSET function in a table view
Hey Dojo! I'm looking to create a table that will dynamically show change between the row and the row above it. We need the table to automatically update the formula when one of the rows is filtered out (which makes doing this in ETL impossible). My idea was to do this with an LAG function or an OFFSET function, but since…
-
Case Statement Help - Condition not being passed
Hi All, I've been struggling with this absurd problem when creating a beast mode calculation using case statement. Basically I'm trying to pass 2 conditions into my case statement but for some reason, even after validating the formula, only 1 condition is passing. My calculation is: (CASE WHEN YEAR(`transaction_date`) =…
-
How to create a Beast Mode calculation for fiscal year using a date field?
Hi All, I have a unique dilemma. I need to create a beast mode calculation to calculate our revenue for the latest fiscal year. I know I can just manually add the date filter criteria into the calculation or add a filter but the thing is the data is updated every day and we need the date filter criteria to be dynamic &…
-
Aggregating a column in Beast Mode
Is it possible to aggregate an entire column in a beast mode calculation within analyzer? (I have found videos explaining this within a SQL ETL, but not as a calculated field in analyzer). For example: In the table below I want to divide the value in the "efficiency" column by the averge of all values in the column. Right…
-
Ignore Filter in Beast Mode
I am building a report in a table in Domo. I am trying to compare a calculation result to a calculation result from the same day a year prior. I am currently filtering on a specific date, so that our employees can view the report for the date that they select. The first calculation…
-
Applying calculations to hundreds of columns in a dataset - best practice?
I have a dataset that has ~1,200 columns and I need to perform calculations on 495 of those columns (simple multiplication and division) and create a new column for each with the calculated value... Trying to do this in ETL will take forever to setup (would need 3 calculators, 2 of which will have all of the the 495…
-
Multiply Values from each Series - Manufacturing Yield by Station
Hello! I am trying to determine the overall yield of a manufacturing line. The data columns include the date, the station, which is a column of row labels representing each station in the manufacturing line, the number produced, and the number of defects. I am able to find the yield by station, by creating a yield function…
-
Find Count Distinct w. Multiple Factors
Hello! I need to find ‘new initial customers’ by sales agent at the campaign level. For the purpose of this report, we define a ‘new initial customer’ as a customer (Customer_ID) who entered into a campaign (Campaign_ID) within a specified time range (by calendar month). I need to only count Customer_IDs the first time…
-
Partition By Beast Mode as a Filter
I created this Max('Value') that is grouped by a certain NamingKey using the Partition By. I followed the syntax recommended by DOMO in the attached image. I was able to get Max and Min values and use them within a Case statement, but I could not filter from that Case Statement. The Partition By Beast Modes just don't…
-
How do I replace text with unicode
Hello, I'm trying to replace some characters in my table using Unicode Characters such as :white_heavy_check_mark: and with :cross_mark: This is the code I typed into the Beast Mode but it's not displaying it and instead only showed the literal '✅', could anyone please help? Case when `Last Week Actual` - `Last Week…