-
Create a summary number as calculation aggregate sum expense minus aggregate sum reimbursements
Hello, I am trying to create a beast mode calculation to show balance remaining after (sum of all expenditure) - (sum of all reimbursements). here is my current calculation. (case when `Expense Type` = 'Expenditure' then sum(`Account Balance`) else 0 end) - (case when `Expense Type` = 'Reimbursement' then sum(`Account…
-
Group in Beast Mode
Is there a calculated field in beast mode to group names for a filter? For example, data looks like this on card slicer: Customer A- UK Customer A-USA Customer A- Mexico Customer B- UK Customer B-USA Customer B- Mexico Is there way of grouping Customer As and Customer Bs together to show on the card slicer only the…
-
Is there a way to create Running Total using Beast Mode?
Hi, I'm building a table card and I would like to create a column that performs a cumulative sum, like the following: | Week | Amount | Running Total | 1 | 100 | 100 | | 2 | 50 | 150 | I tried to do this using SQL Dataflow, it works fine. However, I want to be able to add filters that modifies the Running Total and thus,…
-
Average
I have created a Card for volume by hour. Now the department wants a card Average volume by hour. COUNT(`Case Number`) OVER (PARTITION BY HOUR(`Created Date`)) I'm not sure if I'm doing it right as it's creating duplicate Hours and Volume. I have done it in ETL and getting the result but then I cant do filters as It's a…
-
Number of Months Left As Displayed in Table
Is there a dynamic beastmode that counts the number of months displayed in a table?
-
Rolling Percentage
I want to have a rolling percentage of a value across a series of values. I want to be able to choose the value and the size of the series. Here is an example where I want to know the percentage of Oranges for the last 5 values. Also, Is it possible to do a running percentage of the value? Just thought of that. Ideally I…
-
Beastmode YoY Variance Calc
Hi All, I am working on a beastmode that I thought would be relatively straight forward, but is giving me some issues. I am trying to do a YoY variance calc starting in 2022. The problem I am running into is that the 2021 numbers are not being subtracted out of the 2022 numbers. When I look at the previous year info, it's…
-
Count snapshot data (for HR Turnover)
I am trying to find a way to count number of rows per month (spanning over 3 years and counting) to get the total number employees for each month in variable form. The data structure is set in a way that the number of rows should be equal to the number of active employees as of a certain snapshot date. I am not sure if I…
-
Beast Mode formula: not calculating/populating
Hi - i created several Beast Mode formulas (TQ, LQ, QoQ). I have no issues adding TQ and LQ to a Pivot Table chart. When I add QoQ beast mode to the Pivot Table, no values are populated. The QoQ formula is a difference of TQ and LQ. I can add TQ to TQ, or LQ to LQ and get a result. I just don't get a result if I mix TQ and…
-
Create time column for Line chart
Hey guys! So I want to create a line chart that shows the sum of a total over the course of a 24 hour time period. I have a timestamp column where I extracted the time but tbh it looks weird. So I was thinking to improve the chart, is to create a column that include all time over a 24 hour period (not military time) and…
-
Beastmode adding multiple different values from the same column
I have a marketing channel column. That has a dozen descriptions from all of our different marketing channels. I am only trying to take the count of a few of them together i.e. Yelp, Facebook, google ads, etc... How could I write a beastmode that I can pull out only the channels that I want to add together?
-
Trying to add percentages in a pivot table
Hi, Would anyone be able to help me with the following: I'd like to have my pivot also show percentages of these two columns, I managed to get it to look like the bottom part however when I add a new column in the pivot it says the processing has not worked. Not sure how to add in the percentage? Thank you!
-
Beast Mode Validated but not working
Hi all! My beastmode here is validated but it shows a message "An issue has occurred during processing. We are unable to complete the request at this time. " This is my beastmode: SUM(`Real Produksi TBS Tanaman Produktif (ton)`) / (SUM((`RKAP Luas TM (ha)`) / (COUNT(DISTINCT `Date`)))) So basically the context is: "Real…
-
Simple Addition and Subtraction
Hi There, I am having trouble in returning correct values with a simple addition and subtraction beast mode. It appears that any column with a blank value will not return a end value. And any row with values in all columns calculates properly. Any suggestions on how to calculate to consider blank values as zero value?…
-
Rolling 3 Mo Avg - Breaks Card
I want to calculate rolling average of the previous 3 months. I was going to do this using windowed lag functions ( (LAG(SUM(`Sales Amount`),1) OVER (ORDER BY `YEARMONTH`)) + (LAG(SUM(`Sales Amount`),2) OVER (ORDER BY `YEARMONTH`)) + (LAG(SUM(`Sales Amount`),3) OVER (ORDER BY `YEARMONTH`)) )/ 3 Each Lag works individually…
-
Nested Beast mode
Hi everyone, I have some data like companyid, journeytype, ratingid and npsRating. With ratingid and npsRating, I usually calculate NPS (net promoting score) in beast mode like this: (((Count(DISTINCT (CASE WHEN ((`npsrating` >= 9) AND (`npsrating` < 11)) THEN `ratingid` END )) - Count(DISTINCT (CASE WHEN (`npsrating` <=…
-
Is there a way to check if a field has more characters than a specific amount?
Hi! I am trying to set up a beast mode function that checks if fields are correctly filled out in our asset tracking software, and lists out any asset that does not meet all requirements (ie fields not filled out or have been auto-generated by the software itself). One thing I am curious about is, I'd like to be able to…
-
Beast Mode Calculation in Summary Number
My beast mode formula goes something like this:- SUM (x) / SUM (y) I am not able to use the above beast mode for my summary number. I am looking to get the average percentages, but the aggregation field is greyed out and I get the message "using aggregation in beast mode formula". Any help will be appreciated. Thank you
-
Question related to case when formula in beast mode
Hi, I would like to ask about the beast mode formula related to this situation. I would like to get the data like this: If rating 'Superb' and 'Outstanding' are below 10 % then it's 'Below' If rating 'Superb' and 'Outstanding' are above 35% then it's 'Over' However, 'Superb' shouldn't be more than 5% What is the suitable…
-
CountIf function in Domo
Hello I have a data that contains all the cases submitted and their submission date and in another column it has the approval date which can be in another date/year. I am trying to get the conversion rate (approvals/submissions) for each month, because of the timing they might not happen in the same month. A pivot table…
-
Aggregation by month with segmentation
Hi there. I am breaking my head about something that just feels so easy to get. Is there somebody who can help me out with this please? I want to show a bar chart grouped by month (please see example below). The bars then should be segmented into categories. The data is coming from the user activity in a tool. The idea is…
-
Beast Mode Editor - Comment Out Lines
Most modern IDEs have the ability to highlight several lines of code and then press a key combination (CMD + /) to automatically comment out the highlighted rows. It'd be great to get this feature within the Beast Mode editor to diagnose beast mode issues easier instead of having to manually comment out each individual…
-
How to SUM working days correctly?
Hi everyone, I have a strange problem. Probably more of a SQL question than a Domo question, but here we go. I have a typical date column (yyyy-mm-dd) and a column called "total working days in month" where it returns a aggregate value of the # of working days for each month. Below is an example (just assume every date is…
-
use fields from different tables group by date to calculate percentage
Hi, I am trying to calculate a percentage using two fields from two different tables in SQL Magic Transformation. Table a looks like this: Date All Revenue 09/01/21 100 09/02/21 200 Table b looks like this: Date HDM Revenue 09/01/21 90 09/02/21 170 I need to build a table that would calculate the percentage of HDM Revenue,…
-
Beast mode calculation for aggregating data
Hi, I have a numeric field called "days until due" which contains negative numbers for outstanding items from -1 to -100. I am trying to group these using a beast mode calc. but keep getting syntax errors. For example, when "days until due" is from -1 to -9 days I want it to be grouped as "1-9 days", -10 to -19 days would…
-
Multiple conditions using case statements but not getting correct results
Hi Domo Community, In Beast mode, I've been trying to parse out some data for visualization but cannot get domo to display the right numbers. For example, with the data below, domo only returns the entries for one of the lines for Marketing and LeadIQ for SDR - it won't give me the sum of Display, Direct, Event or the sum…
-
Can you create a beastmode CASE when for values between two numbers?
I'm looking at influencers and their number of followers and want to group the data: number of follower: 1-50000, 50000-100000, 100000-200000 and so on. I was going to use the case when beastmode but cant find a between function to select the relevant numbers. Any help?
-
How to aggregate CASE Statement values?
In my dataset, I have three different tests that aggregate the field Forecast differently. Here's a beast mode I made that works pretty well, except when I'm trying to add them all together: CASE WHEN Test = 1 THEN SUM (Forecast) WHEN Test = 2 THEN SUM (DISTINCT Forecast) WHEN Test = 3 THEN SUM (DISTINCT Forecast) END when…
-
Please I need help with setting up a retention chart
Hi Domo gurus. I'm trying to create a "line + grouped bar chart" similar to the ones attached below. My goal is to create a chart that shows monthly cohorts of users who have made '100 api calls" and showing x% who returned to make other 100 api calls at the interval: 31 - 60 days, 61 - 90days, 91 - 120days, 121 - 150days.…