-
Period-Over-Period % Change in Multi-Value / Single Value Gauge
Hi all, Still new to DOMO (4~ months) so just learning the ropes. Please point me in the right direction if this is posted incorrectly or if im possibly not understanding something! I'm trying to accomplish a simple Period-over-Period % Change calculation and it looks like this is an ongoing question/problem and I…
-
Dynamic date range (last two quarters)
HI All, I am looking to create a dynamic date filter on my card. The objective is to get last two financial year quarters data. I am aware that there is an option in DOMO to get last two quarters data but this gives me incorrect results i.e if we are in May then this gives me nov - april data but what I need is oct 1st -…
-
Dynamic date range (last two quarters)
HI All, I am looking to create a dynamic date filter on my card. The objective is to get last two financial year quarters data. I am aware that there is an option in DOMO to get last two quarters data but this gives me incorrect results i.e if we are in May then this gives me nov - april data but what I need is oct 1st -…
-
relating beastmode IDs between datasets
relating beastmode IDs between datasets Hello! I am having trouble relating beast mode ID between two datasets: the user logs and a Beast mode dataset available via the Domo governance dataset connector (https://domohelp.domo.com/hc/en-us/articles/360056318074-Domo-Governance-Datasets-Connector). In the "beast modes with…
-
How To show sum after nested calculation using beast mode
Hi I have a dataset where values are like below: SessionId ActivityType ActivityTimeStamp Company 1001 Play 2022-04-18T04:28:12 ABC 1001 Play 2022-04-18T04:28:13 ABC 1001 Read 2022-04-18T04:28:14 ABC 1002 Play 2022-04-18T04:30:10 ABC 1002 Play 2022-04-18T04:30:15 ABC 1003 Play 2022-04-18T04:40:15 XYZ 1003 Play…
-
Allow Graph By in window functions
I'm trying to create a dynamic Beast Mode that uses a window function to select the first value of a column (based on date) that is part of a function that sums other columns. In excel parlance I want to be able to vlookup start_date and grab the value for the associated column, then add that to a sum of another column…
-
FIXED Function - Static Filters
FILTER ALLOW/DENY is the most useful piece of FIXED for me. What would juice up its usefulness to the next level is an ability to use static filters in the function. For example - SUM(SUM(`totalSales`) FIXED (FILTER `Client`='ABC Company')) Beyond simply allowing or denying field filters to affect the calculation, you…
-
Duplicate Beast Mode Warning
It'd be cool if when making a beast mode Domo could warn you that a similar/exact beast mode already exists. If I'm doing a new one that's Count(Distinct SalesOrders) it could suggest that a duplicate beast mode already exists. Or possibly a Beast Mode manager feature.
-
Beast Mode Manager Switch to New Beast Mode
It would be helpful if we were able to switch all cards and reports that use a beast mode to a new beast mode. There are several instances where a beast mode was not saved to the dataset but rather to a card and then it was saved as numerous times so when we go to the beast mode manager we have "Days Late to RD" 15 -20 on…
-
More traceability with variables
Knowing that this was just launched and probably has a lot more coming, I think it is key to increase traceability of variables. Let me elaborate: once you set a variable, you need to create a BeastMode Calculated field to actionize this variable through a CASE WHEN. However, this first CASE WHEN is then used as input in…