For example, rather than `Response Date` or `Study ID`, use something more generic that will make sense across all algorithms. - [ ] Rename `Response Date` to `Date` - [ ] Add `Completion ID` to the table and make this the drill down column - [ ] Check Study ID for null values by using `IFNULL()` in the select clause https://database.guide/4-ways-to-replace-null-with-a-different-value-in-mysql/
For example, rather than
Response DateorStudy ID, use something more generic that will make sense across all algorithms.Response DatetoDateCompletion IDto the table and make this the drill down columnIFNULL()in the select clausehttps://database.guide/4-ways-to-replace-null-with-a-different-value-in-mysql/