Table Total Row and Beast mode Aggregation
Hi experts, I'm tying to build a table of consumption by subtracting a total on different days. I'm using the lead to get the next value and subtracting the current one: When I able the total row option an error occurs: My first question is why is it happening? My second question is why doesn't the bar chart aggregate the…
Why doesn't my line + bar chart show the "Show data label on" option?
I want to display data label only for the line but the option is off.
How to Update federated data automatically?
I tried interacting with a card, but it still didn't work.
Combine tables using ETL inner join
Hi everyone, I'm trying to combine two federated tables using the inner join in Magic ETL. Both tables have over 9.5M rows but when I join them, the result is only 87K. I tested the join in Snowflake and it resulted in 9.5M by the logic: SELECT * FROM 'A' INNER JOIN 'B' ON A.X = B.X What could i be doing wrong? *I'll need…