Comments
-
@kelly_tagtow Thanks for the update. yes, Its fixed. I just got the case resolved last week.
-
I referred the manual writeup . You are doing Last Quarter Calculation select d.`dt` as "Report Date", date_sub(`dt`, interval '1' quarter) as "Comparison Date", 'Last Quarter' as 'Period Type' from `calendar_dates` d How would you do Current Quarter to date and Previous Year Quarter to Date?
-
How would you do the same in magic ETL. For instance if I need to coalesce one column to another only when value is in a pattern
-
Hi Justin, This might help https://knowledge.domo.com/Connect/Connecting_to_Data_with_Connectors/Configuring_Each_Connector/Connectors_for_Marketing/Google_Ads_via_Google_BigQuery_Service_Connector