Members who have earned XP
Last updated
Last updated
To get the number of members who have earned XP, you can use the following query:
The number below with the arrow is the number of new members in the last 30 days. You can calculate it by getting the number of members up until last month and subtracting it from the all-time total calculated above.
In the queries above, we specify the XP events to include. This is to avoid double counting XP in courses since the dataset contains course_engagement
and exercise_completed
events with a non-zero xp_earned
value. Both contain XP gained from completing an exercise, so including both would lead to double counting XP earned in courses.
Please check the Domain Gotchas section for more details.