create an Average column from a sum and a count in spotfire. I retrieve data from database and the sum and the count are automatically calculated. Something like Select Data, Product, count(*) as Num, sum(cost) as cost from myTable group by Data, Product ...
Aldie, Virginia. Aldie is an unincorporated community located between Chantilly and Middleburg in Loudoun County, Virginia. The eastern part is suburbanized with numerous upscale communities recently built or under construction while most of its western and northern parts have so far largely preserved their bucolic character.
Pearisburg is a town in Giles County, Virginia, United States. The population was 2,729 at the 2000 census. It is the county seat of Giles County. Pearisburg is part of the BlacksburgâChristiansburgâRadford Metropolitan Statistical Area. Pearisburg is located at 37Â°19â²45â³N 80Â°43â²57â³W / 37.32917Â°N 80.7325Â°W / 37.32917; -80.7325 (37.329184, -80.732490).