Weighted Value Calculation Framework

[Yuna1]

Hi,

I have a table with field 'priority'. 'Priority' depends on multiple other field values that from the table's related list records or record type field's value under same record. 

Planning to give those fields arithmetic values then bringing a score rank system to calculate & assign the final value to ''priority''.

Are there any framework that available for this weighted calculation? 

The Matching rule kinda works but the ranking method is using 'More is better'/ 'Less is better.' and got me confused. Hard to find any helpful tutorial online too.

Of course BR would help too but that would involve heavy implementing.

Anyone has better advice or recommended framework? 

Appreciate your help!

Many thanks!

[Woz]

Hello,

Sounds like what you are describing is OOTB priority matcher rules. 

If you activate the "Data Lookup and Record Matching Support plugin" this will be automatically replace the calculatePriority business rule with a lookup table that holds your values called dl_u_priority

and a matcher record that defines how the rules work for example as seen below when an in this example when an incident field impact and urgency are updated a query will be run against your looup table to find a row with matching values 

[Yuna1]

Hi Woz,

Thank you for helping me! Is it possible to do weight calculation by using Matcher Rules? There are at least 5 variables from 5 different table are getting involved. I did an exploration but seems like matcher rules will not allow vairables from different tables.