Submissions Dashboard: Use generic column identifiers.

[innershell]

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/