View source for LatestValues Display External Data Example



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.  

[[Category:Advanced]][[Category:Calculations]][[Category:How_To]]