MarkSnodgrass Coach 
-
Re: Sum if using Case When
Try this: SUM(CASE WHEN `Data` in ('Goal','Pipeline','in P&L') THEN `Total` ELSE 0 END) This should get the total you want.3 -
Re: Can someone help me with the syntax?
You need to make 8 different beast modes, 1 for each line you have in your screenshot. Then drag those 8 beast modes into your table card.1 -
Re: How to get last date
@ageibe You can do this with the Group By tile in Magic ETL. In section #1 (select what columns identify the grouping) put your name and patient Id columns in that section. In section #2 enter the na…2 -
Re: lag function
I would suggest doing this in Magic ETL. You can do this with just a few tiles, the formula tile and the join tile. In the formula tile, create a field called LastYearDate and use the date_sub functi…1 -
Re: What is the syntax to add a "if contains the following" in my logic
It would be best to use the LEFT and SUBSTRING functions to look for those characters since they are always in the same spot. I would write the statement like this: CASE WHEN LEFT(`shipmenttariffid`,…2
