-
Magic ETL: AI Text Generation Tile
Has anyone noticed a pattern in the AI Text Generation Tile regarding run time? Two days ago, I passed through 100 rows to test the prompt and my ETL ran successfully in 10 minutes. Then I passed through 23k rows and it ran in about 55minutes. However today, processing 23k rows again after 9 hours with an "unknown error"…
-
Datediff in Redshift vs Magic ETL
Hi there! Im trying to recreate a calculation from Redshift to Magic ETL. Im running into some trouble with a specific formula. In Redshift: DATEDIFF('week',"start_date__c","end_date__c") In Magic: v1 - DATEDIFF(`end_date__c`,`start_date__c`)/7 In Magic: v2 - WEEKOFYEAR(`end_date__c`) - WEEKOFYEAR(`start_date__c`) Showing…
-
Rolling 12 Month Average in Magic ETL
Hi there! Was hoping someone would have a solution for what I am trying to do. I want a 12 month historical average in line with the current month in my dataset. (Sample datasets will only show 3 month) This is a sample dataset of what I am working with: *"Desired Column" would be the field that holds the historical…
-
Paging in a Table Card
Hi there, I was reading a closed forum question that suggested an answer that may no longer be true at this date. Original Question: https://community-forums.domo.com/main/discussion/49658/mega-table-dynamic-paging I have a Mega Table with about 600 rows. I don't want to show all 600 at the Dashboard level, even with the…
-
LEAD IGNORE NULL in Magic ETL?
Hi there, I am trying to rewrite a Redshift Dataflow into Magic ETL. I ran across a specific function that was available in Redshift that I dont think is possible in Magic ETL. I wanted to get the community's input and advice to see what you guys think. This is the function found in Redshift: LEAD(CASE WHEN t2."channel"…
