# 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:** 3

<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, 6:01pm UTC](https://meta.discourse.org/t/inconsistent-stats-from-the-user-participation-statistics-query/245569/3 "2022-11-15T18:01:10Z")

</div>

Maybe you could clarify something for me.

I am trying to run a query starting 439 days ago (looking at the signup date of one specific user as a test) and choosing the duration date as the same number of days. I was under the impression this would include all their participation data since their signup. However, the data does not reflect that.

How would I achieve that?

---

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