Who has not done their Impact Assessment

[James_Noble]

I have a radio button field called IA (Impact Assessment) and we ask all stakeholders to tick their box when they have IA'd the change.

Is there a way to report on who has not done this?

I have a report which shows who HAS done this and it even tallies is up for me.  Superb!  But we would like to name and shame a few folk .. is that poss?

[Gor Greyan · Accepted solution]

Hi @James_Noble

As @Marc - Devoteammentioned, it is essential to mention how it is set up, whether stakeholders are mentioned in a separate custom field, or the stakeholder is the assignee.

One solution, which I think you can find all ticket where the mentioned field is empty, or doesn't have the value you are expecting.

For example, 
"Impact Assessment" != Yes OR "Impact Assessment" is EMPTY

Then display the Assignee or Stakeholder columns in the list view.

That gives you your “name and shame” list — who hasn’t completed IA yet.

You can also put this in the Dashboard gadget, with  2-dimensional type, to see that.

But for the correct solution, it is advisable to provide more information.

[James_Noble]

Hey - yes received.  Better forming of the question.. !  No problem.

Thank you for coming back to me.  Its nearly there ..

The custom field has say six boxes, one for each team.  

To assess the change I need each team to tick their box.

And then I need a report to show who has not ticked.

This isn't about Assignees as such but more just the ticking of the box.

I think it might be just too poorly set up by me and therefore a bit far for jira to go but there is another view of the situation I am trying to sort out.

Thanks in advance.

[Gor Greyan]

HI @James_Noble

Am I right that custom field type is a checkbox?

[James_Noble]

Yes.  I completely got it wrong to begin with .. it is not a radio button.  Several tick boxes can be simultaneously ticked.

Apols for that

[Gor Greyan]

@James_Noble

Thanks for the provided information.

I think this will work.

project = <KEY>
AND (
"Impact Assessment Teams" not in ("Team A") OR
"Impact Assessment Teams" not in ("Team B") OR
"Impact Assessment Teams" not in ("Team C") OR
"Impact Assessment Teams" not in ("Team D") OR
"Impact Assessment Teams" not in ("Team E") OR
"Impact Assessment Teams" not in ("Team F") OR
"Impact Assessment Teams" is EMPTY
)

This shows all issues where at least one team hasn’t checked their box yet.


project = <KEY>
AND (
"Impact Assessment Teams" not in ("Team A")
OR "Impact Assessment Teams" is EMPTY
)

You can duplicate this query for each team, just changing the team name.

And for finding tickets, where all teams have tick.

project = <KEY>
AND "Impact Assessment Teams" in ("Team A")
AND "Impact Assessment Teams" in ("Team B")
AND "Impact Assessment Teams" in ("Team C")
AND "Impact Assessment Teams" in ("Team D")
AND "Impact Assessment Teams" in ("Team E")
AND "Impact Assessment Teams" in ("Team F")

[James_Noble]

Hey thank you for that.  Amazing .. that is a step forward. :)

Do you think it is possible to concatenate the teams who haven't done it, into another custom field?

I think you have done enough and I really want to say thank you but I just had to ask that final one.

Have a great day and thank you again :))))

[Gor Greyan]

Dear @James_Noble

Glad that it helps.

It is a little bit tricky, but let's try this one.

You can create single-line Text field, for example, named Outstanding Teams.

Create Automation:

Trigger: Field Value Changed --> Impact Assessment Teams
Action: Clear --> Outstanding Teams

If/Else Branches(per team)

Impact Assessment Teams doesn't contain "Team A"

Edit issue: --> Outstanding Team

{{#if(issue.Outstanding Teams.isNotEmpty)}}{{issue.Outstanding Teams}}, {{/}}Team A

Repeat for Team B, Team C, Team D, Team E— same logic, just swap the name.

Final Else branch:

Edit issue: --> Outstanding Teams

And set All Teams Done

I think, this will work :)

[James_Noble]

Ok so I am excited!  It will take me a bit of time to try that .. I will come back very quickly though ... thank you 

Deep breath ..!

[Marc - Devoteam · Accepted solution]

Hi @James_Noble 

How is this setup and are stakeholders mentioned on the issue?

Can you provide more context, include screenshots, etc..

[James_Noble]

Thanks for coming back to me on this.  So I created a custom field with all the folk due to do the IA.  They need to open the issue, assess it and then tick the radio button for themselves.

I can run a nice report for the issues at hand and the IA column amazingly notes who has ticked their box and it even gives a total!  I mean just fab.

However I would like another 'shaming' report, for those who have NOT ticked their box.

I guess somehow, jira would need to look at who has ticked and compare against the list of Radio Button options and then deduct one from the other.

But I think that is a big ask .. or is it?

Not allowed to do screenshots I am afraid but huge thanks in advance.