MarkSnodgrass Coach 
-
Re: Checkbox Selector not showing all values?
If you don't have anything in the optional group by field, I would put the same field that you have in the items field into the optional group by and choose count as the aggregation type. I woul…5 -
Re: Setting up a count off of different date rules in ETL
From a syntax perspective, you are missing an END statement. You only have one, but you need two because you have two CASE statements.2 -
Re: Looking for Pattern in Data
You can use a case statement to evaluate this and look for SLD and SOLD. It would look like this: (CASE when `orderstatus` like '%SLD%' THEN 'Sold' when `orderstatus` like '%…1 -
Re: Date_Format Fiscal week number and Year
Try this in a beast mode DATE_FORMAT(`yourdatefield`,'Week-%U %X')2 -
Re: Help with Beast mode to calculate time in tier
Ahh... It was hard to tell from the screenshot if you need to access info from two different rows. In this case, You can still use the TIMEDIFF function, but you are going to need to do some work in …2
