Would like a histogram option added to Stack Exchange Data Explorer

Question

Looking at the Help link on Stack Exchange Data explorer, I don't see any way to create a horizontally scrollable histogram. I want to develop queries that could let's say, show how many votes I got for answers for various tags at various points along a time scale for example, or even for specific questions, and the x vs. y curve graph doesn't accommodate that.

Answer 1

You can actually accomplish quite a lot with what's there. Not histograms, but you don't need them.

Here's the one query you asked about... as a line graph (run on my Stack Overflow ID):

Votes per tag over time

DECLARE @UserId int = ##UserId##

SELECT
    votes.creationdate
    ,tagname
    ,ROW_NUMBER() OVER (Partition BY tagname ORDER BY votes.creationdate)
    
FROM Tags
    INNER JOIN PostTags ON PostTags.TagId = Tags.id
    INNER JOIN Posts ON Posts.ParentId = PostTags.PostId
    INNER JOIN Votes ON Votes.PostId = Posts.Id and VoteTypeId = 2
WHERE 
    Posts.OwnerUserId = @UserId

---

Bar Graphs

I've got a self-answered question about making bar graphs in SEDE here (also linked in the comments). I updated it today, since I found a way to start each "bar" at 0:

The bars here are pretty arbitrary. It's possible, with enough coding ability, to make a similar graph with each bar being a month, or a tag, or whatever.