Difference between revisions of "ComputeCloud Formula Examples"
From dataZoa Wiki
(→Formulas with just one input Variable:) |
(→Formulas with just one input Variable:) |
||
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>Simple 10 Point Moving Average</td><td>Movavg(V1,10)</td> | + | <tr><td>Simple 10 Point Moving Average</td><td><nowiki>Movavg(V1,10)</nowiki></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> | <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> |
Revision as of 10:53, 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 } } |