* Query results to find percentages?

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile
Post Reply
avatar
E Wilcock
Megastar
Posts: 954
Joined: 11 Oct 2014 07:59
Family Historian: V6.1
Location: London
Contact:

Query results to find percentages?

Post by E Wilcock » 06 Apr 2020 14:26

In the Times today Max Hastings looked at German death rates in World War 2
one in three male children born 1915-1924 is dead
2 in 5 of those born 1920-1925 is dead.

I would like to compare the death rates in my German place projects.

I already have a query for deaths in World War 1 i.e. male deaths within a certain time frame, but how does one compare the number who died with the number who did not? Or does one just run two queries and subtract one total from another?

User avatar
davidf
Superstar
Posts: 352
Joined: 17 Jan 2009 19:14
Family Historian: V6.2

Re: Query results to find percentages?

Post by davidf » 06 Apr 2020 15:10

Evelyn

I have concluded that data analysis is much better done in something like Excel/LibreOffice Calc.

You run a query in FH to extract the population on which you wish to do the analysis and include in that query the required data columns. From the Query Results "Gear Wheel" you can select "Save Results Set as" and select one of the comma separated variable file formats, which most spreadsheets can directly open.

David
David
Running FH 6.2.7. Under Wine on Linux (Lubuntu 18.04 LTS)

User avatar
tatewise
Megastar
Posts: 18173
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: Query results to find percentages?

Post by tatewise » 06 Apr 2020 15:19

David is correct, you cannot produce such totals and compare them in a Query.
You either need to export to a spreadsheet, or write a Plugin.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

avatar
E Wilcock
Megastar
Posts: 954
Joined: 11 Oct 2014 07:59
Family Historian: V6.1
Location: London
Contact:

Re: Query results to find percentages?

Post by E Wilcock » 06 Apr 2020 15:54

Thank you both. We do own Excel but I may resort to a pocket calculator.

Post Reply