1 Topic by DGERC

  • DGERC
  • DGERC
  • Veteran
  • Offline
  • From: SWSEIC
  • Registered: 31-05-2006
  • Posts: 232

Topic: Summary statistics

I would like to pull out some simple summary statistics from our R6 database - a report summarising the number of taxa recorded in each tetrad (and another report producing the same by hectad too). Rather than re-invent the wheel, does anyone have a report(s) that do this already?

MARK

Mark Pollitt
SWSEIC (formerly DGERC)

DGERC's Website

2 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,625

Re: Summary statistics

This report, says it will do what you will require, but I haven't tested it and for some reason it hasn't been included  as System Supplied, although that must have been the intention when it was written

Post's attachments

JNCC_Sq7_Taxon_RecordedByGridSquare.xml 2.37 kb, 7 downloads since 2014-12-08 

You don't have the permssions to download the attachments of this post.
Mike Weideli

MikeWeideli's Website

3 Reply by DGERC

  • DGERC
  • DGERC
  • Veteran
  • Offline
  • From: SWSEIC
  • Registered: 31-05-2006
  • Posts: 232

Re: Summary statistics

Heading in the right direction, but the results seem to show the number of records rather than number of species. Will take a look at the code as it must be somewhere near though...

MARK

Mark Pollitt
SWSEIC (formerly DGERC)

DGERC's Website

4 Reply by DGERC

  • DGERC
  • DGERC
  • Veteran
  • Offline
  • From: SWSEIC
  • Registered: 31-05-2006
  • Posts: 232

Re: Summary statistics

Ah, seems like tweaking the COUNT to COUNT(DISTINCT...  is all it will take. I'm just doing some checks but that should work fine.

Thanks as ever Mike

MARK

Mark Pollitt
SWSEIC (formerly DGERC)

DGERC's Website