-
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…
-
Funnel Card using Column Aggregates?
Hi, as the title sugests, I am having trouble creating a beast mode that I can use to funnel the totals of several different columns.What I would like to do is create a funnel for marketing emails, columns are 'email delivered', 'email opened', 'email clicked', and 'email bounced'. Each row in the dataset is an email…
-
Changing Date format to YYYY/MM to exclude days as uploading Monthly data
Hi there, I was wondering if someone could help me with a date format issue. The data is being uploaded as YYYY/MM and it turns it into the format of YYYY/MM/DD but the DD is always 01 since we only uploaded Monthly data and do not have it broken out by day. This does not allow me to use the 'All Time' filter which is…
-
App Store Time Zone - FYI!
I ran into an issue using the Twitter Quickstart. Wanted to share as I bet others need this fix. The Quickstart comes with a card called Best Times to Tweet. The X axis is market (UTC), and the Beast Mode that comes out of the box called "Hours of Day (UTC)" takes the field 'Created By' and formats it into h:mm -- which…
-
New Card Builder and Beast Mode
It is great to see them finally here! Bravo
-
Disappearing Beast modes
Hello Everyone, There appears to be some confusion on this subject. I want to make sure the issue is clearly explained. In addition to what causes this to happen. What The Issue Is: You have created a beast mode (or multiple) on a card. Saved that beast mode(s) and all looks great. Later, when you come back to the same…
-
Case Statement Using Beast Mode Calculations
I need to create a card with one out of two solutions: * one chart that allows me to stack other beast mode calucations on top of one another, resembling a table; or * two very elaborate CASE statements that group together a dimension and measure of 17 categories. The former does not seem to exist, so it seems I'll have to…
-
Common Beast Mode & ETL Questions
Once you are logged into the Help Center, you can move seamlessly between Domo University Training, Knowledge Base, Community and Support (using the head navigation menu) . Knowledge Base articles are a great resource to answer many general questions. KB articles answering the most common Beast Mode/ETL questions: * Beast…