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.
While both served as Governor of Virginia, they lived in Charlottesville, and traveled to and from Richmond, along the 71-mile (114 km) historic Three Notch'd Road. Orange, located 26 miles (42 km) northeast of the city, was the hometown of President James Madison. The University of Virginia, one of the original Public Ivies, straddles the city's southwestern border with Albemarle. Monticello, located 3 miles (4.8 km) southeast of the city, is a UNESCO World Heritage Site. Located on a hilltop overlooking Charlottesville, Monticello attracts thousands of tourists each year.