Difference between revisions of "Template:Calculation Editing"

From dataZoa Wiki
Jump to: navigation, search
(Formula Section)
(Formula Section)
Line 23: Line 23:
 
</tr></table>
 
</tr></table>
  
<div style="margin-left: 3em;">
+
<div style="margin-bottom: 2em;">
 
By their very nature, Calcuation Formulas are an open-ended topic.  These are excellent points of departure:
 
By their very nature, Calcuation Formulas are an open-ended topic.  These are excellent points of departure:
  

Revision as of 11:39, 24 January 2019

To edit an existing calculation, use the dropZone or Workbench.

Your calculated series are marked with a blue formula flask. When you hover on the series and click on its flask
you get a menu with several calculation options. The first one opens the formula editor with the formula and setting for the calculation being edited.


Tab:
Formula

Inputs Section

The Series you checked are the inputs to your Formula:
Calculation Inputs

Formula Section

Use V1, V2, etc. as your formula variables:
Calculation Formula

By their very nature, Calcuation Formulas are an open-ended topic. These are excellent points of departure:

  • The dataZoa ComputeCloud Reference documents all of the intrinsic functions and arguments that can be used in Formulas. Downloasd it here.
  • Nothing teaches quite like examples. See some here.

Buttons Section

Use these buttons to test and finally save your Formula:
Calculation Buttons

Tab:
Options (Advanced)

These options are used to override the natural default behaviors for NA handling and the padding/trimming of series that do not start and end at the same point in time.