Difference between revisions of "ComputeCloud Formula Examples"

From dataZoa Wiki
Jump to: navigation, search
(Formulas with just one input Variable:)
(Formulas with just one input Variable:)
Line 2: Line 2:
 
=== Formulas with just one input Variable: ===
 
=== Formulas with just one input Variable: ===
 
<div style="margin:2em; margin-left:6em;">
 
<div style="margin:2em; margin-left:6em;">
<table class="Gbb1" style="width:100%;font-size:smaller; cell-padding: 0.5em;">
+
<table class="Gbb1" style="width:100%;font-size:smaller; cell-padding: 0.5em; line-height: 3.0em;">
 
  <tr>
 
  <tr>
 
   <td style="width:35%;font-size:larger;"><b>Purpose</b></td>
 
   <td style="width:35%;font-size:larger;"><b>Purpose</b></td>
 
   <td style="width:65%;font-size:larger;"><b>Formula</b></td>
 
   <td style="width:65%;font-size:larger;"><b>Formula</b></td>
 
  </tr>
 
  </tr>
  <tr><td>Simple 10 Point Moving Average</td><td><nowiki>Movavg(V1,10)</nowiki></td>
+
  <tr><td>Simple 10 Point Moving Average</td><td>Movavg(V1,10)</td></tr>
</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>
 
</table>
 
</div>
 
</div>

Revision as of 10:57, 24 January 2019

Formulas with just one input Variable:

Purpose Formula
Simple 10 Point Moving AverageMovavg(V1,10)