Turn [count] into a cog action menu item, add more

[simonw]

Borrow the cog action menu design from Datasette. Actions can include:

• Count values (the existing "count" link)
• Sum / Avg / etc (for columns that are numbers)
• Show not-null values

[MoralCode]

sort by ascending/descending might be useful to add to a menu like this as well

[simonw]

Yes, that's a great idea.

[simonw]

Here's what I implemented to start with:

[MoralCode]

small nitpick: a settings icon may not be the most correct thing to use here and something that looks more like a filter or funnel may be a better choice to make the UI super clear

[simonw]

I'm using the same icon I used for Datasette, see simonw/datasette#981 (comment).

I thought about using a filter/funnel icon but those to me imply tools for narrowing down the selection, which isn't what's happening here. I also tried using a ▼ icon but that looked too much like it was a "sort descending" indicator.

[MoralCode]

could a "three dots" or another hamburger menu type icon work?