Difference between revisions of "Calculated Series"

From dataZoa Wiki
Jump to: navigation, search
(Parents)
 
(3 intermediate revisions by the same user not shown)
Line 2: Line 2:
 
<br>
 
<br>
  
<div class="imgGlyph24 imgHowTo"></div> Calculated series have all the normal properties of a data series, plus a few special ones.<br>
+
<div class="imgGlyph24 imgHowTo"></div> Calculated series have all the normal attributes of a data series, plus a few special ones.<br>
  
 
<table class="GTableTextPic">
 
<table class="GTableTextPic">
 
<tr>
 
<tr>
 
<td>
 
<td>
In the [[Workbench|workbench]], use 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 title of a calculated series to pop up these <b>Calculated Series</b> properties:
+
In the [[Workbench|workbench]], use 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 title of a calculated series to pop up these <b>Calculated Series Attributes:</b>
 
</td>
 
</td>
 
<td>
 
<td>
Line 17: Line 17:
 
<tr>
 
<tr>
 
<td></td>
 
<td></td>
<td>Click on the blue links in this panel to drill-down for further property details.</td>
+
<td>Click on the blue links in this panel to drill-down for further attribute details.</td>
 
</tr>
 
</tr>
 
</table>
 
</table>
Line 24: Line 24:
 
==Formula==
 
==Formula==
 
<div>
 
<div>
The formula property is simply the math expression that defines the series.  You can edit the formula from this link.
+
The formula atribute is simply the math expression that defines the series.  You can edit the formula from this link.
 
<br>
 
<br>
 
<div class="imgGlyph24 imgHowTo"></div> You can use the formula editor to change the series title as well.
 
<div class="imgGlyph24 imgHowTo"></div> You can use the formula editor to change the series title as well.
Line 48: Line 48:
 
==Children==
 
==Children==
 
<div>
 
<div>
 +
<i>Children</i> refers to the series that use this series as a direct input to their own formula.  Children are by definition calculated series themselves.
 +
<br>
 +
When you click on the word <b><i>Children</i></b>, the titles of all the formula's child series are listed.  Clicking on any of those titles shows deeper information about that child, such as its series key, owner, sharing status, and lists <i>its</i> parents and children, if any.
 
</div>
 
</div>
  
 
===All Descendants===
 
===All Descendants===
 
<div>
 
<div>
 +
<i>Descendants</i> refers to all series that depend in any way on this series. 
 
</div>
 
</div>
  
 
===Descendants' Order of Evaluation===
 
===Descendants' Order of Evaluation===
 
<div>
 
<div>
 +
This list may be useful in troubleshooting complex inter-dependencies.
 
</div>
 
</div>
  
 +
<div class="imgGlyph24 imgNote"></div> Children and descendants are <i>attributes</i> of the calculated series, but not part of its <i>definition</i>.
  
 
== <div class="imgGlyph24 imgWarning"></div> Circular References==
 
== <div class="imgGlyph24 imgWarning"></div> Circular References==
Line 74: Line 80:
 
In the case where the break is due to a shared series with a revoked permission , the result series has a special title, <i>Removed by Owner</i> (RBO) so that the problem can be corrected by examining the ancestors and restoring permissions.
 
In the case where the break is due to a shared series with a revoked permission , the result series has a special title, <i>Removed by Owner</i> (RBO) so that the problem can be corrected by examining the ancestors and restoring permissions.
 
</div>
 
</div>
 +
 +
<div class="imgGlyph24 imgNote"></div> Note that for simplicity, <i>calculated series</i>, <i>parents</i>, <i>children</i>, <i>ancestors</i> and <i>descendants</i> are sometimes referred to simply as <b><i>nodes</i></b>.
  
 
[[Category:Definitions]]
 
[[Category:Definitions]]
 
[[Category:Intermediate]]
 
[[Category:Intermediate]]
 
[[Category:Calculations]]
 
[[Category:Calculations]]
[[Category:Provisional]]
 

Latest revision as of 10:45, 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.


Calculated series have all the normal attributes of a data series, plus a few special ones.
In the workbench, use the Formula
icon next to the title of a calculated series to pop up these Calculated Series Attributes:
Formula Properties
Click on the blue links in this panel to drill-down for further attribute details.


Formula

The formula atribute is simply the math expression that defines the series. You can edit the formula from this link.

You can use the formula editor to change the series title as well.

Parents

Parents refers to the series that are direct inputs to the formula. Parents may be calculated series themselves or simply ordinary series.
When you click on the word Parents the titles of all the formula's parent series are listed. Clicking on any of those titles shows deeper information about that parent, such as its series key, owner, sharing status, and lists its parents and children, if any.

All Ancestors

Ancestors refers to the series that are direct or indirect inputs to the formula.

Ancestors' Order of Evaluation

This list may be useful in troubleshooting complex inter-dependencies.

Children

Children refers to the series that use this series as a direct input to their own formula. Children are by definition calculated series themselves.
When you click on the word Children, the titles of all the formula's child series are listed. Clicking on any of those titles shows deeper information about that child, such as its series key, owner, sharing status, and lists its parents and children, if any.

All Descendants

Descendants refers to all series that depend in any way on this series.

Descendants' Order of Evaluation

This list may be useful in troubleshooting complex inter-dependencies.

Children and descendants are attributes of the calculated series, but not part of its definition.

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.

Note that for simplicity, calculated series, parents, children, ancestors and descendants are sometimes referred to simply as nodes.