Unfortunately, I can't use a pivot table - they want the column added to an existing straight table.
If I create the daily results value in the load script, how would I use it? I'll look up the syntax for group by.
I picture another table, with only these fields: Date, TestName, sum(tests), sum(errors), ResultsPct. Then I could link the field TestName to the main table on testname. I will have to work on ensuring it's only one field to link (and not, say, test+productname)...
I want to add the new value in the Actual Vs. Goal table.
The value could be the sum of the last column in the Sample Chart table, but I am stuck at grouping this by month by customer by test number. I think I know how to use "where month = month(today()-1) " to get month-to-date for previous day.