Chronograf draw table multiple tag as columns

InfluxDB 2 Dashboards
1

update: it seems Im asking for a pivot table which chronograf does not currently support.

points are in this format:

tags:
  api ( A, B, C, D )
  status ( 200, 500, 403)
  data_center ( E, F, G )
  ...other_tags
fields:
  message

I want to know the total count of error happens in past (x hours) for different api and different data center.

SELECT count("message") FROM "db" WHERE "status"='500' AND time > :dashboardTime: GROUP BY  "api", "data_center" FILL(none)

this does not give me what I really want,

I want something like this:

----------------------------
|       |  E  |  F  |  G   |
----------------------------
|  A    |  1  |  2  |  3   |
----------------------------
|  B    |  2  |  1  |  3   |
----------------------------
|  C    |  1  |  1  |  2   |
----------------------------
|  D    |  1  |  1  |  0   |
----------------------------