How do I add formulas?

Formulas allow you to produce more complex metrics such as ratios (RTs per 100 tweets for example) or (% target achieved).

To add/edit Formulas you:
  1. Edit Leaderboard and then click on the Metrics menu
  2. Add a Connector, select Fomulas and then click save.
  3. This will then take you to the screen to add the Formulas page, where you can enter a Formula. This is made up of calculator style operators (+ - / * ) and brackets. You can use any other metric as an input into your formula. 
  4. To edit Formulas once created, you do Step 1 and then click on the Formula's connector name to be able to edit the formula.

Available Functions

Our Formula language is based on the OpenFormula standard and supports the following functions:


Rounding Functions

ROUND


Summary: Rounds the value X to the nearest multiple of the power of 10 specified by Digits.
Syntax: ROUND( Number X [ ; Number Digits = 0 ] )

ROUNDDOWN


Summary: Rounds the value X towards zero to the number of digits specified by Digits
Syntax: ROUNDDOWN( Number X [ ; Integer Digits = 0 ] ) 

ROUNDUP


Summary: Rounds the value X away from zero to the number of digits specified by Digits
Syntax: ROUNDUP( Number X [ ; Integer Digits = 0 ] )


If there is an openformula function you require we'd be happy to implement it for you. Please suggest it.

Feedback and Knowledge Base