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 ..!

[James_Noble]

Hi so ... yes it is right on the edge of my abilities here however I have set it up for the first team and the new one line text field is not updating with the missing team.

Do I need the final part of your routine, or is that the cherry on the cake, if all teams have assessed the issue?

[James_Noble]

Also where I am repeating for team is that an additional line of code or a whole If section?

[James_Noble]

If I put a manual entry in the Missing Teams field, the current rule will empty that when I update the IA field which is a start ... 

[James_Noble]

Hey ... so thanks for that steer.  I did have a good go at it but unfortunately, even though I thought I had it in the bag.... I don't.

We are on the old Data Centre version of jira and don't have access to the Editor, which support Smart Values and to be honest, the .json for this is getting too complex.

Hope to migrate soon to Cloud and then will have another go.

thank you so much again though!

[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.