ChrisGaffan Member

@GrantSmith Thank You again!

REGEXP_REPLACE(`PRODUCT`, '^.*?([0-9]+[^ -]*\s.*?)(?= - ).*$', '$1') This works, however it then doesn't work for something like "Cocktail 16X14OZ - Packed". Looks like it's not going to be doable due to the variability of how the original column is formatted. @GrantSmith

@GrantSmith This seems to be removing anything before the x. "Mini Sweet Peppers 14x4 FM - Packed" comes out as just "4 FM"

@GrantSmith Would i use a Formula plate for that or would I place it into a "Custom" delimiter within the "Split Column" plate? Also no, they won't always have an x. Some will be whitespace between a # and "LB" "PK" "PT"

@Sean_Tully That did it. Thank You

@Sean_Tully It's definitely something to do with the Variable Farm Weight. Nothing I do recognizes it as a single amount that i'm adding to a "sum". It just keeps trying to create more instances of the variable against the rows of the "On Hand Weight".

I've tried that. The "Farm Weight" is one single amount assigned through a variable controller where as the "On Hand Weight" is a sum of multiple rows. I believe when I wrap it this way it tries to assign portions of the "Farm Weight" to each row of "On Hand Weight" which results in a number in the millions when it should…

@GrantSmith that worked! Always a quick response from you, Thank You.

@ColemenWilson Thank You.

@ColemenWilson Ya i think I complicated it with my long winded description. I just want to know if there is a calculated field I can make where Domo will recognize all of the dates that occur between the "Start and End Week" column dates so I can pull out Week #s to compare to. OR, will I need to take those columns and…

@marcel_luthi The 'Receive Date' column is breaking the functionality of the Group By. I have the 'Receive Date' data converting to "Week #" within the ETL. However, I can not leave the 'Receive Date' column out of the final dataset due to Domo's need to have a range field for the 'Date Range'.

@MichelleH @GrantSmith The sorting is what was breaking it. I removed the dimension from Sorting and it now works properly. Thank You both.

@MichelleH With Distinct, it returns 12,716. Without Distinct it returns the original 12,676

@MichelleH AVG(1344)-COUNT(DISTINCTRoom/Row Id) Returns an even larger value.

@GrantSmith COUNT(`Room/Row Id`) alone returns 764 which is accurate. It's when I add "1344 -" that it spits out 12,676.

@MichelleH Yes, I just needed to add SUM before the equation and it worked perfectly. CASE CASE WHEN SUM(Total weight in lb's / Contract Weight) > 1 then 1 ELSE SUM(Total weight in lb's / Contract Weight) END Thank You.