Difference between revisions of "LatestValues Display External Data Example"
From dataZoa Wiki
(Created page with " 1) Use the compute cloud to create one single point calculated series from the raw data for each row. For example, for an average of the latest 3 points the formula would b...") |
(No difference)
|
Revision as of 14:57, 24 January 2019
1) Use the compute cloud to create one single point calculated series from the raw data for each row. For example, for an average of the latest 3 points the formula would be "v1-v1+mean(extract(V1,length(V1)-2,3))" and the label might be "GDPAvg3"
2) When you have a single point series for each row, put them all into a GroupList and order them to match the order of the display. Give it a name like "MyAvg3"
3) In the Latest Values display, add a column and set its "Show" field to "External Data" and supply the name of your new GroupList.