-
Replacing nulls when adding across columns
I have a table which contains null values, and I want to get a dynamic (i.e. it responds to filters - therefore has to be done in beast mode, as I understand) total of values across three columns, keeping null values in the orignal columns but treating them as '0's for the purpose of the calculation. I have tried several…
-
Break Line based on character for use in Mail Merge
Greetings All, I am seeking advice on how to add a break line to a string based on a specific character. I was able to get the table to look semi correct using ETL + Beast Mode. REPLACE(`String`,';','<br>') But I am unable to use my mail merge doc because the data doesn't doesn't export to excel correctly. I am a bit…
-
Dashboard not displaying Zero Sum results
I've built a dashboard for a variety of Adwords and Bing Ad results, and everything is working smoothly besides when I filter specific timeframes and the summation is zero, wherein it doesn't display anything in the Single Value field. I've created the following piece of code to try to mediate the issue and it doesn't seem…
-
Adding year value to MM/DD date field.
I have a free text note field that we preface each note with a MM/DD format date. I am trying to add the year to this field so that Domo can chronologize this field and compare this free text date with things like system driven dates. I am currently using the following beast mode to extract the date from our text field,…
-
How can I calculate the percentage that a beast mode result is of a column set to 'count'?
Hi, this might be simple for some of you but i'm really struggling! Below is a table I have created. Columns 1 and 2 are using the 'count' functionality whilst column 3 is a beast mode that subtracts column 2 from column1. What I need to do is create a beast mode calculation that will indicate what percentage the…
-
Beast Mode - Parent of Parent type join
I have a data set of project items at multiple levels of a project hierarchy: project > task > sub task. I'm trying to build a sort of rollup card that shows the items based on parent link relationships. i.e.: * Project Parent = Self * Task Parent = Project * Sub Task Parent = Task I'd like to be able to have a column that…
-
How to only show the amount of monthly value only once instead of the sum over the whole period?
Hi, so I have a dataset that looks like this (fictive dataset): Employee Name Date Sales Monthly Quota Sally 11/3/2018 5,000 10,000 Andrew 11/3/2018 4,500 15,000 Michelle 11/4/2018 3,500 9,000 Sally 11/6/2018 1,000 10,000 Sally 11/7/2018 700 10,000 Andrew 11/8/2018 2,500 15,000 Andrew 11/9/2018 3,000 15,000 Sally 12/4/2018…
-
User defined functions for Beast Mode?
Is it possible to create user defined functions that can be called in Beast Mode? I'm creating Beast Modes for summaries in the top left of a visual, and it's getting ridiculous & unwieldy pretty quickly. In order for it to look reasonable, I need to format and abbreviate the numbers, similar to how it's described in this…
-
How to have a static number in beast mode
I have a table of categories with corresponding category path and visitors. Like the table below: IDCategory NameCategory PathVisitors% Seg123A AirlinesTravel and Tourism -> In-Market -> Airlines1000100/10000124B AirlinesTravel and Tourism -> In-Market -> Airlines15001500/10000125C AirlinesTravel and Tourism -> In-Market…
-
Same Day Closure %
Hello, I am working on a way to figure out what the same-day closure rate % is for customer support cases created within X time frame. As well as compare that to a previous time frame. Example: Feb 2017 = 73% Feb 2018 = 90% March 2017 = 85% March 2018 = 88% I would like to see if there is a visual way of doing this as well…
-
Ignore filter on a calculated field
Hello, I'm wondering if it's possible to create a BeastMode that ignores date filtering... I have a dataset that contains the following information ID# CUSTOMERNAME STATE FullDate Logins Errors % The card I'm building should only display the data from yesterday BUT, I want to add a field that calculates how many times the…
-
Beast mode for custom year
I would like to create a custom year starting August 15th and ending August 14th. We work with schools and the August 15th date is typically week and day 1 for the "School Year" Is there a way I can take the date a case was created and convert it to be the day/week of the School Year?
-
Beast Mode HTML Filter Value
I am trying to accomplish something that I feel should be very easy to do but can't figure out how to do it in Domo. What I am trying to do is add a link, field or button that has a more reader friendly name such as "View More" or "Drill Down Deeper" but the value / filter value is let's say for example, a date.…
-
Square Root Beast Mode
Is there a way to do a square root in beast mode? This leads to my bigger question about making a beast mode that calculates statistical confidence. I'm not very savvy when it comes to SQL statements, but I can usually manage to get what I need until I tried to recreate the formula contained on this page. If anyone can…
-
How to merge two rows in one?
Hello Everyone, I have 2 datasets using the email connector. These 2 datasets contain information from 2 different platforms (Adform and Adwords), by means of a DataFlow I made a data unification of these two so that they remain in a single data base that I call "Merge Dataset". Now up here, I create some cards with the…
-
Beast Mode Calculation for cutting off the last months
Hi all, I have a question on how to create basically a Beast mode tyle filter that will cut off the last 3 months. my datecolumn is in the MM/DD/YYYY format (4/26/2018). So I would like to take the most recently closed month (end of March) and subtract it by 3 months to only report data up to 12/31/2017. Thanks for your…
-
Gauge card bufferzone between pass/fail
For a filled gauge card, let's say i want to put a goal of 50 on a gauge. Is there a way to have a small buffer zone of color that isnt pass/fail? For example, "goal = 50, but 48 to 50 is yellow not red" Similar to a radial gauge where you set limits to numbers high/low but it is a percentage based. I am looking for a…
-
Beast Mode update
It seems like in the new Beast Mode you can't look through a list of previously written calculations on the data source. When you open Beast Mode via the 'add a calculated field' button you can only see a blank template for what you want to work on. It also seems like a Beast Mode calculation isn't available outside of the…
-
New User: Calculated Field Sum Error; Cannot find resolution documentation
This is an elementary function, and I appear to be doing it correctly, yet I cannot get the correct outcome. I am using beast mode to add a calculated field, which combines the value of 2 raw data fields. However, the calculated field, no matter what I do, always returns blank values instead of a calculated value. What am…
-
Multiple Values Across Columns Compared Over Last Year
Hi everyone, I have two columns of data with similar values, e.g., Duck, Goose, Horse, etc. I am agnostic to which column it is in, I would like to know the net change over the previous year (preferably in a heat map table). Here is an example of what the data may look like:…
-
Beast Mode Case Statement Help
For some reason this CASE statement will not validate. I have all the required parts. `PayTotal` and `PayTargetWeek` are both number values and I want this field to return a character string. case when (sum(`PayTotal`) / `PayTargetWeek`) <= -.05 then 'Under Target' when (sum(`PayTotal`) / `PayTargetWeek`) >= -.049 and <=…
-
How to calculate the number of minutes in a month?
Does anyone know how to calculate the number of minutes in a month? I need to calculate the number of minutes per month to deduct from them idle time also in minutes and get the percentage of accessibility of the environment. Regards, Rodion
-
Which data column format is better?
Hey, I'm generating report from one of our platform and have a possiblity to have report in two formats. Let's assume that A-category , B-subcategory, X-random value. First type: A1X1 B11X11 B12X12A2X2 B21X21 B22X22 So in this case X1 is sum of X11 and X12. with DOMO limitation of summing total rows this might be useful...…
-
Does anyone have the Beast Mode with HTML code to include an up or down arrow into a card?
I am sure I saw a beastmode with some HTML code earlier this week on Dojo which reflected an up green arrow or down red arrow based on another columns output. I just can't find this HTML beastmode on the forum anymore. Does anyone have it to share? Thanks.
-
Calculating and Grouping Generations / Age Stratification in Domo
Hi all - I figured since I got Domo Support's help on calculating generations / age stratigification I would share the beast mode calculation for anyone else that would find this useful and not have to reinvent the wheel. CASE WHEN `dateOfBirth` >= '1946-01-01' AND `dateOfBirth` <= '1964-12-31' THEN 'Baby Boomer' WHEN…