The advanced calculation feature uses the following syntax for a data source:

=({$connectorname|feedname|tablename|fieldname})

e.g. =({$PBXname|Groups|Sales|tsf})

This will display the tsf value of the sales group.

You then add the operation you want + - / x (i.e. add, subtract, divide, multiply)

The operation needs to be outside of the curly brackets ( { } )

Then enter the next data source formula as above.

The entire formula created should be within brackets ( )

e.g. The following example combines tsf values together then divides by 3 to find the average tsf.

=({$PBXname|Groups|Sales|tsf}+{$PBXname|Groups|Support|tsf}+{$PBXname|Groups|Service|tsf} / 3)

Here is an example of the syntax for working out Answer rate% :

=({$Connector|Feed|Group|callsAnswered}/{$Connector|Feed|Group|callsTotal})

You would then choose the display as "percentage" option, Optymyse will automatically do the x100 calculation for you to make it a %

Another example syntax for displaying the largest tsf number out of 3 groups is shown below, you would just need to enter the relevant info in the {} brackets as explained above (you can of course change the stat to whatever you wish it doesn't have to be TSF.

To show the smallest number simply change > to <

=({$PBXname|Groups|Sales|tsf} > {$PBXname|Groups|Membership|tsf} ) ? ( ({$PBXname|Groups|Sales|tsf} > {$PBXname|Groups|Support|tsf} ) ? {$PBXname|Groups|Sales|tsf} : {$PBXname|Groups|Support|tsf} ) : ( {$PBXname|Groups|Membership|tsf} > {$PBXname|Groups|Support|tsf} ) ? {$PBXname|Groups|Membership|tsf} : {$PBXname|Groups|Support|tsf}

## Comments

0 comments

Please sign in to leave a comment.