-
Multi-line Chart - Looking for filtered AVGs with Overall AVGs
Hello, I have created a multi-line graph that shows the quarterly avg of grades of 3 students and filtered the line down to the name of 1 student. I am looking to show an additional line that is AVG of all 3 students along with the line that is AVG of one of the students. I cannot seem to think of a way initially and did…
-
Does Magic ETL v2 Have a Max Row Limit
Hello, I am in the process of combining two DataSets with Magic ETL where they have a same identifying Key. One of the DataSets has 3.9 million rows. When I use 'Join Data' between the two datasets, I end up with exactly 1,000,000 rows (when it should be in the 3 million range). I tried doing another Magic ETL where I only…
-
Formula for Combining Rows and Adding Columns
Hello, I am trying to accomplish a New DataSet using the Magic ETL where I combine multiple rows that have the same data in one column, but then create new columns for the data that isnt the same in other columns. To better explain, I have provided an example here. (Please see screenshot below) I have tried using "Group…
