-
Beast mode calculation
I want to create a beast mode calculation which should be something like this Value for current month this year - value for current month last year / Value for current month last year How can i do this?
-
Omitting rows in pivot table
Any way I can omit this section in a pivot table but keep the 2021 Total?
-
Totalling certain rows
I have a question about totaling data in tables. I have two sets of data from different time periods 2021 & 2023, and I'd like to sum the respective metrics for each. I have two different tables present that may aid in getting this solution done. For the first image I want to add a column after the 2021-12-01 column to…
-
Case Statement with YTD
Hi Folks, I'm trying to derive this through Beast mode calculation. Requirement: Case statement Score 1 - If my error % is 0 - 75% Score 2 - If my error % is 75.1% - 95% Score 3 - If my error % is 95.1% - 100% (Includes 100) Score 4 - If my error % is 100% (YTD) Finding difficulty in writing a case statement for 'Score 4'.…
-
FIXED BY Beastmode trouble shooting
Something is not working quite right and I am having a hard time figuring out what is going wrong. We're trying to see the % of registrations by year, by day of week (sun, mon, tue, …), by hour of day, and then to be able to filter by locations. So in ETL, for the numerator, I am grouping by Year, DayOfWeek, Hour of day,…
-
Build a Data Time field from columns containing date, hour, minute, second
I've got a data source that has separate columns for date and time that I need to combine into a single data time field. The length of the time field differs based on the hour (sometimes 1 digit hour, sometimes 2 digit hour). I have split apart the time field based on LENGTH() into separate columns for hour, minute, and…
-
Group by when using case statements?
I'm trying to group the column 'opzegreden' into one line if the sum is below 5. I'm using the following beastmode which gives me not the desired result (see screenshot) case when sum(Aantal) <= 5 then 'Why' else Opzegreden end If I use the following beastmode then it does it work and does group.. case when Opzegreden like…
-
Domo external Link to ADP
Hi , I am trying to create a link on associate id (Domo) when clicked on it would take to ADP (https://www.adp.com) and I have used this but it seems to be not working(just adding a link but its not opening up in a new window ) .Please if anyone can help ? CONCAT('<a…
-
I want to fetch count of data for a specific time frame (mon-fri)-(9-17)
I have data for all hours in a day, but I want to filter out data from only business hours mon-fri (9-17)
-
I am using this beast mode but it wont let me save the card
count(ID) over(partition by Clinic,Product)
-
Trying to calculate Rolling Averages/Sums over the previous year
Hey all, I have been stumped trying to figure out how to create a specific calculation. Let's say I have a column that counts number of orders and one that counts dates of orders by month. I want a way to calculate the total count (or sum) over the previous 12 months specifically, and display these results on a line graph…
-
Rolling Averages
Hi all. There's something so simple in Google Sheets / Excel that I cannot believe the might of Domo can't do it but a) I cannot work it out and b) it seems from going through the forums, it cannot be done easily. There hasn't been a post on it for 6 months so I'm hoping there may have been some developments. I won't to…
-
Caculate percentage in same month when using two date columns in same data table
Hello Domo Community, I am trying to count the number of distinct product id’s that had a field issue during a month and compare that with the count of sales units in that same month. The data looks like this: Unit id Sales Date Service Date 1 1-Jan 2 2-Jan 2-Feb 3 1-Feb 4 2-Feb 2-Apr 5 1-Mar 6 2-Mar 7 1-Apr 8 2-Apr 2-Apr…
-
How do I bucket (group) different Levels in Beast Mode?
I have levels ranging from Level 02 - Level 16. I'd like to group them by Level 02 - Level 07 Level 08 - Level 11 Level 12 - Level 16
-
Does Beast Mode support using "Contains" to Identify Value Count
Hey there… I have a field called PresentationName where we (unfortunately) use a text string as part of the PresentationName to identify a Type of presentation. Clearly we need to pull that out into its own metadata and will in the future. But for now, I need to find a way to create a calculated field that lets me get a…
-
Domo IDEAs Conference - Beast Modes - Number Formatting
Greetings! This is another post highlighting a beast mode from my Domo IDEAs conference session. This one covers how to format numbers a number when concatenating with a string. Problem: When concatenating a string with a number the resulting value is a string and unable to utilize Domo's built in formatting. Solution:…
-
Simple Reg ex help
I have rows that look like this: Interview with Bob Dylan - CSM and want to parse just the CSM. I tried using Replace Text file, selecting reg ex and using this: -.* but it returned the former portion. Any recommendations on what reg ex to use?
-
Count Attribute Instances instead of Projects
Hi everyone! In our system, a project can have up to 9 go-live dates. I am comparing our 2023 planned go-lives to the actual go-lives, to determine if they were on-time (with a 25 day allowance) First, I use this BM to determine if the go-live was in 2023: case when Year(Actual Business Go-Live 1 Date_p) = 2023 then 'Yes'…
-
Average of a difference in Timestamps
I have two timestamp fields: completed at and delivered at. I want to find the difference of both and take the average. The dates include a window that is sometimes over a day. I read this By @GrantSmith which is useful. Is there an easy way to do this without breaking up each segment (day, hour, minute, second) then…
-
Preserve the dynamic page date filter while calculating the aggregate results of diff dates fields.
So my question is essentially this: I have two totals i wish to use for a calculation. The problem is that each total is arrived at using different date fields. If I didn't want to retain the functionality of the date page filter, I could do that in beast mode, but i'd like to exhaust the possibility of retaining that…
-
Column created with Beast mode with numeric and porcentage format
.Dear community, this month I have receipt separately two cases with the same concern: The users have shown to me functions created with beast mode, inside a pivot table card. The goal is set in the same column figure with number format and percentage, including the symbol “%”. I have attempted so many ways, but I don´t…
-
Need Help: Subtract CurrentRowDateTime - PreviousRowDateTime from same column
Hello, please help me create this in DOMO. Thank you. Here are the columns needed: Alarm ID = (given)Alarm Handled Store Time = (given - sort oldest to newest)AHT = with formula, see screenshot belowAHT: currentRow - previousRow (from same column) (see detailed formula below) the only condition is that: if the computed AHT…
-
Need Help: Subtract CurrentRowDateTime - PreviousRowDateTime from same column
Hello, please help me create this in DOMO. Thank you. Here are the columns needed: Alarm ID = (given)TechName = (given)Alarm Handled Store Time = (given)Average Handling Time (AHT) = see detailed formula and condition belowSorting: TechName - A to Z Alarm Handled Store Time - Oldest to Newest Condition: If TechName is the…
-
Single Value Card Division
I have two single value cards. Card 1 is a overall total of all possible values and card 2 is a filtered subset of card 1. Is there a way I can divide the two cards? I know that you can just make a new beast mode with both calculations (Ex. Card 2/Card 1). However that does not work in my case due to Card 2 being a…
-
How to filter cards by a name dimension
A user recently ran into trouble while creating a dashboard. According to them, the dashboard had about 10 cards in it. One card was powered from one dataset, another card was powered from another dataset, and then 8 cards were powered from a third dataset. Their question: Is there a way to filter all cards by a name…
-
Join vs Append
I have one dataset date/dept/machine/product/defect/no of def. Second dataset is date/dept/machine/vol. There will be multiple defects on the same date from the same dept and same machine (defect and product may differ). When I join this causes the vol to duplicate for each product / defect entry. How do I create a beast…
-
Case statement with multiple conditions
currently I have this query and I have 16 exclusion reasons. Is there a more efficient way to write this beastmode? CASE WHEN exclusion reason 1 IS NULL THEN CASE WHEN exclusion reason 2 IS NULL THEN CASE WHEN exclusion reason 3 IS NULL THEN CASE WHEN exclusion reason 4 IS NULL THEN CASE WHEN exclusion reason 5 IS NULL…
-
Look for text within multi-selection value
Hi all, I currently have code like this, which converts some selection values to a shorter display value when Business Division_p = 'Biologics' then 'Bio'The problem is that the attribute is multi-selection, so when there is more than one value selected, there is no match. How can I change this line of code to look for…
-
How do I get unique values from a column?
Hi all. I need help in getting the unique values from a certain column. See example below Say I have this column below with multiple duplicate names in it, I only need to show one for each name. Please help. If it's possible through beastmode, it would be better, because I'm also utilizing slicer/filter for this card, so I…
-
Lag Function Giving me Values that Don't Exist?
I'm trying to create what should be a simple table that shows job Last Quarter Salary, This Quarter Salary, and Percent Change. However, my Beast Mode is giving me values that aren't even on my table. The Current Salary is displaying fine, but the previous quarter's salary is giving me a fictional number. Here's my formula…