Allow users to filter or calculate on the Jira Key in reporting Merged

We have our products set up with a Jira Integration.  We'd like to be able to report on those requirements that are in progress that are missing a Jira Key.  Ideally this should not happen, but we have found that it does from time to time.  So it would be helpful if we could report on this in a clear and concise way.  Ideally: 

-in a list view with a list of the requirements that are missing the Jira key.  Right now I can report on all requirements in progress and what the value is for the Jira Key.  I can sort the Jira Key column although no matter how I sort I can never get those without a Jira Key at the top.  So, I have to go through the whole list to find those requirements without a Jira Key since I cannot filter out those with a value. 

-in a chart or pivot form showing out of x number of requirements this % or count have a Jira Key and this % or count do not.  Since I cannot use the Jira Key in a calculation column I am unable to do this in a way that isn't very long and clunky because there is a record for every requirement with a Jira Key (which is a lot).