Difference between revisions of "Calculated Series"

From dataZoa Wiki
Jump to: navigation, search
(Broken References)
(Formula)
Line 3: Line 3:
 
==Formula==
 
==Formula==
 
<div>
 
<div>
 +
In a calculated series, the formula is the math expression that defines the series.  You can inspect or edit the formula of a series by clicking on the Formula <div class="imgWholeWrap1"><div class="imgWhole " data-guts="{ url: '/img/Retort.png', title: 'Formula icon', xtraStyle: ' min-height: 16px; min-width: 16px;'  }"></div></div> icon next to the series title in the [[Workbench|workbench]].
 
</div>
 
</div>
  

Revision as of 08:28, 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.


Formula

In a calculated series, the formula is the math expression that defines the series. You can inspect or edit the formula of a series by clicking on the Formula
icon next to the series title in the workbench.

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.
In the case where the break is due to a shared series with a revoked permission , the result series has a special title, Removed by Owner (RBO) so that the problem can be corrected by examining the ancestors and restoring permissions.