Useful Metric/Statics

[Johani (Joe)]

There are a couple of topics that relate to this:

1. Data explorer queries

What cool data explorer queries have you come up with?

Continuing the discussion from Data Explorer Plugin: For a searchable list of queries in this topic, see @SidV’s query list on GitHub. This topic has become too long to be easily searched. If you have questions about how to write a Data Explorer query, start a new topic in the support category and tag it with data-explorer. Here’s a couple I’m starting with: Users Last Seen Since (Since N Weeks Ago) with intervals as ( select n as start_time, CURRENT_TIMESTAM…

2. Badge queries

What cool badge queries have you come up with?

Enabling Badge SQL entails security and performance risks so it is not available by default. For more information, see: Enable Badge SQL There are lots of potential badges that we can come up with using SQL queries. I thought I’d start a topic for people to share some of the queries and badges they’ve created. I for one am looking forward to seeing some cool inspiration! This post is a wiki topic. If you have a good badge query to add, please reply to this …