Test analytics: fix monitoring calculations + add days in skip counter (#14620)

2 files changed, 10 insertions, 4 deletions

diff --git a/.github/scripts/tests/get_test_history.py b/.github/scripts/tests/get_test_history.py
index ad2fe187b00..06d4c323725 100644
--- a/.github/scripts/tests/get_test_history.py
+++ b/.github/scripts/tests/get_test_history.py
@@ -59,9 +59,15 @@ def get_test_history(test_names_array, last_n_runs_of_test_amount, build_type):
                 ROW_NUMBER() OVER (PARTITION BY test_name ORDER BY run_timestamp DESC) AS rn
             FROM 
                 `test_results/test_runs_column`
-            where (job_name ='Nightly-run' or job_name like 'Postcommit%') and
-            build_type = $build_type and
-            suite_folder ||'/' || test_name in  $test_names
+            where job_name in (
+                'Nightly-run',
+                'Regression-run',
+                'Regression-whitelist-run',
+                'Postcommit_relwithdebinfo', 
+                'Postcommit_asan'
+            )
+            and build_type = $build_type
+            and suite_folder ||'/' || test_name in  $test_names
             and status != 'skipped'
         );
 
diff --git a/.github/scripts/tests/update_mute_issues.py b/.github/scripts/tests/update_mute_issues.py
index c72110af3de..7ae751272e4 100755
--- a/.github/scripts/tests/update_mute_issues.py
+++ b/.github/scripts/tests/update_mute_issues.py
@@ -1,7 +1,7 @@
 import os
 import re
 import requests
-from github import Github
+from github import Github #pip3 install PyGithub
 from urllib.parse import quote, urlencode