Aurora: Create a ranking formula

For a rank to work as intended, you need to write a ranking formula outlining the criteria needed for a member to achieve that rank. Our default ranks already have criteria associated with them; you can use these for a quick Ranks setup or you can view them for more examples on how ranking formulas are written. 

The format for a formula is:

(variable operator value) Boolean operator (variable operator value)

A variable is one of the member metrics captured by the system. Examples of member metrics include number of accepted solutions, number of posts, number of post views, and number of minutes online.

Note: To view a list of the Aurora member metrics you can use in your ranking formulas, refer to Member metrics for ranking formulas.

A value is the measurement that you want the metric to have. A value can be numeric or alphabetic. For example, if the metric is minutes online, the value will be a specific number of minutes. If the metric is user ID, the value will be a username.

The operator indicates the relationship between the metric and the value.

The relationship can be numerical or text-based. These are the operators you can use:

The Boolean operator defines a relationship between two or more variable expressions. Each variable that you set as a criterion is a separate expression. You can use these Boolean operators:

 
You must enclose each variable expression (variable + operator + value) in parentheses. You can also combine variables to calculate values that the system may not otherwise provide. For example, to calculate the number of posts a member has made, you would start with the posts metric and subtract the deleted_posts metric. In a formula, it would look like this:

(posts - deleted_posts>=35)

Posts - deleted_posts is the variable, >= is the operator, and 35 is the value.

Here is a more complex example containing many metrics—it defines the age of the account, the number of content contributions (e.g., posts, articles, and comments), and the community engagement level (e.g., number of accepted solutions and likes) required for achieving the rank:

(registrationAge >= 259200) && ((((net_threads) + (net_replies*2) + (net_blog_articles*10) + (net_blog_comments) + (net_idea_threads*5) + (net_idea_comments) + (net_contributed_posts*5) + (net_published_tkb_articles*10) + (net_tkb_comments)) >=7000)||(overall_posts >10500)) && (((net_accepted_solutions*10) + (net_kudos_weight_given) + (net_kudos_weight_received*2) + (tagging_tag_count)) >=2800)

Custom fields that have been added to your community can also be included in ranking formulas. For example, a ranking formula composed entirely of custom fields may look like this:

((userInfo("c_fields_int.total_courses_count"))+(userInfo("c_fields_int.total_pathways_count"))+(userInfo("c_fields_int.academy_signin_count")*10)>=200) && userInfo("c_fields_string.favorite_disney_character")=="Mickey"

Written in a standard mathematical expression, this translates to:

(Total Khoros Academy Courses Completed) + (Total Khoros Academy Learning Pathways Completed) + (Academy Sign-ins Count * 10) >= 200 AND Favorite Disney Character = Mickey

This means that a member receives the rank only when the combined total of their completed Khoros Academy courses, learning pathways, and sign-ins multiplied by 10 is greater than or equal to 200… and their favorite Disney character listed on their member profile is Mickey.

To compose a ranking formula:

1. Go to Admin > Settings > Users > Ranks.
2. In the row of the rank whose formula you want to edit, open the Options menu and then Edit (or select Add Rank to add a new rank with a formula).
   
3. In the Criteria field, enter the formula you want to use.
4. Select Save Changes.
   

The rank now uses the criteria from the formula you added.

Related topics:

• About member Ranks and ranking formulas
• Create a rank
• Member metrics for ranking formulas