-
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…