Difference between revisions of "Template:Calculation Editing"

From dataZoa Wiki
Jump to: navigation, search
(Formula Section)
(Formula Section)
Line 24: Line 24:
  
 
<div style="margin-bottom: 2em;">
 
<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, 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 [https://www.datazoa.com/doc/dataZoaComputeCloudReference_v2.2.pdf here].
+
* The dataZoa '''ComputeCloud Reference''' documents all of the intrinsic functions and arguments that can be used in Formulas. Download it [https://www.datazoa.com/doc/dataZoaComputeCloudReference_v2.2.pdf here].
* Nothing teaches quite like examples. See some [[ComputeCloud_Formula_Examples|here]].
+
* Nothing teaches quite like examples. See some [[ComputeCloud_Formula_Examples|ComputeCloud Formula Examples here]].
 
</div>
 
</div>
  

Revision as of 11:42, 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, 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. Download it here.
  • Nothing teaches quite like examples. See some ComputeCloud Formula Examples 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.