beast mode
Discussion List

Toggle series in bar chartHi, I have a bar chart that has a goal as the y axis and then a current total as the series (as wel…

How to aggregate a case statement that uses a fixed functionHello, I was hoping somebody could help me understand how to sum the following case statement. case…Answered Chris_Wolman 18 views 2 comments 0 points Most recent by Chris_Wolman Beastmode & Analytics

Sum Orders, Line Count, Sales by day of the week (Friday, Saturday, and Sunday)Hello, my dataset has 7 columns: Invoice date, location, orders, ... invoice total (see screenshot)…

Calculate time between two dates during business hours, excluding holidays & Sat/SunNeed to calculate the elapsed time/minutes between Start Date and End Date, using business hours of…

Dynamic Rank Beast ModeDoes this functionality exist yet? When I try to do a rank() in a beast mode it skips from 1 to 16 …

Is there a way to aggregate the output using a FIXED function used in a CASE statement?I'm a MajorDomo in a large retailer, and I'm working to rewrite our TY/LY Beast Modes to calculate …

Beast Mode: How to calculate Fixed Average dependent on a different Fixed SumHello! I have a dataset with the following fields: Day, Company, Spend, and Revenue. I want to f…

4Beast modeの共有先を限定できる機能「Datasetに計算として保存」すると便利なのですが、汎用データセットを共有していると、複数のユーザーか…

5AnalyzerでBeast Modeを「自分が作成した」ものに絞り込むフィルター汎用データセットを共有していると、複数のユーザーからどんどんBeast Modeで新しい変数が作られていって…

Calculations using analyser or beast modeHi, I have figures from a dataset that I need to carry out calculations on (addition, subtract etc)…Answered louiswatson 32 views 4 comments 0 points Most recent by DashboardDude Beastmode & Analytics

Translate this errorHi, I am trying to write a weighted average formula into an ETL. I am not sure what this error mea…

Beastmode for multiple row comparisons to one source row?I'd like to add a third column in a table visualization that displays the % change for the current …Answered ✓ RocketMichael 53 views 4 comments 0 points Most recent by RocketMichael Beastmode & Analytics

Comparing monthly income in a certain year to the same month income in previous yearHello! I have a dataset which contains departments, dates (several years, daily) and income per tha…

Calculating MoM, YoY, YTD in tableHi Domo users, I have been trying to figure out how to represent some values in a revenue table and…

I need to create a dynamic report that shows me data between 2 and 5 days agoI've tried a variety of methods but can't get seem to get it accurate. Any help would be appreicate…

Capture Duplicates in DOMOHi DOMO  Is there a way to do this excel formula in Beastmode? =COUNTIFS($A$2:$A$8, $A2, $B$2:$B…Answered ✓ WorldWarHulk 63 views 6 comments 0 points Most recent by WorldWarHulk Beastmode & Analytics

I'm stuck. Sum of a Windowed/Partitioned Sum???I keep running into a wall with this. I think there is an easy answer, I just can't find it for the…

Filtering Rows without Displaying Them / SameStore ComparisonI have a dataset of sales data with one record per store, per day, across multiple years. I used @j…

Removing Duplication and Ordering Objects within a Concatonated FieldHello, Our company offers several different product lines and I am attempting to count how many tim…Answered n____l____ 71 views 4 comments 0 points Most recent by n____l____ Data Platform & Data Science

How to create a column which SUMS based on the grouping of another columnHello, I am trying to write an ETL which sums a value based on the grouping in another column (inv…Answered Mattwjones 35 views 1 comment 0 points Most recent by MarkSnodgrass Data Platform & Data Science

Convert all dates to last day of yearI am trying to convert all my dates to the last day of the year in a beast mode. I have a column in…

9Window Function KB articleDomo does not appear to have a KB article for window functions despite having one for (newer) Fixed…

I have an unexpected outcome of a beast mode calculated column, can you help?Hey, I've been working on a dashboard that has a radio selector to select which project the dashbo…

Beastmode for Datetime to Group by Month in a Mega TableHi. I need to create a Logins by Month Mega Table. I have a datetime field for each login. I want t…