DatasetMetrics.countByKingdom and countByVernacularNameLanguage need to be calculated and stored for checklists

11666
Reporter: mdoering
Assignee: mdoering
Type: Improvement
Summary: DatasetMetrics.countByKingdom and countByVernacularNameLanguage need to be calculated and stored for checklists
Description: These 2 DatasetMetrics properties are empty right now but needed on the new species search home page. Extend the post checklist import metrics generation and store them in the checklist table - or consider a new more generic metrics table for checklists?
Priority: Major
Resolution: Fixed
Status: Closed
Created: 2012-08-09 14:08:35.617
Updated: 2013-12-09 13:41:03.601
Resolved: 2012-12-12 15:02:19.229

Author: trobertson@gbif.org
Created: 2012-11-21 10:35:30.682
Updated: 2012-11-21 10:35:30.682
        
CountByKingdom can be populated for occurrence datasets using the cube.
CountByVernacularName cannot for occurrence datasets
    

Author: mdoering@gbif.org
Created: 2012-12-12 15:02:19.253
Updated: 2012-12-12 15:02:19.253
        
Solved by dynamic queries, not any new metrics fields in clb. Queries get a bit slow, but should be cached by varnish very quickly.

http://code.google.com/p/gbif-ecat/source/detail?r=5342
http://code.google.com/p/gbif-ecat/source/detail?r=5343