Potential improvements to facet-by-date

[simonw]

In addition to #483 Tobias had some useful suggestions on Twitter:

https://twitter.com/rixxtr/status/1148253926476701696

I think for date facets, it might be more meaningful to order them by date, rather than by size? Or offer both? I'm definitely often interested in size-over-time, so https://data.rixx.de/django_tickets/tickets?_facet_date=created#facet-created … isn't all that helpful!

Screenshot of that link:

[simonw]

One thing that's clear is I need to add a demo to the fixtures that illustrates the feature, ideally with a thousand generated rows in it to give a better example of how it works.

[simonw]

My reply on Twitter:

https://twitter.com/simonw/status/1148254258900262913

Huh I hadn't thought about order-by-date - that's really useful. Not sure what I'll do for data that's spread over e.g. 1,000 days (other facets only return up to 30 data points right now) - maybe 30 most recent plus a link to view more than that?

[simonw]

Having a "more link" is very interesting. I could do that by generating a custom SQL query link, but that wouldn't play well in instances that disable custom SQL.

This may be a case where a new URL is needed under the proposed /database/table/-/namespace namespace - #296

Compatibility with datasette-vega is useful, since then anyone can get a chart by starting with a facet of some sort.

[maxwelljoslyn]

I know this is an old issue, but as a casual Datasette user for things like inspecting the logs from your LLM tool, it would be quite useful for me to be able to sort responses by date. I was surprised it wasn't an option already, to be honest. unless I'm missing something?

EDIT: Never mind, I was able to get what I wanted by editing the generated SQL. I guess this issue is about faceting specifically. My bad!

Keep doing great work. I love all your tools and use several of them on a daily basis.