AnsweredAssumed Answered

Starting a new section to a Solution, need help getting started.

Question asked by xxx202xxx on Feb 17, 2017
Latest reply on Feb 18, 2017 by siplus

The Issue:

On my Service MGMT Table I have a field called Service::Priority where the user inputs manually a value between 1 - 4 for each ticket created.  Now I am attempting to automate this process to leave the guess work out of the users hands sort-a-speak.  Users will still need to pick from the Urgency table and the Impact table (see below) but the join table will need the calculations done up.



New Tables I have come up with but need help doing the calculations for the 3rd table.


UrgencyProject LocationImpactIssue Impact
1North1No DataUrgency1234
2South2degraded service11124
3East3HW/SW Issue21224