GrantSmith Coach 
-
Re: removing last 5 characters of a value
Get the left characters up to the length of the last 5 characters. LEFT(`Field`, LENGTH(`Field`)-5)2 -
Re: Is it possible to recreate the SUMIFS formula in DOMO?
You can use a case statement within your SUM aggregation: SUM(CASE WHEN [CONDITION HERE] THEN `Quantity` END)3 -
Re: New Customers/
Ok, you can utilize a Magic ETL and the Rank & Window tile to calculate the customer's order number. Make sure you sort on the order date and partition based on the customer identifier and c…2 -
Re: Number of week calculations for fiscal YYWW (Year, Week of year)
What I'd recommend is establishing a new date dimension dataset which has each of your fiscal week values for each of the dates, you can then join this to your dataset to have the correct fiscal…1 -
Re: How to get last date
Use a group by tile to group on the name / ID and then take the maximum of your date field.1
