Difference between revisions of "LatestValues Display External Data Example"
(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...") |
|||
| Line 1: | Line 1: | ||
| + | |||
| + | Consider a LatestValues display that shows the three latest years of housing starts for a couple of states. In this display, each row comes from your housing starts series for that state, and each column is a yearly figure. | ||
| + | |||
| + | If you wanted add a fourth column showing the change from prior year, that's easy because that calculation is available right in the display builder. But suppose you wanted a column to show the difference from a national average? You have the national average data, but it is not a row in the display, nor should it be. To incorporate that data into this display, you would select <b><i>External Data</i></b> from the <b><i>Show</i></b> picklist for your new column. | ||
| + | |||
| + | When you select to <b><i>Show</i></b> <b><i>External Data</i></b>, a box opens up prompting for the name of a Grouplist. We can supply a name like <i>HousingCol4</i> even though we haven't built it yet. | ||
Revision as of 15:14, 24 January 2019
Consider a LatestValues display that shows the three latest years of housing starts for a couple of states. In this display, each row comes from your housing starts series for that state, and each column is a yearly figure.
If you wanted add a fourth column showing the change from prior year, that's easy because that calculation is available right in the display builder. But suppose you wanted a column to show the difference from a national average? You have the national average data, but it is not a row in the display, nor should it be. To incorporate that data into this display, you would select External Data from the Show picklist for your new column.
When you select to Show External Data, a box opens up prompting for the name of a Grouplist. We can supply a name like HousingCol4 even though we haven't built it yet.
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.
