Difference between revisions of "Calculated Series"
| Line 1: | Line 1: | ||
<div class="imgGlyph24 imgConcept"></div> A Calculated Series works like any other [[About_Series|data series]] in dataZoa, but rather than holding raw numbers, its contents are mathematically derived from other series. | <div class="imgGlyph24 imgConcept"></div> A Calculated Series works like any other [[About_Series|data series]] in dataZoa, but rather than holding raw numbers, its contents are mathematically derived from other series. | ||
| − | + | <br> | |
==Formula== | ==Formula== | ||
<div> | <div> | ||
| Line 31: | Line 31: | ||
| − | ==Circular References== | + | == <div class="imgGlyph24 imgWarning"></div> Circular References== |
| + | <div> | ||
| + | A <i>circular reference</i> is a formula that uses any of its descendants as an ancestor, which is an error. | ||
| + | |||
| + | When a circular reference is discovered as the formula is being created, it is flagged and rejected immediately. More subtly, a formula can become circular <i>after</i> it is created. When this happens, the result series from the formula is invalidated and marked with an error message in the series title. | ||
| + | </div> | ||
| + | |||
| + | == <div class="imgGlyph24 imgWarning"></div> Broken References== | ||
<div> | <div> | ||
| + | A <i>broken reference</i> is a formula where one or more ancestors becomes unavailable. This can happen when the ancestor is deleted, invalid, or relies on shared data whose access has been revoked. | ||
| + | <br> | ||
| + | When a broken reference is encountered, the result series from the formula is invalidated and marked with an error message in the series title. | ||
</div> | </div> | ||
| − | [[Category: | + | [[Category:Definitions]] |
| + | [[Category:Intermediate]] | ||
| + | [[Category:Calculations]] | ||
| + | [[Category:Provisional]] | ||
Revision as of 08:19, 23 February 2017
A Calculated Series works like any other data series in dataZoa, but rather than holding raw numbers, its contents are mathematically derived from other series.
Contents
Formula
Parents
All Ancestors
Ancestors' Order of Evaluation
Children
All Descendants
Descendants' Order of Evaluation
Circular References
A circular reference is a formula that uses any of its descendants as an ancestor, which is an error.
When a circular reference is discovered as the formula is being created, it is flagged and rejected immediately. More subtly, a formula can become circular after it is created. When this happens, the result series from the formula is invalidated and marked with an error message in the series title.
Broken References
A broken reference is a formula where one or more ancestors becomes unavailable. This can happen when the ancestor is deleted, invalid, or relies on shared data whose access has been revoked.
When a broken reference is encountered, the result series from the formula is invalidated and marked with an error message in the series title.
