http://forums.visokio.com/discussions/tagged/formula_editor/feed.rss Mon, 30 Oct 17 18:44:18 -0400 Tagged with formula_editor - Visokio Forums en-CA http://forums.visokio.com/discussion/2122/formula-editor-improvements-and-performance-analytics-2.8- Fri, 03 May 2013 10:09:49 -0400 steve 2122@/discussions
To get started, open a file with a complex formula, hit Ctrl+F to open Manage Fields, find the blue formula and choose Edit > Edit formula.

Reformat and simplify

These were covered in an earlier post:
http://forums.visokio.com/discussion/1849/formulae-performance-and-usability-improvements-2.8-/p1
To sum up, Reformat allows you to space out and indent your formula into a clean logical hierarchy, and Simplify makes your formula simpler through use of SUBSET and INTERSECT rather than older SUBSETn functions.

Testing and performance analytics

The Test button allows you to perform a test-run, calculating your formula for every record in your data. This has two primary uses:

1. It allows you to find and fix errors which only occur with particular input data - such as division by zero. If an error occurs, you'll find yourself looking at that record and its error in the editor.
   
   
2. It allows you to identify performance bottlenecks if your formula is under-performing.
   
   After the test run has finished, a side panel will pop-in to the right of the formula editor. (You can resize the formula editor window if needed).
   
   This shows a tree view of your formula. For each tree node, it shows the average time per evaluation, number of evaluations, and total time spent in that node for all records.
   
   You can verify if your formula is being evaluated as you expect, and can find bottlenecks and use this information to consider more efficient formula structures.
   

]]>