-
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…
-
Sum of units sold, rolling 30 days
Looking to replicate the exact data layout above (side by side columns) in a table in Domo. So units sold by SKU by month (got this far) but also a column for rolling L30 Days sum. I created a new column in the dataset for count of days from current for each row DATEDIFF(CURDATE(),(Calendar Date)) but having a challenge…
-
Difference in Business Hours
I'm looking to get the difference in 'business' hours between two date/time fields. The business hour range is 9:00 - 17:00 (or 9am - 5pm), within weekdays. Additionally, If a user enters a Start Date after 17:00, the start date should get pushed to 9:00 of the next business day. For example, the following should have an…
-
Averaging time/returning only whole numbers of a fraction number
Is there a way in a beastmode to make the following example numbers on the left below remove the numbers after the decimal? 14.1925 — 14 15.999 —- 15 0.98 — 0 I am trying to get the average time of day that donors answer their phone when we call. So here below this donor answered his phone at these 3 times (hh:mm:ss):…
-
Beast mode to find last working day
Trying to figure out a beast mode that will filter my data to the last working day. Business works Monday-Friday. Want to be able to set chart to yesterday so that for daily morning chart shows yesterday's data. On a Monday it would pull data from Friday instead of Sunday. If there is a better way to do this other than a…
-
Creating a group.
So I wanted to generate custom groups based on the first word being pulled from a data field. Example: System | Application | Client | Problem Say I wanted to pull whatever system app would be and generate a group for it to display on cards via beast mode. Also, would the same concept be possible if I combined two work…
-
How to build filters with images or icons
A Domo user was recently having a hard time figuring out how to incorporate images and icons into her filters. Here are a couple of awesome videos that helped her solve her problem. Hopefully, this can help anyone who runs into a similar issue in the future!
-
Why is this not working
case when Sales/Volume = 'Sales' then case when YEAR(`Datestamp`) = YEAR(CURDATE()) -2 then CONCAT(ROUND(SUM(Sales_USD)/1000000, 0), 'M') END
-
Query Based on a Value Between Two Date Columns
I've got a data set that includes job tickets with create_date and last_update columns. If the date range for a card is set to include a date in between the create_date and last_update, the ticket should be considered "open" at that point in time, and any tickets outside of the date range should be considered "closed" at…
-
I am trying to use a case statement with a Time field for a table but when
I am trying to use a case statement with a Time field for a table but when i do it the values come out to be empty
-
Possible to update multiple filtered dashboards from aggregate dashboard?
Hi all, I currently have a dashboard of about 40+ cards and am wondering if it's possible to create copies of the dashboard that filter the data (and doesn't allow for an unfiltered view). Essentially, the dashboard aggregates data from several partners but I want to create create dashboards for each partner without them…
-
Finding averages based on selected ID (client)
The data I am working is at an asset level (example below) and I would like to find the average of all client ages accurately when looking at any segment of asset. Client Account Asset Age Client 1 Acc 1 Sec1 50 Client 1 Acc 1 Sec2 50 Client 1 Acc 2 Sec3 50 Client 1 Acc 2 Sec4 50 Client 1 Acc 2 Sec1 50 Client 1 Acc 2 Sec2…
-
how to aggregate nested average case statement
Business task: "what percent of this region's sites beat their target signups YTD"? So I want to take the average daily signup for each site within a region and see if it passes its target. If it does pass, it gets a 1, else 0. After this, I then want to aggregate it to the region level. So for example if 5 out of 6 sites…