If you want to find for yourself a good way of optimized and improved workflow when working with Jira, I recommend you to install the
power bi jira connector. The integration of such an application will allow you to export the data and analyze the data in bi tools with great convenience and ease. I think this is the best solution for you.