-
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…
-
Allow Beast mode formulas via Webform to be Accepted
Id would be great if domo beast mode was able to accept formulas that were written in a webform. example below this does not work but this does
-
Show value on row option
Please add an option to show value on row for pivot tables. I've seen a couple other posts about this but I'm not sure if this will become a feature. I don't think construction yet another dataset is the right way to deal with this. It is standard functionality in Excel and PowerBI.
-
Beast Mode returning greater than 100% for Performance KPI
To keep it as short as possible, I have an On-Time delivery KPI. However, I have to measure on-time/late from two different columns depending on the type of delivery it was. I'm using this beast mode formula to capture those criteria, and then just simply divide it by the total number of deliveries: (sum(case when…