Difference between revisions of "ComputeCloud Formula Examples"

From dataZoa Wiki
Jump to: navigation, search
(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;"...")
 
Line 1: Line 1:
  
=== Simple Examples: ===
+
=== 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;">
 
<table class="Gbb1" style="width:100%;font-size:smaller;">
Line 7: Line 7:
 
   <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>Enable crosshairs on hover for: <i>[x-axis, y-axis]</i></td>
+
  <tr><td>Simple 10 Point Moving Average</td>
 
   <td>
 
   <td>
 
  <nowiki>{
 
  <nowiki>{
   tooltip: { crosshairs:[false, true] }
+
   Movavg(V1,10)
 
}</nowiki>
 
}</nowiki>
 
   </td>
 
   </td>

Revision as of 10:48, 24 January 2019

Formulas with just one Input Variable:

Purpose Formula
Simple 10 Point Moving Average
{
   Movavg(V1,10)
}
Set tooltip prefix, suffix, decimals and date format (%B= Month full name, %b = Month abbreviation, %m = Month number, %d = Day number, %Y = 4 digit year, %y = 2 digit year).
{
   tooltip: { valuePrefix:'$', valueSuffix:' USD', valueDecimals:2, xDateFormat:'%b-%d-%Y' }
}
Separate tooltips for each series displayed one-at-a-time (e.g. for whichever series is being hovered over).
{
   tooltip: { shared:false }
}
Separate tooltips foe each series displayed simultaneously.
{
   tooltip: { split:true }
}