I know this has been hashed over in the previous forums., And it has been patched in the existing reporting to give proper species counts in the report heading. And I know Jeff is quite aware of the issue. I thought it should be here for discussion anyway.
As it exists (3.6), reporting counts birds, not species. Use the Group By option for a report column and you can choose "Sightings Recorded", but if the data being summarized has the same species multiple times (say at multiple locations within a day) then the subtotals count each record. That is a valuable option to have, but an option of "Species Recorded" is what I usually prefer.
For the SQL literate, I want COUNT(distinct Species) at each level of summation. That does NOT simply sum up, it has to be calculated at each level.
While I am complicating things, let me add that at any given level of summary we can currently pick "Sightings Recorded", "Max Observed", or "Min Observed". Besides adding "Species Recorded", I think it would be advantagous to allow MORE THAN ONE such "sum" or "count". It would be nice to see, in one report, both species and sightings, and anyone who really uses the min and max count fields would probably appreciate being able to see both of them.
|