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}
For more details please checkout our full article on data here: