AVG or MAX Value over a grouped Timeseries in a given Time

Hello Grafana Users and Mentors,

hopefully you can help me. I am currently trying to set up a new reporting for counting Kubernetes deployments. I try to count the average of containers that were set up on our Kubernetes cluster in one month. I currently have to filter whether the pods have a certain number with containers that have a property in their name. This is currently the start of my query, which also displays the per Day data in a line. I only need the average as a value, which I can output.

count (sum by (container) (kube_pod_container_status_running {container = ~ “app -. *”}) <3)

Do you have any information about what I might be missing?