Data Explorer (SEDE)

« first day (1417 days earlier) ← previous day next day → last day (701 days later) »

10:07 AM

A: Is 7 Socratic badges the current per-site record?

The current record is 11 by @uhoh on Space Exploration, followed by 10 by @Charo on Italian Language. I have a SEDE query for network-wide badge statistics which I modified slightly to answer both @EvanCarroll's question in the comments (that's @FranckDernoncourt with 19 of them) and yours:

The answer links to this query: data.stackexchange.com/meta.stackexchange/query/1604707/…

Why the results are displayed differently than usually - in most queries I can sort by any column.

What I mean is that typically when I get results of a query, I can click on the description of the column (in this case, Rank, Total badges, Max. badges per site, Total sites) and get the results sorted by that column.

But this isn't the case here.

Here is a random query to explain what I mean - I can click on gold, silver, bronze, total to get the results sorted by that particular column.

Martin

10:21 AM

@Glorfindel Since I mentioned your query, I thought it would be polite to ping you. (But I guess you would notice at some point that there is something new in this room.)

Glorfindel

@Martin sure, no problem

Q: Why can't I sort SEDE results for some queries?

I was just checking out who earned the most of the new badges that were announced this week. I have a SEDE query for this which sorts by default on the number of sites you earned a badge. I noticed that when I run it for the harder badge, Lifeboat (awarded to 1089 users on the network), I can cli...

Martin

10:42 AM

Thanks for the response!

A: Add sortable columns to Data Explorer's query results

I added support for this for tables with <= 5000 results (as a quick n' dirty way to handle IE's less-than-optimal performance here), pending a pull and redeploy of Data Explorer. The sorting is very basic and single-column to start with, but if more advanced use cases come up it could be expand...