Quote:
Originally Posted by ownedbycats
EDIT: I also noticed this when using first-letter partitioning and I was half-hoping that this might also be a way to partition this by century or decade 
Attachment 182700 |
I thought I understood what you wanted until you made the edit. Are you asking to partition by arbitrary values depending on the category? It seems that you want to sometimes partition by multiple first letters if the number of items in the category is "small", and sometimes partition by something else (e.g., decades or 2 first letters). I think this might end up as specifying DWIM (Do What I Mean).
I might be able to add partitioning first letters, combining first letters to ensure that the number of items in the combination is at least X, giving what you suggested in your fourth paragraph. Your edit suggests doing different combinations depending on the field, which I am not willing to attempt.
If 'Year Published' is a composite column then I think you can solve your problem by making it hierarchical with the first level being the first 3 digits of the year followed by a zero, then '.' then the actual year. Examples: 2010.2015, 2010.2018, 2000.2006.