Thanks Mark. Yeah, storing it as 'tint' would be quite efficient.As i cannot re-index the massive data, please let me know if the changes i make in schema reflect to the already indexed data? I am not sure how type checking happens in solr.
You can then do a facet query, specifying your desired ranges as one facet query for each range. http://wiki.apache.org/solr/SimpleFacetParameters#Facet_by_Range says its not implemented yet. Please let me know if there is any workaround in my case. Thanks, Karthik