PAL Trending: Data in txt table in Mpps

Change-Id: I5427e14479b4403319b817e75d83b95b64bcddb6
Signed-off-by: Tibor Frank <tifrank@cisco.com>

1 files changed, 10 insertions, 2 deletions

diff --git a/resources/tools/presentation/generator_CPTA.py b/resources/tools/presentation/generator_CPTA.py
index 3b8c9fd3ab..2e9abde13c 100644
--- a/resources/tools/presentation/generator_CPTA.py
+++ b/resources/tools/presentation/generator_CPTA.py
@@ -443,15 +443,23 @@ def _generate_all_charts(spec, input_data):
         file_handler.writelines(csv_table)
 
     txt_table = None
-    with open("{0}.csv".format(file_name), 'rb') as csv_file:
+    with open("{0}.csv".format("cpta-trending"), 'rb') as csv_file:
         csv_content = csv.reader(csv_file, delimiter=',', quotechar='"')
+        header = True
         for row in csv_content:
             if txt_table is None:
                 txt_table = prettytable.PrettyTable(row)
+                header = False
             else:
+                if not header:
+                    for idx, item in enumerate(row):
+                        try:
+                            row[idx] = str(round(float(item) / 1000000, 2))
+                        except ValueError:
+                            pass
                 txt_table.add_row(row)
         txt_table.align["Build Number:"] = "l"
-    with open("{0}.txt".format(file_name), "w") as txt_file:
+    with open("{0}.txt".format("cpta-trending"), "w") as txt_file:
         txt_file.write(str(txt_table))
 
     # Evaluate result: