# Inconsistent stats from the "User Participation Statistics" query

**URL:** <https://meta.discourse.org/t/inconsistent-stats-from-the-user-participation-statistics-query/245569>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [November 14, 2022, 9:01pm UTC](https://meta.discourse.org/t/inconsistent-stats-from-the-user-participation-statistics-query/245569 "2022-11-14T21:01:30Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![michellefs](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/michellefs/32/234543_2.png) [@michellefs](https://meta.discourse.org/u/michellefs)\
**Post date:** [November 15, 2022, 7:21pm UTC](https://meta.discourse.org/t/inconsistent-stats-from-the-user-participation-statistics-query/245569/6 "2022-11-15T19:21:20Z")

</div>

> [@JammyDodger](#):
>
> I think you can get 10,000 if you export the results as a CSV

We don’t even have that many members…yet, so all good there.

> [@JammyDodger](#):
>
> We can come up with a custom query though.

\*yay \*

> [@JammyDodger](#):
>
> What data are you looking for exactly?

One thing that would be helpful to clarify, is how each column is calculated. There are discrepancies between the CSV and what’s on a member’s Profile Summary page (note: we’re only comparing those two different sets of data where the query dates match the lifecycle of the member’s enrollment).

1. participation stats for all members with 1 or more visits, regardless of when during the query period they joined
2. stats are pulled at each month’s end to show the accumulative participation since the launch of our new community.

We thought, given the _:from\_days\_ago_ and _:duration\_days_ time frame of the query, that was what data it had been producing.

---

_[View the full topic](https://meta.discourse.org/t/inconsistent-stats-from-the-user-participation-statistics-query/245569)._