-9

I wonder how I can view how many downvotes I received on my questions across the SE network.

2
6

I'm not really sure what you want to do with that information. Personally, I'm more interested in how many people I helped, so I'd rather look at the number of upvotes and accept votes. Fortunately, SQL supports pivoting, so we can have a look at everything at once. The number you're looking for is 2328 (well, it was last Sunday morning; the downvotes on this question (not mine) haven't been stored in SEDE yet).

enter image description here

6
  • Thanks, since total rep is given, that's pretty much equivalent. – Franck Dernoncourt Apr 1 at 7:55
  • Nice that dynamic pivot column handling. – rene Apr 1 at 7:57
  • Thanks @rene - I really think (T-)SQL should make this easier but as long as this works, I'm not complaining. – Glorfindel Apr 1 at 9:16
  • 2
    @FranckDernoncourt I now realize you asked for votes on questions, not all posts. If you're interested, you could fork the query and add AND p.PostTypeId = 1 after WHERE u.AccountId = ' + CAST(##AccountId:int## AS NVARCHAR) + '. – Glorfindel Apr 1 at 9:17
  • @Glorfindel noted, thanks! – Franck Dernoncourt Apr 1 at 9:17
  • @Glorfindel well, FWIW, Microsoft Access does have a Transform statement: docs.microsoft.com/en-us/office/client-developer/access/… that does allow NOT specifying the columns. – rene Apr 1 at 10:00

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .