-
Aggregate (SUM) the results of Lead Function Beast mode at Card Level
I have a dataset wherein I have to count the number of cases which falls in the below filter and conditions. CASE -- Check if the current row is 'Ringing' and lasted 11 seconds or less WHEN STATE = 'Ringing' AND TIME_TO_SEC(AGENT STATE TIME) <= 11 AND LEAD(STATE) OVER (PARTITION BY AGENT NAME ORDER BY DATE, AGENT NAME) =…
-
BeastMode code to take one value from each category
This question is going to be really difficult to describe, but I will try anyway. I am trying to get a unit count for each facility, the problem is that bc we filter by time and different facilities can gain units over time, I can not just have one row per facility, I have a row for each month. That being said I need it to…
-
forcing x-axis in bar chart to ignore filters
Hi all I have 30-40,000 rows of data presented to a bar chart with 5 dashboard filters operating across the data. There are 15 different categories presented as the x-axis. Occassionaly filtering removes one of these categories. I'm trying to find a way to leave the category on the x-axis despite the fact that it is no…
-
Possible to use a value that ignores filters?
I'm looking for a way to use a value in a beast mode formula that ignores my current filters. I've been wrapping my head around this problem and can't think of another way to solve it. Here is an example with my issue: Let's say my company has 5000 employees. There is a survey database with multiple rows of data for each…
-
Beastmode to return current month value? And what's the best card type to show the variance?
My dataset has these columns: year (int), month (int), target, actual I created a BeastMode to return the current month (Aug) value for both target & actual, but instead of showing an actual value for Aug, it shows 0. CASE WHEN month = MONTH(CURRENT_DATE()) THEN target ELSE '0' END Since I want to see the variance for…
-
Charting rolling n weeks based on week number selected in the dashboard filter
Hello, I have a weekly dataset with 'week number' as dashboard filter. I would like to create a chart showing rolling 8 weeks trend leading up to the week selected in the filter. For instance, if the user selects week 18, the chart should display weekly trend from Week 10 to week 18. How can I achieve this? Thank you!
-
Beast Mode Calculation used to view data in Table
My question is related to showing Comments/ Verbatim in a Table using a Beast Mode to Apply Business Rule. In Org Survey, we want to make sure that if we have less than 5 unique comments then don't show the comments. If the Business Rule of >= 5 comment is met, only then show the comments/verbatim. Below is an example…
-
Pivot tables
I dunno why, but some of the time I cannot wrap my head around pivot tables. Here is what I want to do and here is how my data is structured and the column headers…. Account | A Prime_TV Revenue | B Prime_TV Revenue | A Premium_TV Revenue | B Premium_TV Revenue Pivot table I want… TV Category | Company A. | Company B…
-
Calculating percentage in beast mode based on count
Hi, I have a dataset that looks like this: Network Hour Date Avails A 1 1/1 2 A 2 1/2 4 B 1 1/1 6 B 2 1/2 8 C 1 1/1 10 C 2 1/2 12 C 2 1/2 12 The number of avails is the same for every row that has the same network, hour, and date. I need to write a beast mode that calculates the number of different rows that have the same…
-
Miscellaneous Q&A from Domopalooza
The product team enjoyed answering questions from the audience during the final session at Domopalooza. Below you will find the answers to all questions related to Sandbox, Beast Modes, Consumption, Learn Domo and more (including those that weren't mentioned on stage). Q: Are all the new updates available to those NOT on…
-
Additional Functionality when charting by Week
When charting by week it would be nice to have the following additional options: Ability to choose the method that determines 'Week 1'. For example, is it the first Monday of the year? The first Tuesday of the Year? The Tuesday that includes the 1st day of the year? Is it simply whichever date is the 1st day of the year?…
-
Filter out happy people
So, that's a strange title… Here's the deal: We have survey data about support tickets. It's pretty basic— just Good, Neutral, and Bad as responses. A person can be interviewed more than once. So, I've been creating a visual of "Sentiment by user". It's a stacked bar graph with the following: X axis: The user's name Y…
-
Please help me
I am using the below calculation to find the employee who is having 3 or more than 3 PR. once I have this data then I want to total the count COUNT(CASE WHEN Attendance Check = 'Present 3 or More Days' THEN 1 ELSE 0 END) on the above calculation, i tried with the SUM function as well but it is still same. It is passing the…
-
Beast mode 'Case when' for if a date exists
Hello! I am trying to write a beast mode that counts a row of data if a date is present. The first row of my beast mode is working, but I am having issues with the second row. Basically, if a move-in date is present (or is not null), I want to count that row in this calculation. I am new to writing beast modes so I am not…
-
Sub-Category of a Category?
Hi All, We are working on a report that has a few different program_namesthat are summed up in a pie chart using orig_loan_amount. I have been tasked with trying to sub categorize our bonds using a taxable/tax-exempt designation The problem I am trying to overcome is that our bonds (identified by pool_name) are actually…
-
Combining Multiple columns into one column using beastmode
I am making a table card that uses multiple different rows. The way I am doing it is creating a variable named 'unit type' that when set to specific values returns a specific column. It then sets all the rows for which that column is blank to null and finally I filter out any null values. bellow is the beastmode I used,…
-
Trying to show Churn (%) as a percentage and Churn (#) as a regular number
Basically What the title says, I'm trying to figure out what I need to add to my beast mode to be able to switch between the unit type on the axis. I want to display Churn (%) as a percentage (without multiplying by 100) and show Churn (#) as a number. Attached is the beast mode that I have so far
-
Writing a Beast mode for a table card that selects a column and only displays rows with values
Hello, I am trying to write a beastmode for a table card where it picks a specific column based on a variable then only displays the rows in which that column has values. I know how to make a variable to select columns, but I can not get it to leave out the rows in which that column is blank. The first three images are…
-
Period over Period Beast Mode
I have the following Beast Mode working for a comparison table (Period over Period is the name of the variable: CASE WHEN Period Over Period = 'Week over Week' THEN (CASE WHEN WEEK(Date) = WEEK(CURDATE() - INTERVAL 1 WEEK) AND YEAR(Date) = YEAR(CURDATE() - INTERVAL 1 WEEK) AND DAYOFWEEK(Date) <= DAYOFWEEK(CURDATE()) THEN…
-
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.…