Empty filed counter query

[Artur Nogaj]

Hi All,

I'm a new-joiner to the community so hello to Everyone! :)

I need a support in counting empty fields in a issue.

So this is how it's look like - we've established a list of mandatory fields that should  always be filled in for different projects for a certain group of teams. The tricky part is with the field mandatoriness asterisk - we can't use this feature because other teams are also using those projects and they are not oblige with the liste of mandatory fields. 

However, we need to track progress of filling out of those fields and we need to know how many fields are still empty among all issues within the projects. 

When using a simple query like:

"Field 1" is empty or "Field 2" is empty or "Field 3" is empty

I receive only the number of issues but still missing information how many empty fields are there. 

What I don't want to do - creating query to show number of issues per each field or to show number of issues per each project. 

Is there any way to show number of empty fields?



Of course, if this topic was discussed earlier or even solved please let me know (I was searching for the solution but I couldn't find any). 



Regards,

Artur 

[Ravi Sagar _Sparxsys_]

Hi @Artur Nogaj 

Once simple approach would be to create separate JQL filters for those empty fields.

For instance a query like this will give you all the issues where this field is not filled in.

"Date Picker Field[Date]" is EMPTY

You can then further narrow it down to your project only, save your JQL query as filter, subscribe to email notifications, display on dashboard, add as quickly filter on your boards and may be do automations to add comment on the issues.

I hope it helps.

Ravi

[Artur Nogaj]

Hi @Ravi Sagar _Sparxsys_

thanks for your answer! 

Correct me if I'm wrong - by creating separate JQL filter for those empty fields, then using filter, dashboard etc. I will bring only number of the issues where the field is empty, not number of empty fields (which is what I need)?