Group by time and metric

We are trying to make a graph of daily deployments like GitHub - GoogleCloudPlatform/fourkeys. In addition to it, we want to watch daily deployments group by git repositories.

Data of BigQuery is like this:

repository time_created

platform-api 2022-06-28T03:42:35.214Z
platform-admin 2022-06-29T02:07:18.220Z
platform-api 2022-06-29T07:07:03.695Z
platform-payment 2022-06-30T01:51:13.009Z
platform-payment 2022-06-30T01:51:14.184Z
platform-kyc 2022-06-30T05:13:56.187Z
platform-kyc 2022-06-30T06:24:29.761Z

I wrote query of Grafana as below


SELECT

TIMESTAMP_TRUNC(time_created, DAY) AS time,

COUNT(distinct deploy_id) AS deployments,

repository as metric

FROM

four_keys.deployments

GROUP BY time,metric

ORDER BY time

Currenly, graph of Grafana is

We are expecting for Grafana to shows like:

Does anyone know how to set a query to see like this?