-
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…
-
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…
-
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…
-
Is there a way to do this in Magic ETL?
I've got the following CASE statement in a beast mode now, wondering if there is a way I can do in Magic ETL so I can then use in card filters. CASE WHEN SUM(`Order Quantity`) > SUM(`Quantity Available`) THEN SUM(`Value Available`) ELSE SUM(`Order Value at 02 Slow Item Cost`) END Thanks in advance for your help!
-
Beast Mode Help - Special Rounding Case (round at up at .25)
Here is a video that gives an overview of what I am trying to do with a beast mode. https://youtu.be/g5j9gNDqtRw
-
Round to 4 decimal places
Via beast mode or magic ETL I need to round to 4 decimal places so I can group prices charged to customers. Building reporting to identify which is the most frequently charged value. Need to group the pricing events so they match to 4 decimal places. I see the ROUND( function, but that appears to round to nearest whole…
-
How many orders that contain just 1 line item? (1 Item Order Count)
Looking for some help on a beast mode. Here is a short video I put together so you can see what I'm trying to accomplish. In my dataset I have line item detail on orders we enter daily. We currently have beast modes for the number of orders, the number of lines, and the average lines per order. I need to create a new beast…
-
Sharing what solved my issue - video included
I've been working through an issue with how best to build a dataset in Domo. I needed to move away from Data Fusion as an approach to allow for PDP. I tried using MySQL but that didn't provide a short enough run time to meet our needs. I was also looking into other software tools to do the ETL work outside of Domo, but…
-
Magic ETL Help - Overwrite value in a column if another column equals one of two values
In our sales system there was a recent change to a part number, and I need to correct history in the dataset. If the 2nd Item Number is either "LOT SQD STOCK" or "LOT SQD SPECIAL" then I want to overwrite the value in the Supplier ID column to be "SQD" otherwise I want the Supplier ID column keep it's current value. I'd…
-
PDP Question
We are working on expanding our Domo users to include our outside account managers. In doing this, our leadership wants those guys to each only see their individual information. In other words, if John Doe logs in, he will only see information for the customers he is named as the account manager. My first thought was that…