> For the complete documentation index, see [llms.txt](https://resources.unizin.org/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/release-notes/udp-marts-release-notes/1.0.72.md).

# 1.0.72

UDP Marts

## Metrics Logic in Taskforce Marts, Supporting UT Austin

| Version      | 1.0.72             |
| ------------ | ------------------ |
| Release Date | September 12, 2024 |

## Key Features

### Weighted Assignment Metrics in Taskforce Marts

Based on feedback from PSU, these logic changes to the taskforce marts change how the `avg_published_score` metrics are defined when there are no assignment weights defined for the given week. Before, the `avg_published_score` fields were null if there were no weights defined for the week. We now define the unweighted score in these cases instead.

```
CASE 
      WHEN SUM(assignment_group_weight) = 0 
        THEN SUM(published_score)/SUM(points_possible) 
      WHEN SUM(assignment_group_weight) > 0 
        THEN SUM(assignment_group_weight*published_score_pct)/SUM(assignment_group_weight) 
      END AS avg_published_score
```

Furthermore, we have introduced metrics for counting weighted assignments as we do unweighted assignments.

#### Marts Affected

* mart\_helper.taskforce\_\_level1\_assignments\_submissions
* mart\_taskforce.level1\_aggregated
* mart\_taskforce.level2\_aggregated
* mart\_taskforce.level2\_course\_week\_metrics
* mart\_taskforce.level2\_course\_weekly\_distribution\_summary

### Supporting UT Austin

UT Austin's new UDP instance now has full support of UDP marts.

### File Interaction Partitioning at Monthly Level

The partitioning for the `mart_course_offering.file_interaction` and `mart_course_section.file_interaction` marts now partition on the `created_date` of the file at the monthly level.

BigQuery has a partition limit of 4000 for table updates, and keeping the partitioning at a daily level of `created_date` throws errors for tenants with Canvas instances longer than 11 years. The partitioning by month on `created_date` yields a maximum of 333 years of partitions, solving this potential issue for tenants moving forward.