From: Doug B. <dou...@gm...> - 2011-11-17 11:29:39
|
On Thu, Nov 17, 2011 at 4:06 AM, Benny Malengier <ben...@gm...> wrote: > You would need some code to do this. > > Some options: > > 1/open the top surnames gramplet and safe it as a new gramplet. Your idea of > frequency of first names would be a great new gramplet. Also as a new report > type this is interesting There is a Given name Cloud Gramplet that already does much of what you would need. -Doug > 2/If you want to avoid learning a bit of the internals of Gramps, then you > can use spreadsheet. This goes as follows: > Via the Preferences->Display, set the name type to Given, so that only the > first name shows in the person views. Then go the flat person view (so not > grouped per surname), via the configuration make first name and birth date > the first columns, sort on first name (click on column header) and export to > a csv file using the menu option Family Tree->Export View, which you open in > a spreadsheet (if you have LibreOffice you can directoy export the view as > an opendocument spreadsheet, which is faster). Then use the spreadsheet > functions to calculate and plot the frequencies. So, a function to add a > column with the number of equal names in column 1 would be: > =COUNTIF(A1:A955, A1) > and then copy this formula from the first row down to the last by selecting > and dragging it down. > This gives you a column with the frequency, then you remove duplicate rows > and insert eg a pie chart with this frequency. I'm not a spreadsheet guru, > for frequency per time period, writing it as a gramplet would be faster for > me :-) > > The second is fastest if you need a quick idea. The first is best to share > with the Gramps community and make it really usefull with some options. > > Greetings, > Benny > > 2011/11/15 Bobby Singh <b_b...@ya...> >> >> Hello There, >> I am trying to solve two problems and perhaps the list already knows a >> solution. >> a) If I want to get a frequency of first names in a database how can I >> do this? >> b) If I want to get the same statistics as in a) but generation by >> generation starting from the youngest to the oldest generation how would I >> do this? >> >> Thanks and Regards, >> -Bobby >> >> ------------------------------------------------------------------------------ >> RSA(R) Conference 2012 >> Save $700 by Nov 18 >> Register now >> http://p.sf.net/sfu/rsa-sfdev2dev1 >> _______________________________________________ >> Gramps-users mailing list >> Gra...@li... >> https://lists.sourceforge.net/lists/listinfo/gramps-users >> > > > ------------------------------------------------------------------------------ > All the data continuously generated in your IT infrastructure > contains a definitive record of customers, application performance, > security threats, fraudulent activity, and more. Splunk takes this > data and makes sense of it. IT sense. And common sense. > http://p.sf.net/sfu/splunk-novd2d > _______________________________________________ > Gramps-users mailing list > Gra...@li... > https://lists.sourceforge.net/lists/listinfo/gramps-users > > |