Dashboard Report - Reactions

[jericson (Jon Ericson)]

@Jagster

I have feeling this is counting wrong if default has changed from to for example.

@JammyDodger fixed a query I was using that accounts for this, I believe:

Which reactions are the most commonly-used in your community?

Let’s slide this over to community to get more eyes on it. Though the query isn’t counting Likes properly, or at least not all of ours (possibly because we’ve turned Reactions on mid-flow) reaction posts count 52295 144915 1167 1224 1101 1236 versus: reaction_value count 1371442 1236 1224

FWIW I've been using a small variation of this one to produce our table:

SELECT source.reaction_value, count FROM ( ( …