Difference between revisions of "ComputeCloud Formula Examples"
From dataZoa Wiki
(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: | ||
| − | === | + | === 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> | + | <tr><td>Simple 10 Point Moving Average</td> |
<td> | <td> | ||
<nowiki>{ | <nowiki>{ | ||
| − | + | 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 }
}
|