-
How can I only show the top 3 in the bar graph?
Hi, I made this bar graph ( For example, number of people who likes flavor of ice cream) and I only want to show the top 3 flavors. How can I filter that? Thank you.
-
Magic ETL Question: Rank and Window and Filter
Hi, I’m trying to retrieve the current major for each student. Specifically, I need to select the ACAD_PLAN that ends with "BS" (for example: "BUSMBS"). Once I have those, I need to find the most recent EFFDT (effective date) that is less than or equal to today’s date, because I want to exclude any future majors.…
-
Using Average on Beast Mode
I want to calculate the average number of semesters that students with bachelor's degrees have completed. Below is my Beast Mode calculation. However, it currently counts all semesters (or terms) a student has attended, even if they pursued additional degrees after earning their bachelor's. I only want to count the…
-
How should I change my calculation in the Filter Rows Tile in ETL?
Hi, I am using the Filter Row Tile in the Magic ETL. I want to filter the Overall Credits Column and only get the maximum for each student. However, the MAX and FIXED BY don't work. How should I fix this? I also tried the Add Formula Tile and it did not work either. MAX(Overall Credits)FIXED(BY Student ID)
-
Do I have the right code in my Python Script?
Hi, Select Columns 2 has four columns, they are EFFDT, ACAD_PLAN, DESCR, and ACAD_CAREER. I wrote a Python script to filter the EFFDT column so that it only includes rows where the value is 'A'. However, when I try to join this dataset with another, I receive an error stating that the referenced column, which is the…
-
Why is it creating duplicate rows?
Hi, my first dataset has 21,683 rows, and the second dataset has 323 rows. However, when I joined them together, the resulting dataset has 31,045 rows. I noticed that there are duplicate rows. How can I fix this? Thank you!
-
Beast Mode: Why am I not getting the correct number of enrollments per academic year?
I created a Beast Mode calculation to extract the academic year based on term codes. For example, to derive the academic year 1955-1956, I identified these three term codes: 1555, 1561, and 1563. 1555 is Fall 1955. The 2 digits in between are the year. (The last digit ‘5’ represents Fall). 1561 is Winter 1956. (The last…
-
Join Data in ETL
I have two datasets: one for home country and another for citizenship. Both datasets share two common columns: country and student_id. In the home country dataset, the country column is 70% populated, leaving 30% of the rows as null. I want to fill these null values in the home country dataset using the corresponding…
-
Is there a way to change the order of the color key so that it matches the order lines?
-
How do I count the values in a column using beast mode?
14.76K is the total number of students (Both full-time and part-time). What would be the formula if I only want to count the Full-time values in the Full-time/Part-time column? And then if I want to change the count to percentage, do I need another formula for it? Thank you.
