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.
23524 WHITEHEART HICKORY LN is a house in Aldie, VA 20105. This property last sold for $794,182. Based on Redfin's Aldie data, we estimate the home's value is now $819,109, which is 3.1% more than when it was last sold. Comparable nearby homes include 23813 Weathervane Pl, 41840 Bloomfield Path St, and 40631 Blue Beech Ln.