-
Doing a moving average using window functions in Analyzer
I have this salesforce lead historical dataset (which tracks Lead stage changes) and I want to show a month-on-month moving average of the number of days it takes a lead to convert to the next stage (e.g. 30 days from Stage 1 to Stage 2) with Stage as series/dimension in my card. The dashboard/cards that I'm creating is…
-
Exclude first Value - Rank & Window
I am currently calculating the contribution for my dataset and have already sorted my values in descending order using the rank tile with date and group for my partitions. What I'm hoping to do is sum the previous value + the following value until my last value would be the grand total. In theory, I thought using the rank…
-
How can I compare YOY data with an offset of a couple of days?
Hello, I'm 100% new to DOMO and I'm looking for some assistance. I'm trying to compare data from 2021 against data from 2020 using DOMO with a dataset connected combining data from multiple Adobe Analytics sources, and other accounts. Specifically I need to compare promotional revenue data for a Memorial Day promotion. I…
-
Summing up filtred values based on criteria
Hey guys, I will try to explain my issue, I'm really loosing hair on this one, hope wil get feedback from you
-
Conditional formatting
Hello Members, I have this unique situation where I need to show both Actuals and Plan bars ( preferred). But if my Actuals are less than 25 % of the Plan ( which is true in this screenshot ) , I want to show Actuals bar as red color.. I am open to switch to different chart but at the end I want Actuals to be shown in red…
-
I am trying to get the timecards created this quarter for last quarter
I am trying to get the timecards created this quarter (Q2) but for last quarter (Q1) the reference dates are created date(current quarter) and end date(previous quarter) so, I have this created in beastmode>>> (case When `TC: Created Date` >= '4/1/2021' and `TC: End Date`< '3/31/2021' then 1 else 0 end) how can I make the…
-
Hide row in html table if column data is empty
Hi all, We have a business rule where we only show data if the number of rows is >=7 because of privacy/pii concerns, and we do that with a beast mode calculation, and apply it as filter CountRespondents: SUM(COUNT(DISTINCT `ratingid`)) OVER () But when I want to filter/hide the rows where the Comment is empty, the…
-
Sum One Check Amount with multiple rows of the same data by using DISTINCT ?
I am looking to ONE "CHECK AMOUNT" per distinct "first name" AND "check date". the data source has multiple lines for the same check amount, but i only want to count one "check amount" per "first name" and "Check date" this data is in DOMO but i just downloaded it to understand the layout of the data better. Any Ideas ?
-
Separate Date from the text
Hi, I want to separate the Date from the text and put it in a new filed called "launch Date" For eg: Suppose the text is "Email 2021-03-01 best practices in Email Marketing" I want to separate out the "2021-03-01" text and put it in new filed called "launch Date". then I will update that filed datatype as a "Date" Please…
-
Weighted Average formula - beast mode
Hi all- I am using a beast mode to calculate the weighted average of days between two dates (payment due date and invoice date). Formula here: SUM((`PAYMNT_DUE_DT`-`INVOICE_DT`)*`RECPT_AMT_USD`)/ SUM(`RECPT_AMT_USD`) However, I realized there may be some zeros in the output that are possibly causing the weighted average to…
-
SUM with multiple conditions
Hello everyone, I am having trouble with a DOMO Beast mode sum Calculation. Below you will find my existing calculation. I am looking to add the value of all records that have a date to Customer in column A and exclude those records in column B that have a payment date. Essentially I am looking to calculate the value of…
-
Help calculating YOY and MOM beast mode calculations to be used in a standard table.
Data pulled in via API. Data using to calculate in use in other cards, so is clean and robust. Just need somebody with a little more expertise.
-
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…