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.
Homefacts City Report. Aldie is located in Loudoun County, VA. The population is NR. There are 6 public schools in Aldie with an average Homefacts rating of A-. The total crime rate for Aldie is very low, and there are 6 registered sex offenders residing in the city. Unemployment in Aldie is low and the median home sales price is $425,000.