Data Explorer - Query to determine user theme preferences

[Johani (Joe)]

I believe @osama has already created a query that allows you to check a theme’s popularity. Have a look here

Is there any way of telling how popular a Theme is?

You don’t really need to look at the users table here to display usernames. Data Explorer will automatically display avatars and username if the result of your query has a user_id column which the user_options table does have. Anyway, this topic got me personally interested so I spent a few minutes playing with data explorer and I got this little query which shows you user-selectable themes with the number of users using each theme: WITH theme_stats AS ( SELECT theme_ids[1]…