Total count in a table?

Grafana
1

Sorry if I am not explaining it correctly but I was wondering, how can I summarize all of the results of a query in a table to show total count? For example:

Imgur

How can I make those WAN-OUT-50-D show in one line with a total count of how many times it happens?

I am using the Raw Document metric.

Thank you.

2

Hi, I use a columm who count rows. I add in select.

SELECT
,[NOMEGRUPOSUPORTEDESTINO] AS ‘Grup Sup Dest’
,(row_number() over (order by [DATE])) AS ‘Contador’
FROM TABLE

graf4