Comments
-
@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.