Due to some unexpected problems; some owned by Looker, some by Bitfocus, unplanned updates were necessary. These updates were completed during the week of 9/18/2020.
The main identified problems are:
- In some situations, duplicate rows were being returned in results
- Related to the duplicate row, Enrollments Counts returned the incorrect count
- Merged queries which relied on Enrollments ID in the HMIS Performance model were not working as expected
The duplicate rows error appears to be related to the Clarity Data Analysis release, whereas, the Merge Query issue is a bug which has been reported to Looker. However, a workaround has been coded to address the Merge Query problem.