GrantSmith Coach 
-
Re: How to extract a substring from an URL
CONCAT(SPLIT_PART(`url`, '/', 1), '/', SPLIT_PART(`url`, '/', 2)) SPLIT_PART will get the values with the data split out by a specific character. It's undocumented in the UI but is accessible. Concat…2 -
Re: How do I logout of a domo instance?
Are you doing a platform embed? There should be a profile icon in the upper right for you to log out of. I know you can access the logout link directly: https://{customer}.domo.com/auth/signout1 -
Re: How to get Gross Sales from Shopify?
According to their documentation Net Sales is Gross - Discounts - Returns + Taxes + Shipping so you should be able to back into Gross sales with: Gross = total_price + total_discounts + returns - tot…2 -
Re: PDF exports from App Studio
Currently I don't believe this is an option but I'd recommend adding this to the Idea Exchange1 -
Re: Time Difference in Minutes
You can simplify your beast mode. If either of your fields are NULL then the entire subtraction will be NULL. (UNIX_TIMESTAMP(`Hospital Ready Time (UTC)`) - UNIX_TIMESTAMP(`Video Start Time (UTC)`)) …3
