-
MS Office PowerPoint Variable Integration
Hey Community, We are looking to get some better integration with variables in the office plugins. Specifically, we are looking at the Powerpoint plugin, and we want to be able to bring in cards and dashboards that have Beast Modes utilizing Variables in the calculations. Perhaps something like you do for Filters, the…
-
Variance % formula not working correctly at Grand Total
What I am trying to do is look at Monthly Headcount Trend (Variance %) by Billable, Non-Billable and Total. My approach to identify change % is : (Current Month - Previous Month) / Previous Month. Since, it will be showing multiple months data in a tabular form, so I used the following formula for Variance % (SUM( CASE…
-
Beast Mode to Categorize the data based upon the pattern
Hello, Can anyone help me in writing this beast mode. Where I'm aiming to categorize these based on the status reversals from Yes to No. Case when current ready status is No and previous status is Yes then considered as reversal. Example like below: I already have first 3 columns in my data. Tried this beast mode but not…
-
Smart Text as a Variable
At the card level it would be beneficial to know what the current operating environment is for a card and leverage that information in a beast mode. For example, if there were a "system variable" that stored what the current "Graph By" selection is, like what is already available in Smart Text, then you could have a beast…
-
How can I create a beastmode that will return the desired substring in a field?
Hi all, I've given this multiple attempts and just can't seem to get it. I have a field called 'Destination' that I want to use in a Beastmode that will return the first substring of "B-FGI" or "FGI" in a value such as "Doe, John A-B-FGI-20.15.0003.B-FGI" or "Doe, John A-FGI-20.15.0003.B-FGI". I also want to create another…
-
I have a chart which is populated yoy basis and has Q4 data being shown twice
Hi, I have a chart which is powered using a beast mode with a variable as following: (CASE WHEN (`Content Type ES Quarterly-2` = 'Project or Image') THEN AVG(`proj_image_insert_user_count`) WHEN (`Content Type ES Quarterly-2` = 'Project') THEN AVG(`customize_makeit_hva_user_count`) WHEN (`Content Type ES Quarterly-2` =…
-
Number of business days in the month
I am trying to write a beast mode that given a date can tell me the number of business days there are in that month. My company's hours are a little different so I want it to count days according to these rules: Sun: 0, Mon: 0.5, Tues-Fri: 1, Sat: 0.5 I can't seem to figure out how to loop through to do this calculation so…
-
Can someone help me with this Beast Mode using CASE Statement using FIXED(BY) Formula?
I am trying to create a beast mode that looks at different criteria to only sum certain data. I have tried multiple ways to write this, but I cannot get it to work the way I want it to. If I write it this way, the formula works however it only displays the data from the else portion and ignores the other criteria. CASE…
-
How to compare to the entire dataset, and not just the filtered part of the card?
Hi, so I have a beast mode calculation in one of my datasets that looks like this: CASE WHEN SUM(SUM(1)) OVER (PARTITION BY TRACK: Title,LIBRARY: Name,TRACK: Version) > 1 and TRACK: Version = 'Full Mix' THEN 'YES' WHEN TRACK: Version <> 'Full Mix' THEN null else 'NO' end The purpose is to make sure that there aren't…
-
One SKU has multiple mail date and trying to filter out all skus that have date greater than today
Hi, I am running into a problem with my visual I want to filter out any SKUs with a future mail date but since each SKU has multiple mail dates it is not recognizing the future ones it is going off the first mail date it sees. For example, the calculated field I have created is this "CASE WHEN MailDate > CURRENT_DATE()…
-
Is it possible to fill in missing dates at the card level | Fill Missing Dates button isn't working
I read the article linked above… Is there a way to do this sort of thing at the card level? The Fill Missing Dates option is not working. I'm having an issue with it dropping dates that have no corresponding values on almost all of my bar charts. My dates are all weekly and there's weeks with no data on every card. I don't…
-
Percent of total in grand total row
How can I have the percent of total for the grand total rather than the sum of the WoW column? e.g. (mktg visits - lw sessions) / lw sessions in to the total row
-
Beast Modes Affecting Card Performance
Hello, I'm curious if anyone else has noticed degraded performance making and editing cards due to the amount of beast modes on the dataset/card? We are trying to isolate this issue with some of our datasets, and try moving calculated field logic down to the ETL to come through as a column. Has anyone else experienced or…
-
Is there a way to aggregate the output using a FIXED function used in a CASE statement?
I'm a MajorDomo in a large retailer, and I'm working to rewrite our TY/LY Beast Modes to calculate off of a "Week Number in Epoch" column, rather than comparing against Fiscal Week as we move into a Week 53. I previously asked about writing a temp table in a Beast Mode (https://dojo.domo.com/main/discussion/comment/59532),…
-
How to create a beast mode for 1st initial of first name and add the last name
Hi everyone, I'm having issues trying to get a beast mode to work when trying to get the 1st letter of the first name and adding it to the last name. This is what I have - SUBSTRING('Ticket_Owner_First_Name',1) + 'Ticket_Owner_Last_Name' I've tried different variations of this but can't seem to get it correct. Any…
-
Calculating Time difference in Seconds Beast Mode
Hello, Is there any way to do the difference between 2 timestamps in seconds using a lead function in beast mode. For example in below table take the first 2 rows 9:51:47 seconds subtracting with first row that is 9:51:14 seconds and output should be 33 seconds. The column is in String datatype. Can I achieve this using…
-
Beast Mode Description
Similar to how you can describe individual columns in a dataset (via the dataset schema view), a useful new feature could be the ability to describe beast modes. Currently, our practice has been to add a comment inside of the beast mode expression explaining what it's used for, but this comment cannot be referenced in…
-
Calculating period over period change in Domo
I've been trying to find a solution for easily calculating percent change of metrics between two periods and put them in a table. Like "What is the percent change for "costs" between this month, and last month?" Normally this is easy to calculate outside of Domo using the standard formula: (V2 - V1) / V1) *100 However,…
-
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…