I’m new to QS and am trying to get an daily percentage of how many files we received were processed correctly, how many are awaiting processing, and how many have issues.
I have a log table with a ‘status’ column that can include the following values (processed, cancelled, failed validation, received, etc.) Processed means correctly processed. Received means awaiting processing. All others mean there’s an issue with the file.