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.
Ann (Blackwell) Pickett abt 1747 Prince William, Virginia - abt 1800 managed by John Drinkwater. Letitia (Blackwell) Chilton 03 Oct 1750 Fauquier, Virginia, USA - 09 Dec 1775 managed by John Chilton. John P. Blackwell 1817 Rutherford County, North Carolina, USA managed by Elizabeth Winter. Nancy (Blackwell) Runyon 25 Mar 1781 Albemarle, Virginia, United States - 26 Apr 1839 managed by Nic Grabien last edited 11 Apr 2017.