I keep getting this error when I try to create either a table or a scorecard: Error ID: 58135e13.
The problem occurs because the field in question (Small Group Instructional Avg), currently only has null values (specifically, “”, linked in Google Sheets. This creates a problem when that field is used as a metric. It shows up as a dimension, and I can even have the null shown as any of the options, such as “null” or “-”.
I need to be able to set this up, so as data comes in to complete that field, the rest of the dashboard works.
I’ve tried created calculated fields, such as IFNULL(Small Group Instructional Avg, 0), but it has not yet worked.
Help, please.