Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,296,276
Community Members
 
Community Events
165
Community Groups

Automationto compare two values and report of differences over a threshold

I have two custom number fields in my project. I would like an automation which alerts users if there is a difference between these two values of 0.05 or greater. Would someone be able to advise of the easiest way to do this or similar.

 

 

1 answer

0 votes
John M Funk Community Leader Jul 12, 2021

Hi Mitchell,

Here's what I would do. Create a new custom number field. 

Then when either one of the two current fields is updated, fire an automation rule to update the new custom number field. The edit for that field will look like this:

{{issue.customfield_16825.diff(now).days}}

Note - you can sub out the "now" part for another field if you like.

Then do a re-fetch of the issue.

Then add a condition that if the new number field is >= 0.05 then send an email to someone. 

Hopefully, that is enough to get you started. 

Hi John,

Thanks for your response. Sorry in advance I don't have much exeperience with smart values. What custom ID am I swapping out 16825 with?

Thanks

John M Funk Community Leader Jul 13, 2021

You can just use the name of the field like this:

{{issue.Field Name.diff(now).days}}

Just make sure it is exactly like your field name. 

To see the id of a field, go to Settings (gear icon) > Issues > Custom Fields

Then search for the field you want to see. 

Then click on the 3 dots menu on the right side and select Contexts and Default value.

Finally, you will see the field ID in the URL address in the browser.

Hi John, 

Sorry I wasn't quite clear. Which of the 3 custom field ID's am I swapping out with 16825? I have the two custom number fields which I want to find the difference between and then I also have the third custom field which you recommended to be created.

Thanks

John M Funk Community Leader Jul 14, 2021

What are the names of the two fields? And which one should be subtracted from the other? 

Hi John,

One is called radar and one is called acoustic. A user checks the measurements for each of those instruments and reports them in Jira against those two custom values. Both instruments should be recording an identical or similar value. Were wanting to be able to tell if there is something wrong with one of the instruments by having an automation trigger if there is a difference of 0.05 or more between either of them. So theoretically either of them could be subtracting from the other if one of the instruments is giving a false reading. So perhaps I would need to look for differences of both >=0.05 and >=-0.05?

Thanks

John M Funk Community Leader Sep 21, 2021

Hey Mitchell - Did you ever get this worked out? 

Hi John,

No I wasn't able too. I couldn't figure out how to write your rule.

If you can elaborate more on what needs to be done. That would be great.

John M Funk Community Leader Sep 22, 2021

Sorry it took so long to get back to your before this. Do you have a rule started at all? Or do we need to look at it from scratch? 

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Apps & Integrations

Marketplace Partner Spotlight: AppLiger

This month the spotlight is on AppLiger. We caught up with Pavel Pavlovsky, CEO and Product Manager, to learn how the company started and what fuels the team's creativity.    Atlassian:...

366 views 0 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you