Community Forums

Discover best practices and find answers to your questions with advice from fellow Domo users.

Recent Discussions

Beast Mode Function Parity in Views
There are a whole host of useful string and number based functions that exist in Magic ETL that do not exist in views. For example, I would like to use STR_DIGITS() in a calculated column to remove all letters from a string. This exists in Magic ETL but not in views. This seems like an oversight.
Is it possible to make beast mode follow the colour rules on a different column?
I have a bar chart that has colour rules set up based on dataset column values. Now I need to use beast mode for the series, instead of using original dataset columns, because the beast mode allows us to convert the column value to different languages. In this case, the bar chart failed to follow the existing colour rules,…
Creating a Beastmode/ Dimension
I have a set of data that includes columns like " Facebook Engagements, Facebook Impressions, Twitter Engagements, Twitter Post Impressions, TikTok engagements, TikTok Impressions" how do I create a dimension or beastmode where you will be able to filter by platform, e.g.: Facebook, Twitter, TikTok.
Dynamic aggregation based on user selected date grain
I have a dataset that appends daily to build out a historical view. I want to be able to always show the latest record per date grain based upon the user selected date range and grain. For example, if a user selected YTD by month, then I would want to show the following values from the last day of each month SUM(values)…
Using FIXED () and Variable?
I'd like to create a BeastMode 'MTD %' that can: Calculate the % of each GL account based of Total Sales Can be dynamically filtered by Month and Year variables Here's my MTD % Beast Mode: SUM(`Amount`)/ (SUM(CASE WHEN `Class 3` = 'Sales' THEN `Amount` ELSE 0 END) FIXED ()) And my MTD Beast Mode: SUM(CASE WHEN Fiscal Year=…
Keep data in column as constant regardless of date
I have an ETL that includes a weekly upload of new information (employee name, quota, current sales) that is batched on Mondays. The quota is typically the same from week to week. When I use the information in a dashboard looking at last week, it doesn't recognize the quota since it's from the current week. Is there an ETL…
Income Statement % Column
Is it possible to create a Beastmode (or Magic ETLs) to show a column like % of Net Sales?
Bucketing different text fields if there is a match
I'm trying to count different text fields from a column called Reason and there are different reasons in that column. One row might have single or multiple reasons separated by a comma. Below are examples. 1) Reason 1 2) Reason 1, Reason 2, Reason 3 3) Reason 3, Reason 2 Beast mode using currently: CASE WHEN Reason LIKE…
MTD, MTD Last Year Beastmodes do not work properly with Date filter
I created 2 Beastmodes that I can drag into the 'Values' in the Pivot Table card: MTD = SUM(CASE WHEN Month = MONTH(CURRENT_DATE()) AND Year = YEAR(CURRENT_DATE()) THEN IFNULL(Amount * -1, 0) ELSE 0 END) MTD Last Year = SUM(CASE WHEN Month = MONTH(CURRENT_DATE()) AND Year = YEAR(CURRENT_DATE()) - 1 THEN IFNULL(Amount * -1,…
formatting in a table
I have a table like this: Category | Actual | Budget Revenue | 4.50 | 5.50 Sales | 4,250.00 | 5,550.00 For this table, I have in a pivot table, and I want the revenue to be formatted with the ($), and the sales, I want to not have decimals. How can I do this in a beast mode? If I format this for the column on the card it…

Welcome!

It looks like you're new here. Members get access to exclusive content, events and more. Sign in or register to get started.