Use jiraGet custom functions to get data via JIRA api, combine with sheet formulas and build graphs.

Generate reports from templates using Templates option in the add-on menu, update your project keys, team members, sprint & board IDs to start it up.

Use constructor functions:
getJiraIssueFieldsValuesForJQL(searchQueue, searchFor) gets 1-dimensional array of issues fields values  returned for the specified JIRA search query.
e.g.: =getJiraIssueFieldsValuesForJQL( "project in (QAE) and issuetype in (bug)","status")

Enjoy!

Sincerely yours,
QAEXPERTS.