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.
In 1805 William Geddy Sr. along with his son, William, built the structure that is now known as White Hall Tavern on an approximately 326-acre (132 ha) farm. The tavern is located at the intersection of Richmond Road and Old Stage Road in Toano, Virginia, about 15 miles outside of Williamsburg.