Difference between revisions of "Calculations"
From dataZoa Wiki
| (46 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | <div class="imgGlyph24 imgConcept"></div> <b><i>Calculations</i></b> are math formulas that derive new [[About_Series|data series]] from other series. | ||
| − | < | + | {{CalculationIllustration}} |
| + | |||
| + | <ul> | ||
| + | <li>Calculations can use other calculated series as inputs</li> | ||
| + | <li>All interdependencies are tracked and re-evaluated as needed</li> | ||
| + | <li>Calculations are <i>stored</i> in your dataZoa account and <i>evaluated</i> in dataZoa's [[About_the_ComputeCloud|ComputeCloud]]</li> | ||
| + | <li>A calculation in dataZoa works just like a cell in a spreadsheet, except that the "cell" contains an entire series!</li> | ||
| + | </ul> | ||
| + | |||
| + | |||
| + | |||
| + | == Creating == | ||
| + | <div> | ||
| + | ==== From the <b>dropZone</b> ==== | ||
| + | <div> | ||
| + | From the [[DZDropzone#Working_with_Series_in_the_dropZone|dropZone]], open the Gear menu, check <i>Pick individual series</i>, select your input series, then pop open <i>Make a ComputeCloud Formula</i>. [[Calculations_in_the_dropZone|See illustrations here]]. | ||
| + | </div> | ||
| + | |||
| + | ==== From the <b>Workbench</b> ==== | ||
| + | <div> | ||
| + | From the [[Workbench|Workbench]], checkbox the series you want to include, then click the <b>+</b> button in the header to pop open the formula editor. [[Calculations_in_the_Workbench|See illustrations here]]. | ||
| + | |||
| + | <div class="imgGlyph24 imgIdea"></div> If you want to build several calculations from the same general group of data, consider using the [[dZCorkboard]]. | ||
| + | </div> | ||
| + | </div> | ||
| + | |||
| + | == Editing == | ||
| + | <div> | ||
| + | {{Template:Calculation_Editing|Editing}} | ||
| + | </div> | ||
| + | |||
| + | == Sharing == | ||
| + | <div> | ||
| + | The result of a Calculation is a distinct data series, which can be [[About_Series#Sharing|shared]] like any other as you see fit. | ||
| + | </div> | ||
| + | |||
| + | == Deleting == | ||
| + | <div> | ||
| + | The result of a Calculation is a distinct data series, which can be [[About_Series#Deleting|deleted]] like any other series, however: | ||
| + | |||
| + | <div class="imgGlyph24 imgWarning"></div> If the series being deleted has any [[Calculated_Series#Descendants|descendants]], they will be invalidated. | ||
| + | |||
| + | </div> | ||
| + | |||
| + | [[Category:Definitions]] | ||
| + | [[Category:Calculations]] | ||
| + | [[Category:Examples]] | ||
| + | [[Category:Advanced]] | ||
| + | [[Category:Intermediate]] | ||
| + | [[Category:Editing]] | ||
| + | [[Category:How_To]] | ||
| + | [[Category:Compute]] | ||
Latest revision as of 14:12, 22 October 2020
Calculations are math formulas that derive new data series from other series.|
Immensely powerful, |
 |
- Calculations can use other calculated series as inputs
- All interdependencies are tracked and re-evaluated as needed
- Calculations are stored in your dataZoa account and evaluated in dataZoa's ComputeCloud
- A calculation in dataZoa works just like a cell in a spreadsheet, except that the "cell" contains an entire series!
Contents
Creating
From the dropZone
From the dropZone, open the Gear menu, check Pick individual series, select your input series, then pop open Make a ComputeCloud Formula. See illustrations here.
From the Workbench
From the Workbench, checkbox the series you want to include, then click the + button in the header to pop open the formula editor. See illustrations here.
If you want to build several calculations from the same general group of data, consider using the dZCorkboard.Editing
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
Formula
Inputs Section
| The Series you checked are the inputs to your Formula: |  |
Formula Section
| Use V1, V2, etc. as your formula variables: |  |
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: |  |
Tab: Options (Advanced)
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.
Sharing
The result of a Calculation is a distinct data series, which can be shared like any other as you see fit.
Deleting
The result of a Calculation is a distinct data series, which can be deleted like any other series, however:
If the series being deleted has any descendants, they will be invalidated.
