Use value in specific record(s) to set value for all records

tableaucommunity@tableau.com — Fri, 24 Jan 2014 02:36:57 GMT

I'm struggling with doing something that's probably fairly simple.

1. Set the value of a parameter on the Parameter Control (ex. county_parameter = "Gilliam").

2. Find the value of another field ("schema") in my primary database for the records where the "county" field = "Gilliam" (ex. schema=3).

3. Set the value of a third field ("schema2") for ALL RECORDS in the database equal to the value from step 2 above (ex. schema2=3 for all records).

It's steps 2 and 3 that I'm having trouble with. I can't figure out how to reference a specific value from a specific set of records in a calculation that affects all records.

Any suggestions? My primary database looks something like this:

years	county	schema	rate
2005-2009	Gilliam	3	10.8
2006-2010	Gilliam	3	10.6
2007-2011	Gilliam	3	9.9
2005-2009	Polk	1	12.9
2006-2010	Polk	1	12.9
2007-2011	Polk	1	12.7
2005-2009	Sherman	2	21.0
2006-2010	Sherman	2	20.0
2007-2011	Sherman	2	18.6

Content in Tableau Community Forums

Use value in specific record(s) to set value for all records