Number of reviewers about incubator-devlake HOT 3 CLOSED

{name: 'foo', reviewers: ['[email protected]', '[email protected]', '[email protected]']}

{name: 'foo', reviewers: ['[email protected]']}

{name: 'foo', reviewers: ['[email protected]']}

SELECT count(id) from (
  SELECT
    unnest(reviewers) as reviewer
  FROM
    gitlab_merge_requests
  WHERE
    $__timeFilter(gitlab_created_at) AND project_id = $ProjectId
  group by 
    reviewer
) as id