Hey there to everyone playing and exploring Data Explorer plugin!
Thanks for helping with all the previous questions @michebs . I’ve got one more regarding data explorer queries.
Has someone ever created a query that fetches % of active users by month?
Active means they either liked or replied in some threads in that month, it doesn’t matter how many times but it needs to be at least 1. % is calculated based on the number of all members of the community. So let’s say we have two people who engaged in a month. One liked some post and the other one replied - so it’s two and we divide that by the sum. of all the members we have in our community.