-
Beastmode Case Statement with NOT IN operator
-
locks = locks?
Hi all, (I recently posted something similar but updated my dataflow to a new output so wanted to share and clarify) I've got two columns, rate_locks_powerlender and rate_locks_powerseller, that I need make sure are equal to each other. The power lender is slower to update so we do not have data later than 9/11 so I am…
-
True/False Beast Mode Syntax
Hi All, I am currently working with two joined datasets. Each dataset has a date for each row that gets added. I have outer joined those datasets and am now trying to make sure that the number of date entries are the same in each data set. I can visually tell that they are the same but I am trying to write a beast mode to…
-
How to reference a Beast Mode in antother Beast Mode
I've seen this in Ideas Exchange, and it sounds like it's coming, but it's not here yet? What's my alternative for now? In my database, I have an attribute that contains values from 1 to 10. I need to invert these in Domo, and I have a simple beast mode which does that (1=10, 2=9, 3=8, etc.). I now need to reference that…
-
Calculating MoM, YoY, YTD in table
Hi Domo users, I have been trying to figure out how to represent some values in a revenue table and hoping you can help. Here is what I have so far: As you can see above, I have something like this cable that I want to replicate in Domo. For the most part I can do this in a pivot table in Domo, however I am not sure how to…
-
Formatting Summary Number For A Calculation
Hello All, I'm struggling here as I feel like I'm so close. I'm trying to show a summary number that is a calculation (Cost/Leads) and while I've been able to figure out the font size and color, I am still struggling to control the format to be a currency without decimals instead of the number its at now Right now, I've…
-
Sorting Beast mode
Hello! I'm trying to sort my beast mode where I'm normalizing my data to trend performance by the first month it's published and trending for a year since all my rows of data will have different dates in which they are published. The issue I'm running into is I can't sort the beast mode in order of Month 1, Month 2, etc.…
-
Last 13 Months Using Selected Date Slicers
Is there a way to pull the last 13 months for a visualization using a selected date in the dashboard? For example, if I filter for 12/2022 it gives me 12/2021 through 12/2022 in bars?
-
How would I get a percent change for each t value from baseline and chart it as a bar line graph
/* Get RCI avg of all scores that aren't baseline CASE WHEN `summary_order_rule` > 1 THEN AVG(`RCI`) Get RCI avg of all scroes that are baseline CASE WHEN `summary_order_rule` = 1 THEN AVG(`RCI`) END Get %change between baseline and followup scores for each summary order ((avg_followup - avg_baseline) / avg_baseline) * 100…
-
Month Over Month % Change of Total Number
I have revenue figures recorded at random intervals of days throughout months. It has not been updated since June, so I cannot use the automatic date filters in Domo without manually going in every month it gets updated and changing things around. I was able to get the most recently updated month and the prior month totals…
-
Help with a complex calculation that isn't working in Beast Mode.
I am trying to calculate a comparison of an individual's performance compared to the established average. This is for setting appointments. The appointment conversion ratio is found by (appointments set / number of contacts). The appointment conversion ratio / average gets the performance multiplier. 1 being average, 2…
-
How to get an avg in the grand total of a column with a BM with sum?
Hi, Im trying to use this BM CASE WHEN MONTH(Cycle)='10' THEN (sum($ New Annual Salary(in USD))/ sum($ Annual Salary(in USD)))-1 ELSE sum($ New Annual Salary(custom)(in USD))/ sum($ Annual Salary(in USD))-1 end and its sucessful but in the Grand Total I requiered an average not a sum, and usually I can use the agregation…
-
Beast Mode Formula error
Could you please help me identify an error in my formula: POWER((SUM(CASE WHEN Parts Kits Fiscal Year=SEG PMKA CAGR End Period THEN Parts Kits Qty END) / SUM(CASE WHEN Instrument Fiscal Year BETWEEN SEG PMPK CAGR Start Period AND SEG PMKA CAGR End Period THEN Instrument Qty END))/(SUM(CASE WHEN Parts Kits Fiscal Year=SEG…
-
This is coming out to be a date format beast mode. How can i change this to integer?
(((DATE - Lag(DATE,1) over (partition by ID,FAMILY order by INVOICE))))
-
Group By Condition in beast mode
It would be nice to have a "Group by" condition in beast mode
-
Sortable Link
We know how to add a link field to a table, using: Here is a way to get it to be sortable… Insert a throw-away attribute to the left of the link. instead of CONCAT('<a href="', `Card Link`, '" target="_blank">',`Title`,'</a>') UseCONCAT('<a title="', `Title`,'" href="', `Card Link`, '" target="_blank">',`Title`,'</a>')…
-
How do I get the following aggregation setup in domo?
I have a dataset as follows: and I want the aggregations as shown below (number sum is just the sum aggregation of column 'number' the first table is the actual data and the next three tables are the aggregations I want in the same sheet (i.e. the user should be able to add/remove the columns on their own and see those…
-
Greater than current date
Hi, I'm working on a beast mode that groups sites into four buckets (Digitisation, Acquisition, Portfolio, Buy Out'. The last 3 are working fine and I just need to setup the formula for 'Digitisation'. The logic for Digitisation needs to be 'if Contractor completion is greater than or equal to CurrentDate then…
-
Is there anything wrong with this calculation?
((case when Date = '2023-03-01' then sum (test1) end ) - (case when Date='2022-03-01' then sum(test2)end)) / (case when Date='2022-03-01' then sum(test2)end) Trying to calculate the %chg between two points in the dataset
-
beast mode using rank function
I have created a beast mode using rank() and using it to filter a chart. It is able to process the desired chart. But while saving the card domo says "There was a problem saving your card. If the problem persists, contact the Domo support team." RANK() OVER (PARTITION BY first_day_of_month ORDER BY COUNT(DISTINCT user_id)…
-
Want to add minutes of a particular day from different rows
I want the sum of downtime in minutes for a particular day. Eg: 14th May had a total downtime of 33 minutes. I want to have a single row for 14th May with downtime 33 minutes. How can this be done?
-
Quarterly Chart
I am trying to create a line chart and graph it by Quarters but the only thing is that instead of summing the values or taking their average, i want to only take values for the last month of the quarter. e.g For 2022 q1 it would be march 2022 , q2, june etc
-
Trigonometric Functions in Beastmode
We are trying to find a viable way to be able to enter a variable (zip code) and locate all records that are within a given radius distance of the zip code. This requires trig functions as well as variables. We are utilizing the beta variables version and trying to build this out. We have discovered that trigonometric…
-
Simple Mathematical Equations in Domo
Hello, I am trying to do simple addition, multiplication, and division equations using static variables or numbers in Domo. What is the best and easiest way to go about doing this? Using variables gives me "An issue has occurred during processing. We are unable to complete the request at this time." Using manually…
-
BETWEEN Beastmode function not working
Hi All, I often build beastmodes and find that the in-built function "Between" never seems to function. If you type "Between" into the function search, nothing comes up, but if you start typing "Between", it's an option like AND, OR, etc. would be. I presume the intended function would typically be utilised in truncating…
-
Compare two tables and find the difference
Im trying to move some of our reporting we do onto Domo. One of the things we do is build scenarios and need to compare them to what's happening currently. In excel we have this so the top table shows current data with locations by hour with a number filled in for the value. we then have a scenario table underneath this…
-
String Aggregation in Beast Mode
Hello everyone, I am trying to come up with a table that shows the unique emails of subscribers, and to which partners they're subscribed to. I'm trying to concatenate the partner field so that those with multiple subscriptions will remain unique. Is there a way to do this in a beast mode? I saw in some training video that…
-
Hi Team, Need help in converting a string value to date.
Hi Team, I have a column which is has string values. This column has data related to months and years. Example : Jan-23. The problem is when i am using this column in the chart, its not detected as a date and so i do not get options to filter month and year. I want a way by which i can convert these to a date value. And…
-
Remedying Data Recording Issues on the Front End in Domo
I have a dataset with item names. These item names have a preassigned "price" to them that is not in the source data (although I know what they should be). What has happened is that some people (not all people) record their transactions all at once, combining what should be multiple revenue values into a single one.…