RobSomers Coach 
-
Re: Integrating different social media platforms reporting
@SaloniShah Yes, when you save the ETL, you can choose how you want it to update, and one of the options is to update it when ever datasets used are updated.1 -
Re: How to calculate % of projects assigned?
@domodonuts SUM(case when 'DaysToAssigned' <= 10 then 1 else 0 end)/SUM(1)3 -
Re: Magic ETL Help
@damen After adding the column that calculates the days between orders, you can do a Group By tile to group the customers together and average the days between orders.2 -
Re: What is the best way to calculate?
@damen You'll need to remove 'instrument' from Series, and create the separate beast modes for each instrument you want to measure. Ex: AVG(case when 'instrument'= 'first home exempt' then 'spread' e…1 -
Re: Text unique values - only count for each option
@zgranperc With your Audience field having multiple options in each row, you're going to need to do a beast mode for each option. First one would be: SUM(case when 'Audience' like '%C-Suite%' then 1 …3
