-
Extract the string values in between stroke and question mark in a URL
Hi Domo, I am looking for a way to extract the string values in between stroke and question mark in a URL Example URL: https://dam-bc.com/content/67-making-AI-trustable.pdf?_gl=1*ckt29z I want to extract this part of URL: "67-making-AI-trustable.pdf" Ideally if I can do that with a beast mode formula would be great. But if…
-
COLUMN NAME CHANGE - PUSH TO BEASTMODES / BEASTMODE SEARCH AND REPLACE
I think a good option would be that if a column name is changed in the Column select tile that if that old column is being used in beastmodes that we can push that change to all affected beastmodes. When managing 100's or thousands of beastmodes it makes it difficult to go back and correct if we have to change a column…
-
a beast mode that calculate revenues from diff sources
Hi Everyone, I have a data set that shows where our tickets are being created and revenue. And I created 2 beast modes that separate where our tickets are being generated - CASE WHEN Source= 'G360' THEN 0 ELSE 1 END and CASE WHEN Source= 'G360' AND (Board_Name='Field Services - MAC' or Board_Name='Field Services - Repair')…
-
Multi Line graph with different categories
Hello, Can anyone guide me on how to represent this data in a multi line graph with 4 different timezones. Without creating a new dataset.
-
NUMBER_FORMAT function
Please consider the implementation of a NUMBER_FORMAT function in Beast Mode in the same vein that we have DATE_FORMAT and TIME_FORMAT. This would take a number, and based on parameters, format the number (add thousand separator commas, percent sign, currency sign). Numerous discussions have been had in the forums about…
-
Beast Mode row highlight
Is it possible to highlight the entire row for a category in a pivot table in DOMO? In the above table I want the category 'c' and 'f' rows to be highlighted as they are the categories with the highest value in each type
-
Can we Pull Week of the Month?
Hi There, I need week number of the month, as in Domo I don't find any inbuilt function for this like WEEKOFYEAR. For Instance : Spend for week 31 (July 28 to August 3) is $100, I want two rows coming under each month and the week for july should be 5 and its spend of only july dates and for august Week should be 1 and has…
-
How can I avoid denominator should not get filtered while calculating the percentage in beast mode
Hi, I have a column name 'Order' with 1 to 6 values in it. I need to calculate the percentage of order 1 and show this percentage on a card in the dashboard. This percentage should change dynamically when the data gets refreshed. I am taking unique count of orders having 1 divide by total count of orders. when i am…
-
Multi Line Graph with Different Time Zones
Hello, I have a dataset here where there are 4 time zones, EST, CST, MST, PST and the fields are this CST Created Date, MST Created Date, PST Created Date, Created Date Last one is EST by default. Example format: 2019-03-11 10:22:17 So, I have extracted the hour using HOUR (`MST Created Date`) and for others as well. But I…
-
How to create YTD, LYTD, LYLW, etc columns from a FISCAL CALENDAR
I have a dataset that has sales per item going by each week (yyyyww) for the last three years, only I can't use things like YEAR(CURDATE()) or YEARWEEK(CURDATE()) because the yearweek we're getting from the dataset is based on a fiscal calendar (Ex: The first full week of august is the first week of the year, so July 29,…
-
Company Turnover %
I am trying to calculate the company turn over %. We are pulling data from Salesforce into Domo. We have a custom object that lists all employees. These employee have an active/inactive status and a termination date. I am trying to figure out a way to calculate the total ACTIVE by INACTIVE YTD based on that term date.…
-
Beast Mode
How do i do a beast mode formula to get the response value of a record that was completed most recently? If this is my data i want to just take the bottom row. My groupings cant be changed in magic etl just need to take response value with highest or most recent time Name Location Time Response value Ben A 2:07PM 5 John A…
-
Can I use the result of an aggregate beast mode as a filter for a dashboard/app page?
I have a beast mode that is comparing actual performance to a target (by categories) by taking the sum of actuals - sum of targets over an arbitrary date range, defined by user input into variables on the dashboard page. This works great as a quick filter control for an individual card, but when I make a filter card using…
-
How to Aggregate Daily Data into Weekly Totals in Domo?
I'm working with a dataset that contains daily level data, including a date column. I've created a calculated field based on this date column. However, when I try to aggregate the data by 'week' using 'graph by= week', I'm only able to see the values for each individual date rather than aggregated weekly totals. I've tried…
-
Dynamic Organization (Span) View
I am trying to find a way by which when a user view the Dashboard, then based on his/her PDP, s/he must see his/her own score and must see his/her Direct Reports entire span/ org score. I have attached a dummy data creating the scenario and along with it I have added Org Chart and the Views that is expected. Any help in…
-
Grouping beastmodes from different datasets in beastmode manager
Is there a way to group beastmodes from different datasets in the beastmode manager? In our instance, we have multiple datasets that serve different business purposes but have the same name and beastmode formula. If we can group them together as one in the beastmode manager, it would not only better organize the beastmode…
-
Dynamic Date Range Comparison Using Variables
Hi there, I recently saw this video on DOMO Variables from Zack Cameron and around the 17:30 mark he's using variables to control the Time Range (YYD,QTD,MTD,WTD) and Time Comparison Option (YoY, PoP). This functionality would be perfect for the dashboard I'm building out, but I'm having trouble recreating it. The code for…
-
Include Variable modifiers inside a filter card
I have my dashboard set up so that the filter options displayed are modified by the value of the variable. EX: notice how the filter by time options change depending on the time frame adjuster value in the screenshots. This is the best way I have found to do it, but my employers find it still extremely unintuitive. I think…
-
How to count occurrences across multiple columns
I want to count the number of times a value occurs in two different columns my dataset is set up in a way that an order will always have two IDs in the same row. The IDs can repeat in the same column or be in another column, but they will never be in the same row. In the example below, the number of occurrences for "1"…
-
How to use variables for time comparison?
Jace Mclean has shown in the video published on Domo youtube channel that it's possible to use variables as date selector combined with time comparison (PoP vs YoY). This is exactly a business case that I have in my project. My question - how this setup was created? What changes to the dataset/ETL were done? What beast…
-
Average time to response but how do I not include weekends?
I am making a dashboard summarizing some trends with Jira tickets and trying to create a metric card that shows the current average time to first response, I am using this formula (which I think I got off this forum): CONCAT( case when ROUND((((86400DATEDIFF([CHART] Date of First…
-
Beast Mode - Grouping
Hi! I am trying to fix this beast mode calculation to group properly. I need the time to group 12am-6am and then show 7am-7pm as separate lines and then group 8pm-11:59pm. The opened date column i am using is in this format '2023-10-22T07:18:17' which is why I am trying to use the beast mode, but the grouping doesn't seem…
-
When are Beast Modes calculated and when to place in an ETL or leave as Beast Mode?
I have read several varying degrees of opinions on when a Beast Mode is actually calculated. I thought a Beast Mode, attached to a card or assigned to a dataset, is calculated at the objects rendering, regardless of if the Beast Mode is actually being displayed on said card. So if I have 20 total Beast Modes, some only…
-
Beast Mode for "Views in the first 30 days"
Hi there, My team wants to create a beast mode that looks at total views in the first 30 days per asset since the video was published. For example, a video was published on March 1, 2024 and we want to know how many total views did it generate through March 30, 2024. We created a couple of sample beast modes that are…
-
Beast Mode Question
I have three column, first one is how many we gained this year, second one is how many we lost this year, and last column is total. I applied a filter, filter through this year the problem is I want total column go beyond this year, in another word, the filter won't affect it. Can I do this in beast mode, I try create a…
-
Beast mode question
Hi all, I have a beast mode calculation created which I'm trying to find out the monthly average of open tickets between 5 boards for the past 15 months and this is what I have- SUM(COUNT(TicketNbr)) OVER (PARTITION BY Board_Name ORDER BY last_update)/ DAYOFMONTH( last_update ) But I think the calculations are off. Is…
-
Budget to Actual - Multiple Dimensions & Different Datasets
I have a budget dataset with the following columns: _Account _Subsidiaries _Department _Doctor _Location (Not in Use) _Headcount Resources _Placeholder 4 _Year _Period _Scenario _Currency _Measure _value I have an actuals dataset with the following columns: Appointment Date Status Appointment Type Patient Account Number…
-
MTD and YTD TOGGLE
HI Team, I have a date field and what I'm trying to do is write a beastmode that looks at YTD and MTD without years. I have successfully done that in 2 separate beastmodes to give my a 'Y' or 'N' toggle. However when I try to combine them into one where the user can toggle 'YTD' or 'MTD' the 'MTD' isn't the issue.. it's my…
-
How to remove duplicate records from the drill down view
Hi Community We have 6 months data in which we have some duplicate emails available, however we have created a beast mode to show the unique count in the chart but when we go to the drill down we are getting all the records with duplicate records too. So is ther any way we can create a beast mode where in drill down we can…
-
Dynamic Top N Tooltip Beast Mode
Is there any way to create a tooltip that would allow me to display the the top 3 customers on hover for a given category? For the sake of this discussion, let's just pretend that I have a map of the USA, and I want to be able to hover over a state, and have the tooltip show the unique names of the top 3 customers for that…