issues: 847700726

This data as json

id node_id number title user state locked assignee milestone comments created_at updated_at closed_at author_association pull_request body repo type active_lock_reason performed_via_github_app reactions draft state_reason
847700726 MDU6SXNzdWU4NDc3MDA3MjY= 1285 Feature Request or Plugin Request: Numeric Range Facets 192568 open 0     0 2021-04-01T01:50:20Z 2021-04-01T02:28:19Z   CONTRIBUTOR  

It would be great to offer facets for numeric data ranges.

The ranges could pull from typical GIS methods of creating choropleth maps. https://gisgeography.com/choropleth-maps-data-classification/ Of the following, for mapping, I've always preferred a Jenks Natural Breaks, or a cross between Jenks and Pretty breaks.

  • Equal Intervals
  • Quantile (equal count)
  • Standard Deviation
  • Natural Breaks (Jenks) Classification
  • Pretty Breaks
  • Some sort of Aggregate Jenks Classification (this isn't standard, but it would be nice to be able to set classification ranges that work across tables.)

Here are some links for Natural Breaks, in case this method is unfamiliar.

Per that last link, there is a Jenks Python module... They also describe it as data-intensive for larger datasets. Maybe this is a good plugin idea.

An example of equal Intervals would be 0 – < 10 10 – < 20 20 – < 30 30 – < 40

It's kind of confusing to have that less-than sign in there. it could also be displayed as: 0 – 10 10 – 20 20 – 30 30 – 40

But then it's not completely clear which category 10 is in, for instance.

(Best to right-justify.. and use an "en dash" between numbers.)

 107914493 issue     
{
    "url": "https://api.github.com/repos/simonw/datasette/issues/1285/reactions",
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
    

Links from other tables