GrantSmith Coach 
-
Re: Appending an update set to itself
If you can’t use the connectors append update method I have utilized the DataSet Copy connector to take daily snapshots of a dataset and set that method to append. https://domohelp.domo.com/hc/en-us/…1 -
Re: Dynamic Percentages of Total
Hi @etszyingho Your beast mode should automatically take into account your date filtering. Since you're using a pivot table things get a bit funky. How are you partitioning your data within your…1 -
Re: Dynamic Percentages of Total
Window functions and pivot tables can be tricky. Glad you got it figured out!1 -
Re: How to use case statements within Filter function in Magic ETL 2.0
Hi @tejusarora Have you tried it to just return a TRUE / FALSE statement instead of doing your CASE statement? member = 'John Doe' AND `date` >'1/1/2021'1 -
Re: I am trying to calculate the difference between values in the same column on 2 different dates
Hi @Salmas Beast modes are evaluated on a row basis and typically don't know of other rows. So in your case it won't ever see a row with rank 1 if it's on the row of rank 2. When you s…2
