-
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…
-
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 below AHT: currentRow - previousRow (from same column) (see detailed formula below) the only condition is that: if the computed…
-
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 below Sorting: TechName - A to Z Alarm Handled Store Time - Oldest to Newest Condition: If TechName is…
-
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…
-
Can you remove filtering capabilities for specific card level for Participants?
I don't want to remove ALL filtering ability for participant-level users, but there are certain instances where that would be ideal. Is that possible?
-
Filter metric by Beast mode dimensions
I have a Beast mode that configures source and medium dimensions into broad categories because Google's default channel grouping dimension is incomplete. (CASE WHEN Session Medium LIKE 'cpc' THEN 'Search' WHEN Session Medium LIKE 'paidsocial' THEN 'Social' WHEN Session Source LIKE 'google' OR Session Source LIKE 'bing' OR…
-
Way to Use Window Function to Find the Duration a Temperature Variable was Above a Threshold
I want to find a way to use a window function to find the duration a temperature variable was above a threshold, the timestamp at which the the temperature was above a threshold, and the range of temperatures when they were above the threshold. The data is organized as an identifier column, the timestamp column, and the…
-
Delta Difference
Hi Everyone, Hope you can help me with this one. I am trying to get the delta difference from both 2 months. Just to show how many volume increased previous to current month. Any reccomendations? Thanks!
-
Case statement
Case when Toggle = 'Key Brand' then ( case when Brand = 'BL' THEN 'BL' when Brand = 'SC' then 'SC' when Brand = 'RC' then 'RC' when Brand = 'RO' then 'RO' when Brand = 'PU' then 'PU' else 'OTHER BRANDS' end) END I am trying to use this case statement to make it react to toggle but i want to find a way around other brands.…
-
Grouping after Split Function
So I'm running into a bit of a snag. Say I wanted to just do the Beast Mode element and pull just what's in the Title(Column) for example: All this info is in the Title separated by a | if I wanted to pull the System name from the title and then group it along with others that come in with the same format but create a…