-
Calculating individual value as a % of a column
Count Total Weight % of Weight 12x2pk 2,525,985 23.65% 12x4pk 169,092 1.58% 14ct 630 0.01% 16ct 8,505 0.08% 20ct 175,140 1.64% 22ct 239,400 2.24% 25ct 143,325 1.34% 28ct 395,640 3.70% 30ct 310,275 2.90% 32ct 1,196,370 11.20% 35ct 2,997,225 28.06% 39ct 787,185 7.37% 45ct 1,665,090 15.59% 52ct 68,355 0.64% If I have the…
-
Separating words in a column where certain words have more spaces than others
I have a column in a dataset of production data. The column is formatted as follows: Production Cherry Tomato 12x1pt - Packed Beefsteak 15 LB - Restack Mini Sweet Peppers 14x4 FM - Packed I'm wondering if there is a way to pull the "12x1pt" "15 LB" and "14x4 FM" into a column for "Size". Given the varying amount of white…
-
Dividing two SUM equations does not yield expected result
I'm trying to create a column that divides by "On Hand Weight" by a "Daily Sales Average" to give an estimated amount of days of inventory available. The "On Hand Weight" is a combination of weight at one facility + the weight at the farm level (decided by a variable entry). This is my current attempt though it seems to be…
-
Formula to include only today's date + last 4 weeks of data
I'm in need of a formula that will allow me to pull only the LAST four weeks of "Ship Date" data so I can get a weekly sales average from said data. I've tried a few variations of trying to use the INTERVAL function paired with < = to no avail. I need to then take the sales average acquired from the above task and assign a…
-
Calculated Field loses Percentage Format
CASE WHEN SUM(Total Weight/Units Received) > SUM(Weight (MIN)) AND SUM(Total Weight/Units Received) < (Weight (MAX)) THEN '1' WHEN SUM(Total Weight/Units Received) <= SUM(Weight (MIN)) THEN SUM(Total Weight/Units Received / Weight (MIN)) WHEN SUM(Total Weight/Units Received) >= SUM(Weight (MAX)) THEN SUM(Total Weight/Units…
-
ETL to Track Weekly Contracts
I'm trying to connect two datasets to track contract fills per week. The screenshot is from one of the two datasets and it includes the contracted amounts of each commodity and the Start/End dates of the contract. The second dataset has data pertaining to the amount of cases actually received per day (which I have…
-
Contract Fill %
I have a card that i'm intending to use to track fill % of contracts. The card has columns for Commodity, Week#, Contract Weight, Actual Received Weight and then a Beast Mode Column to calculate the % of the contract filled. I'm feeding the card through an ETL. There are two input datasets in the ETL. One consists of…
-
Subtracting a "COUNT" result from a given value
I'm assuming I have this completely wrong. 1344 - COUNT(`Room/Row Id`) is what i'm trying to do. 1344 represents the total spaces available in a cooler unit. the COUNT equation is how many spaces are currently filled. The underlying math here is 1344-764=580, however i'm getting a result of 12,676.
-
How to set up a min/max equation in a Beast Mode?
I would like to setup a beast mode to calculate a fill % for contracted values, however I would not like it to show any values that went above 100%. I know in Excel it would be as easy as =MIN(100,SUM()) How would I accomplish the same thing within Domo? The two columns being run against each other are as seen below. Total…
