LatestValues Display External Data Example - Revision history

SNC at 22:25, 24 January 2019

2019-01-24T22:25:12Z

SNC at 22:14, 24 January 2019

2019-01-24T22:14:31Z

SNC: 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..."

2019-01-24T21:57:19Z

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..."

New page

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]]

@@ 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.
+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.  Let's say the rows are for series named <i>AlabamaStarts</i> and <i>AlaskaStarts</i>
-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.
+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 (unrelated but relevant) state populations instead? You have the population data you need in your Workbench, but it is not any part of the display, nor should it be, really.  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.
+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 [[GroupLists|Grouplist]].  We can supply a name like <i>HousingLV_PopColumn</i> even though we haven't built it yet.

← Older revision	Revision as of 22:14, 24 January 2019
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.