Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Lookup tables to store values

Lana Kelly August 31, 2023

I am trying to assign values to different dropdowns, and then multiply the value of two different dropdowns together.  I have created lookup tables for them both,
Screenshot 2023-08-31 at 10.33.46.pngScreenshot 2023-08-31 at 10.34.22.png

I want then to multiply the value from each table to give me a quantified risk score.  Do I need to create a variable for each thing, or can I just lookup from these tables?  At the moment, my next step is:
Screenshot 2023-08-31 at 10.36.20.png

 

Sorry for all these questions.  I'm quite new to automation still.

1 answer

1 accepted

3 votes
Answer accepted
Matthias Gaiser _K15t_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 31, 2023

Hey @Lana Kelly

no need to be sorry. Your questions are totally fine - and I think you're close to the solution yourself. It's a good idea to use lookup tables for defining the numerical value for both of the fields.

In the Edit Issue step, you only need to modify your smart value, so that it takes the value from the fields and looks it up in the tables. I think, this one should work:

{{#=}}{{SeverityTable.get(issue.Severity)}} * {{LikelihoodTable.get(issue.Likelihood)}}{{/}} 

All the best with your automation,

Matthias.

Lana Kelly August 31, 2023

I just tried it and it works!  Thank you so much!  😊 

Like Matthias Gaiser _K15t_ likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events