-
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…
-
Magic ETL - Using Group by - run time impact question
Wondering what is the best practice to reduce overall run time of a ETL dataflow... I've got 5 input datasets totalling about 14M rows of data that are ultimately appended together in the final result. Is it better to use group by in the magic ETL for each dataset (5 steps) or one consolidated step after the appends? Also,…
-
Magic ETL - Add a "Flag" column based on comparing a date in one column to current date
In my data I have a date column. I'd like to create a column via Magic ETL (want to use in a filter) that looks at the date a determines if it is in the past or in the future. Here is a short video that explains. From an Excel formula standpoint, it would be: =IF([@[Last Update]]>TODAY(),"Future","Past") I tried with value…
-
APPROXIMATE COUNT (DISTINCT) or COUNT (DISTINCT)
Can anyone explain the difference in these two functions? Why use one vs' the other?
-
Beast Mode: Percentage of Total Inventory - comparative gauge
I'm trying to build a comparative gauge to display the percentage of total inventory. * Attached is sample data * Here is a video I put together to explain Where this is tricky is keeping the total inventory value for the calculation. Can you help?
-
Need some help: Two Beast Modes
I've got two Beast Mode calculations related to supplier receiving measures I am having trouble with. Hoping you can help me transfer my Excel knowledge in the example here over to Beast Mode. * Attached is a workbook with sample data, example of the finished report, and explainations of the calculations. * Here is a video…
-
Beast Mode Help: Two layers of division
I've got a calculation I am trying to perform with a beast mode formula, that I can't get to work. The calculation is (Number of Lines / Hours Active) / Standard I'm trying to protect against divide by zero in the two layers of the formula. The first item in the order of operation is the (Number of Lines / Hours Active),…
-
NCAA Football Data source
Anyone know of a FREE data source for NCAA football?
-
New Dynamically Based Range Scale Markers - outlier fill?
I'm reviewing the Sept Release Notes, and can't figure out how to do outlier fill with the new dynamically based range scale markers. In the Adding Scale Markers to Your Chart knowledge base document, the card example given in the intro shows fill color for the "normal" range of data as green, and the red for fill area of…
-
Poll Cards - any way to get the number of responses?
Poll cards display the % of responses for particular items based on what the users select. I would like to know how many responses there are for each poll card. 80% out of 4 responses has much less impact than 80% on 400 respones.
-
Control Charts - Mean, Upper Control Limit (UCL), and Lower Control Limit (LCL)
I posted a requested in the Idea Exchange for a new chart type, Statistical Process Control Charts (link below). I wanted to ask the Dojo if anyone has done something like this already? What I really need to be able to include in a line chart are the Mean, UCL and LCL values. Plotting the actual results with those lines…
-
Want card to "ignore" a particular page filter
I have a card (see below) that when a user filters the page by `Year` I don't want it to filter. In other words, I always want it to show all of the `Year` values - ignore that page filter. Ideas on how to best accomplish?
