GrantSmith Coach 
-
Re: Column is Adding rather than giving Average
Because your aggregation is within your case statement, it's getting treated differently. Try this instead: COUNT(DISTINCT CASE WHEN HdrParentItemCode = 'ZPUNCH' AND JT158_WTParent = &…1 -
Re: How do I construct my desired query?
The issue is that your metadata variable is undefined and you need to handle the Promise. I'd try to do something like: domo.get(metadataQuery, {format: 'array-of-arrays' }).then(funct…2 -
Re: Trying to call accounts API from brick
I don't believe this is possible within a Brick due to the security concerns around the storage and usage of account credentials.1 -
Re: Getting x axis sorted correctly
I'd recommend calcluating the first date of the week and use that for your sorting. If you have a Date field you can do something like this: `Date` - INTERVAL (DAYOFWEEK(`Date`)-1) DAY This will…1 -
Re: Removing yesterday data from ETL
You can use a filter tile with a formula and the CURRENT_DATE() function: `Date` < CURRENT_DATE() - 12
