So you have step one done, collecting the time series data. You seem to have an error in your shell script because you create a file commandout.txt but mail a file output.txt.

The next steps would be

1. Create a data structure from the report files
2. Create reports from the data structure

Note that this site is not a program-request site. We will gladly help you with your programming problems, but we rarely provide programs that solve a complete problem.