-
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.…
-
Aggregate Count While Still Filtering By Time
I want to make a pie chart out of the following rows where a row value is based off the count (not just 1). The rows are grouped by time. The table looks like the one below. The problem is the chart doesn't aggregate Success to 12 but leaves them as separate series Success 5 and Success 7 in the legend. I have multiple…
-
Beast Mode: Count IF for user_id based on another column
Relevant columns in dataset user_id: unique identifier badge_level: a number from 1 - 4 user_badge_id: another unique identifier. Each badge earned generates a unique id I am trying to create a new column that counts the # of Level 3 badges the user has earned. Then I will create a Beast Mode to calculate the following %…
-
Can I omit certain values on line graph from being calculated in avg line?
I have an interesting case here, I have a cost per lead value being graphed by week for the past 9 weeks. Only problem is that when there are no leads the value is blank and the line breaks. I can fix the problem by using a beast mode to say when there are no leads to just zero out the Cost per Lead value. When I do that,…
-
Dataflow failed
Hello all, I get the below error after running my dataflow. As this consists for multiple inputs, I haven't still been able to trace the exact field causing it. But I do have a formula tile with this calculation.. " Failed to convert value '-3--3-01' from type 'String' to type 'Date'. " Some days this data flow runs…
-
Need to calculate the difference between two dates with proper date format
Need to calculate the difference between two dates in Days Hours Mins seconds format. Wrote the below case for date difference but not getting the required output. Getting output as shown above in yellow: Need output as : 4days 21 Hrs 20Min 27sec
-
Beast mode case change based on whether or not a filter is in use
Hey all, Is there a way for me to use a beast mode to calculate a COUNT when a filter is not in use but to use a COUNT(DISTINCT) when a specific filter is in use or when a filter is applied on a dashboard around a specific field?
-
YoY Chart
I want to create a YoY line chart with Time on the x axis, YoY change on the Y axis and Year in the series. So it would have 3 lines for the years E.G 2021,2022,2023 How can i do this?
-
I want to calculate difference between yesterday and day before yesterday.
I want to calculate the difference between yesterday and day before yesterday to see no. of files received in that day. my dates are in the below format in one column, i tried the datefiff function but couldn't get the desired results please help
-
How to show YTD data in Tabular format?
I want to display YTD data in a tabular format. How can I achieve this using BM. I have a dataset with columns like 'Date' and 'Metric' The attached screenshot is a general idea of how I'm trying to organize the data. Thank you!
-
Wildcard for numbers not characters in Beast Mode or Magic ETL?
I'm trying to create a new column based on the prefix of another column, but the prefix B### is categorized as type B, and prefixes BC and BW are categorized as another type H. E.g. Col_ori Col_new B001 B BC002 H BW001 H The wildcard % (i.e. using LIKE 'B%') will include all prefixes starting with B. How can I distinguish…
-
How to edit DATEDIFF to calculate beyond calendar year
Hi, I have an argument where I am attempting to calculate how many consecutive days have occurred since the last specific event (See pic below). But when the 'Year' filter is applied to the dashboard and also filtered by a 'Region' and the event occurred in the prior year, I get a "no data in filtered range". Is there a…