Difference between revisions of "Template:Calculation Editing"

From dataZoa Wiki
Jump to: navigation, search
(Formula Section)
Line 22: Line 22:
 
<td>Use <b>V1, V2,</b> etc. as your formula variables:</td><td><div  class="imgSnippetWrap1"><div class="Gdib">[[File:CalculationFormula.PNG|none|Calculation Formula]]</div></div></td>
 
<td>Use <b>V1, V2,</b> etc. as your formula variables:</td><td><div  class="imgSnippetWrap1"><div class="Gdib">[[File:CalculationFormula.PNG|none|Calculation Formula]]</div></div></td>
 
</tr></table>
 
</tr></table>
 +
 +
<div>
 +
By their very nature, Cacluation 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].
 +
* Nothing teaches quite like examples. See some here[[ComputeCloud_Formula_Examples|here]].
 +
</div>
 +
 
</div>
 
</div>
  

Revision as of 11:37, 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, Cacluation 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 herehere.

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.