-
BeastMode Help: Days Remaining in Quarter
I've got a beastmode I am trying to create that will calculate the days remaining in a quarter. * If the quarter is already over I want to show a value of 0 (not a negative number). * If the quarter hasn't started I want to show 91 (that's the number of days in a quarter) Any help would be appreciated. Also if this is…
-
Magic ETL - Lower Case to Upper Case Join
I've got some extral data coming in via FTP that contains a key field that sometimes has lower case charcters. Attemping a join in Magic ETL and some appear to be failing based on case difference (lower case in one and upper case in the other). How best to fix? * Is there a way to format a field as UPPER CASE in Magic ETL?…
-
BeastMode: Field contains lower case
Working on a exception report where item descriptions in our item file contain a lower case character. Logic would work like this: case when `Description` LIKE '%[lower_case]%' then 'Yes' else 'No' end Thanks!
-
Page Filters - Enhancement Idea - Save Page Filters As
Here is a short video overview of the idea I have here. One of the most frequent questions I get from users in my instance of Domo is, "is there a way I can save multiple versions of page filters and use them later?"
-
Case Statement Question - multiple results
I'm trying to use a quick filter to select sales people associated with specific branches. There is some overlap in assignment, in other words two branches are assigned to two different people. Here is my current case statement: case when `Customer Home Branch` IN ('207500','208500') then 'Brad' when `Customer Home Branch`…
-
Best Practice - Deep Linking - Excel Tool to Help you build deep links
First, I want to thank @ST_-Superman-_ for helping me on this topic. Outstanding detail provided! THANKS! If you're like me, not a techy, but would like to create page or card deep link beast modes maybe the attached Excel tool will help. Please let me know if you have questions. There is a link to a video included in the…
-
Best Practice: Outlier Detection Using Magic ETL
Sharing an approach we implemented in our instance of Domo to identify outliers (unusual or exceptional values) for our accounting team. Magic ETL provided a really easy way to detect outliers, and shifted a manual process (searching for needles in a haystack) to true exception processing. Check out the video below to…
-
Field Formating - Enhancement Idea - Set Default at the Dataset
This is something I have seen discussed here before, but wanted to bring up again as I think this capability has the potential to impact everyone building cards (save time). Here is a short video to describe:
-
Best Practice: Alternate use case for new Flex Table card type
Flex Tables were announced at dp19 and - what an AWESOME new card type! Playing around with it yesterday I found a alternate way to use the card. Check out the video below to see what I came up with. Includes a couple of ideas on how to enhance the card options as well. @DaniBoy
-
Best Practice: Filtering Favorites page (Participant Users)
In the January 2019 feature release notes Favorites page filtering was added. This was not available for Participant users. They could open the page filter pane, but could not add filters. Since coming back from Domopalooza I have been showing some of my users new features including the new "Interaction Filters" and Filter…
-
Beast Mode Help: Calculating Hit Rate (Projects & Quotes)
Here is a short video overview of what I am trying to accomplish: https://youtu.be/Dz_uXS1OGco In simple terms the Project Hit Rate is the Count of (distinct) "Project Name" where "Convereted to Order?"='Yes' divided by the total Count of (distinct) "Project Name". In simple terms the Quote Hit Rate is the Count of…
-
Best Practice: Who is using this page? - Track user engagement with specific content.
I recently had our COO ask if results were changing yet for some specific KPIs after they had visited some branch locations. We couldn't yet see change in the data, but the discussion led to who was using the page/cards we had in place. If the users had not taken the first step in engaging with the data through the Domo…
-
App Store: What's New Section & Sort by Release Date
Would love to see enhancements to the app store that would allow us to find the newest items. Including a "What's New?" section and ability to sort app store contents by release date.
-
SQL Training Resources - Oracle Database (JD Edwards)
I'm fairly new to Domo, and am in the middle of implementation. I am connecting to JD Edwards - Oracle via Workbench and need to gain some more SQL knowledge so I don't have to rely so much on our DBA (busy with other projects). Any suggestions for online courses, classroom, or good books on this topic would be greatly…
-
Delete rows of data (based on criteria) from data set stored in Domo cloud
I have a data set that appends about 1M rows daily up to a data set stored in Domo - has been in use for about 3 months. The data set is approach 100M rows, and we no longer need the majority of the data. This table contains daily inventory levels for all items, our management determined they only really need items with a…
-
Beast Mode Help: Summary number to show % of transaction type
I have a dataset where there is a column name 'Ship Via Group' that contains three distinct values. One of which, "Counter / WC" I need to show in the summary number for the card - "What percentage of orders are Counter / WC?" Sample data is attached, note that order number may appear multiple times because orders may have…
-
Summary Number - Display % for a member in pie chart
This may be more of a beast mode question... but here goes. I have a pie chart that shows business in either "Warehouse" or "DIrect" business. I'd like to have the summary number for this card show the % the "Direct" business makes up of the total business. For example, if the card shows Direct at 60% and Warehouse at 40%…
-
Beastmode Help: Determine if order is <= $50,000
I've got a dataset that contains order data at the line item level. An order could have 1, or many items. I need to create a flag column that indicates if the total order value is <= 50,000. Would like to do this with a Beastmode if possible. The unique identifier in this case is the order number, and the extended price is…
-
Is it possible to calculate Mode in a Beast Mode?
I've got a histogram card that is showing unit costs for items, and I want to display the most commonly applied cost (Mode) in the summary number. How would this be accomplised in a beast mode? Definition: Mode is the value that occurs most frequently in a given set of data. by the way... try searching for "Mode" in the…
