# Calculate total participation moments by month using Data Explorer

**URL:** <https://meta.discourse.org/t/calculate-total-participation-moments-by-month-using-data-explorer/179885>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [February 16, 2021, 2:14pm UTC](https://meta.discourse.org/t/calculate-total-participation-moments-by-month-using-data-explorer/179885 "2021-02-16T14:14:38Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![Konrad\_Sopala](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/konrad_sopala/32/167014_2.png) [@Konrad\_Sopala](https://meta.discourse.org/u/Konrad_Sopala)\
**Post date:** [February 18, 2021, 12:05pm UTC](https://meta.discourse.org/t/calculate-total-participation-moments-by-month-using-data-explorer/179885/6 "2021-02-18T12:05:29Z")

</div>

Thanks @simon for sharing that that is really helpful and it’s mostly what I’m looking for! Can I ask you if it’s possible to make one change to the query? I don’t like to specify the start date. I would like to sum up all those values (posts, users, solutions, likes) and have the query result like that, by month:

 ![Screenshot 2021-02-18 at 13.05.09](https://global.discourse-cdn.com/meta/original/3X/0/7/07a3227e666cc5a7cd9f8c7130e240f5dd21d40b.png)

---

_[View the full topic](https://meta.discourse.org/t/calculate-total-participation-moments-by-month-using-data-explorer/179885)._
