david_cunningham Coach 
-
Re: Beast Mode Syntax
@damen wrap it in CONCAT() and then adjust your year Concat(year(date issued), ‘-‘, year(date_add(date issued, interval 3 year)))1 -
Re: Filter in magic ETL
Yes - you can use the Rank and Window tile to create a rank based on your id. Then use the filter tile to return the rank you want. If you want the min id you can just sort ascending on your rank/win…2 -
Re: What is the problem with my beastmode?
@jasonm5545 I just commented on your other post that looked like the same question. Posting here as well so you have it. The issue is the argument BETWEEN. Try this instead. CASE WHEN Donors >= Lo…1 -
Re: How can I limit the data based on user?
You can use PDP for this. Set person1 to only see their data, and person2 theirs. Here are more details on how to configure.1 -
Re: Pivot/unpivot help Magic ETL
@Cbrack - perhaps I'm misunderstanding you, but to achieve your desired output you should be able to load in the group as your column and then average your qty_percentage in the value. For example. O…1
