@Anderson, Mick Thanks for your patience on this.
Currently Workload Profile Node Count (Preview) is the only metric emitted by Azure monitor for container app environment as mentioned here
I understand you are looking for cpu usage metric at container app environment level which is not supported. I would suggest you raise a feature request here in feedback.azure.com, our engineering team actively monitor the requests present here and work towards its implementation based on the feasibility.
In meanwhile, the workaround would be to use either of the above suggested workarounds creating a function app and running the above shared az cli cmdlet in it.
Hope this helps, let me know if you have any further questions on this.