commit bd450674a4c7f2b7f50d2fe39520df3197204011
author Wayne Beaton <wayne.beaton@eclipse-foundation.org> Mon Jan 06 16:56:58 2020 -0500
committer Wayne Beaton <wayne.beaton@eclipse-foundation.org> Mon Jan 06 16:56:58 2020 -0500
tree 19cec395ee652b8dc2d13e5894af9dd2a7ca80f9
parent 6be2ed67f20ad945413bd344edda75e4d59c178e

Group by country name.

Change-Id: I2b3600a1ae9a02ec4c6b3c3ee4a9a9c77c6d3101

tools/kpis/cc_projects.inc

diff --git a/tools/kpis/cc_projects.inc b/tools/kpis/cc_projects.inc
index 0adb2d9..9fe8821 100644
--- a/tools/kpis/cc_projects.inc
+++ b/tools/kpis/cc_projects.inc
@@ -24,7 +24,7 @@
 				left join SYS_Countries as c on pa.CCode=c.CCode
 			where pp.InactiveDate is null
 				and pp.Relation='CM'
-			group by pa.CCode
+			group by country
 			order by if(code is null, 1, 0) asc, count desc
 		" )
 		->substitute ( ':date', (new DateTime())->format('Y-m-d') )