ComputeCloud Formula Examples - Revision history

SNC at 19:31, 24 January 2019

2019-01-24T19:31:05Z

SNC at 19:26, 24 January 2019

2019-01-24T19:26:16Z

SNC: /* Formulas with just one input Variable: */

2019-01-24T19:09:20Z

‎Formulas with just one input Variable:

SNC: /* Formulas with just one input Variable: */

2019-01-24T19:01:36Z

‎Formulas with just one input Variable:

SNC: /* Formulas with just one input Variable: */

2019-01-24T18:57:34Z

‎Formulas with just one input Variable:

SNC: /* Formulas with just one input Variable: */

2019-01-24T18:53:57Z

‎Formulas with just one input Variable:

SNC: /* Formulas with just one input Variable: */

2019-01-24T18:50:23Z

‎Formulas with just one input Variable:

SNC: /* Formulas with just one Input Variable: */

2019-01-24T18:49:32Z

‎Formulas with just one Input Variable:

SNC at 18:48, 24 January 2019

2019-01-24T18:48:20Z

SNC: Created page with " === Simple Examples: ===

2019-01-24T18:45:59Z

Created page with " === Simple Examples: === <div style="margin:2em; margin-left:6em;"> <table class="Gbb1" style="width:100%;font-size:smaller;"> <tr> <td style="width:35%;font-size:larger;"..."

New page

=== Simple Examples: ===
<div style="margin:2em; margin-left:6em;">
<table class="Gbb1" style="width:100%;font-size:smaller;">
<tr>
<td style="width:35%;font-size:larger;"><b>Purpose</b></td>
<td style="width:65%;font-size:larger;"><b>Formula</b></td>
</tr>
<tr><td>Enable crosshairs on hover for: <i>[x-axis, y-axis]</i></td>
<td>
<nowiki>{
tooltip: { crosshairs:[false, true] }
}</nowiki>
</td>
</tr>
<tr><td>Set tooltip prefix, suffix, decimals and date format (<i>%B= Month full name, %b = Month abbreviation, %m = Month number, %d = Day number, %Y = 4 digit year, %y = 2 digit year</i>).</td>
<td>
<nowiki>{
tooltip: { valuePrefix:'$', valueSuffix:' USD', valueDecimals:2, xDateFormat:'%b-%d-%Y' }
}</nowiki>
</td>
</tr>
<tr><td>Separate tooltips for each series displayed one-at-a-time (e.g. for whichever series is being hovered over).</td>
<td>
<nowiki>{
tooltip: { shared:false }
}</nowiki>
</td>
</tr>
<tr><td>Separate tooltips foe each series displayed simultaneously.</td>
<td>
<nowiki>{
tooltip: { split:true }
}</nowiki>
</td>
</tr>
</table>
</div>

← Older revision		Revision as of 19:31, 24 January 2019
Line 17:		Line 17:
	</table>		</table>
	</div>		</div>
		+	[[Category:Calculations]][[Category:Creating]][[Category:Advanced]]

@@ Line 4: / Line 4: @@
 <table class="Gbb1" style="width:100%;font-size:smaller; cell-padding: 0.5em; line-height: 3.0em;">
   <tr>
-   <td style="width:25%;font-size:larger;"><b>Purpose</b></td>
+   <td style="width:20%;font-size:larger;"><b>Purpose</b></td>
-   <td style="width:35%;font-size:larger;"><b>Formula</b></td>
+   <td style="width:30%;font-size:larger;"><b>Formula</b></td>
-   <td style="width:40%;font-size:larger;"><b>Notes</b></td>
+   <td style="width:50%;font-size:larger;"><b>Notes</b></td>
   </tr>
   <tr><td>Simple 10 Point Moving Average</td><td>Movavg(V1,10)</td></tr>
@@ Line 13: / Line 13: @@
   <tr><td>Percent Change</td><td>Index(v1)-100</td><td></td></tr>
   <tr><td>Convert to Quarterly</td><td>SetFreq(V1, 'Quarterly', 'Avg', 'PrecAuto', 'Trim')</td><td>Many details to consider in Periodicity conversions!</td></tr>
-  <tr><td>Replicate a series but with a constant value</td><td>(v1-v1)+3.14159</td><td>Subtracting V1 from itself gives a series with all zeroes but preserving the Periodicity and dates.</td></tr>
+  <tr><td>Replicate a series but with a constant value</td><td>(v1-v1)+3.14159</td><td>Subtracting V1 from itself gives a series with all zeroes but preserves the Periodicity and dates.</td></tr>
-  <tr><td>Average just the latest 10 points of a Series</td><td>v1-v1+mean(extract(V1,length(V1)-9,10))</td><td>Makes a single point series.</td></tr>
+  <tr><td>Average just the latest 10 points of a Series</td><td>v1-v1+mean(extract(V1,length(V1)-9,10))</td><td>Preserves Periodicity and dates.</td></tr>
-</table>
+ </table>
 </div>

@@ Line 1: / Line 1: @@
-=== Formulas with just one input Variable: ===
+=== Formulas with just one input Variable <i>V1</i>: ===
 <div style="margin:2em; margin-left:6em;">
 <table class="Gbb1" style="width:100%;font-size:smaller; cell-padding: 0.5em; line-height: 3.0em;">
   <tr>
-   <td style="width:35%;font-size:larger;"><b>Purpose</b></td>
+   <td style="width:25%;font-size:larger;"><b>Purpose</b></td>
-   <td style="width:65%;font-size:larger;"><b>Formula</b></td>
+   <td style="width:35%;font-size:larger;"><b>Formula</b></td>
   </tr>
   <tr><td>Simple 10 Point Moving Average</td><td>Movavg(V1,10)</td></tr>
-  <tr><td>Remove Mean</td><td>V1-Mean(V1)</td></tr>
+  <tr><td>Remove Mean</td><td>V1-Mean(V1)</td><td></td></tr>
-  <tr><td>Index to 100</td><td>Index(V1)</td></tr>
+  <tr><td>Index to 100</td><td>Index(V1)</td><td></td></tr>
-  <tr><td>Percent Change</td><td>Index(v1)-100</td></tr>
+  <tr><td>Percent Change</td><td>Index(v1)-100</td><td></td></tr>
-  <tr><td>Convert to Quarterly</td><td>SetFreq(V1, 'Quarterly', 'Avg', 'PrecAuto', 'Trim')</td></tr>
+  <tr><td>Convert to Quarterly</td><td>SetFreq(V1, 'Quarterly', 'Avg', 'PrecAuto', 'Trim')</td><td>Many details to consider in Periodicity conversions!</td></tr>
 </table>
 </div>

@@ Line 8: / Line 8: @@
   </tr>
   <tr><td>Simple 10 Point Moving Average</td><td>Movavg(V1,10)</td></tr>
 </table>
 </div>

@@ Line 1: / Line 1: @@
-=== Formulas with just one Input Variable: ===
+=== Formulas with just one input Variable: ===
 <div style="margin:2em; margin-left:6em;">
 <table class="Gbb1" style="width:100%;font-size:smaller;">
@@ Line 7: / Line 7: @@
    <td style="width:65%;font-size:larger;"><b>Formula</b></td>
   </tr>
-  <tr><td>Simple 10 Point Moving Average</td>
+  <tr><td>Simple 10 Point Moving Average</td><td>Movavg(V1,10)</td>
-  <td>
- <nowiki>{
-   Movavg(V1,10)
-}</nowiki>
-  </td>
   </tr>
   <tr><td>Set tooltip prefix, suffix, decimals and date format (<i>%B= Month full name, %b = Month abbreviation, %m = Month number, %d = Day number, %Y = 4 digit year, %y = 2 digit year</i>).</td>