How write a query to show the total number of voice calls per day each day based on voice metrics in grafana

how to write a query to show weekly/monthly (configurable) interactions by channel (Chat/Voice) as well as by customers. So a report that can show me trend data on usage from a system level on voice or chat as well as a customer level.


Please share your data source? Sql server? Mysql?

Data source is prometheus, we have voice_streams_open and voice_streams_opened_total metrics are exised

could you please provide some sample data?

I have created like this…

but they are expecting like this image.

please help me