How to crate test Cases automation coverage report (inventory)

We are moving to Jira cloud and Zephyr scale. We have custom field in our test cases that contains automation statuses (manual, automated, planned ,etc)

I need to create a report that will return me what percentage of my test cases are Automated, what Manual, what Planned. It is critical for our CI/CD initiative and I do not see a way to run such a report. Thank You.