Community Forums

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

Recent Discussions

Dynamic CAGR formula?
I know how to do a basic CAGR formula between two static years: power((sum(CASE WHEN Fiscal Year = 2024 THEN Amount else 0 end) / sum(case when Fiscal Year = 2020 then Amount end)), 1 / 4) -1 Is there a way to construct a CAGR calculation that responds to user filtering or changing the timeframe? I am trying to think of a…
Any Function to decode UTF-8 characters available in Domo?
Hi, I have a URL field in my dataset where the data in certain rows have UTF-8 characters instead of normal html characters… For example…. https://www.theverge.com/2024/11/26/24306815/google-gemini-spotify-extension-rollout-android is showing up as…
YTD BeastMode with Variables
I have 2 variables 'Year Selector' and 'Month Selector' that are being used as filters drop down selection in an App But also used within a YTD BeastMode: SUM(CASE WHEN Year Selector = Fiscal Year AND Month Number >= 2 AND Month Number <= CASE WHEN Month Selector = 'January' THEN 1 WHEN Month Selector = 'February' THEN 2…
Issue in total/subtotal of the pivot
SEC_TO_TIME(SUM((End Time - Start Time)) - 3600) I am using the above calculation to get the employees who has exceeded their break by 1 hour. it is working fine in normal condition but when i put this into pivot and checking the subtotal / total, it is just subtracting 1 hour from the total which is wrong. it should just…
Reset Running Total In Beast Mode
Hi, I am trying to reset the running count every time the week ending date changes. Any idea on how to do that in a beast mode as the basic setting just continues to accumulate.
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=…

Welcome!

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