Tell me more ×
Cross Validated is a question and answer site for statisticians, data analysts, data miners and data visualization experts. It's 100% free, no registration required.
up vote 0 down vote favorite

I'm not sure what a more precise title could be. I have daily data incoming in which I want to total occurrences of a type. E.G today produced 

Abc 20 times
Bca 19 times
Cab 13 times

Etc. I'm interested in querying this data grouped by an arbitrary time span, for example "total Abc's in January". Is there a way to preprocess this data to make those lookups more efficient?

I feel that with large tables the naïve approach could be slow...

share|improve this question

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.