# Day wise report from a table of monthly data

**URL:** <https://forum.inductiveautomation.com/t/day-wise-report-from-a-table-of-monthly-data/81179>\
**Category:** Ignition\
**Created:** [October 30, 2023, 4:48pm UTC](https://forum.inductiveautomation.com/t/day-wise-report-from-a-table-of-monthly-data/81179 "2023-10-30T16:48:03Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![brian.mcenulty](https://avatars.discourse-cdn.com/v4/letter/b/b77776/32.png) [@brian.mcenulty](https://forum.inductiveautomation.com/u/brian.mcenulty)\
**Post date:** [October 30, 2023, 5:16pm UTC](https://forum.inductiveautomation.com/t/day-wise-report-from-a-table-of-monthly-data/81179/2 "2023-10-30T17:16:41Z")

</div>

If you're just looking for number of events and duration for each day, you can select the start timestamp as a DATE() and group the data by that date.

---

_[View the full topic](https://forum.inductiveautomation.com/t/day-wise-report-from-a-table-of-monthly-data/81179)._