# 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:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![maqsudbd](https://avatars.discourse-cdn.com/v4/letter/m/74df32/32.png) [@maqsudbd](https://forum.inductiveautomation.com/u/maqsudbd)\
**Post date:** [October 30, 2023, 4:48pm UTC](https://forum.inductiveautomation.com/t/day-wise-report-from-a-table-of-monthly-data/81179/1 "2023-10-30T16:48:03Z")

</div>

Hi

I have a query result which shows monthly data. Below is the table:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/7/c765b940e538606b62f889036f653e4b6be241a2.png)

How can I generate a report which created separate table for each day? I don't want to create report for each day separately rather one monthly report showing day wise data.

Thanks in advance.

---

<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.

---

<div class="post-metadata">

**Author:** ![maqsudbd](https://avatars.discourse-cdn.com/v4/letter/m/74df32/32.png) [@maqsudbd](https://forum.inductiveautomation.com/u/maqsudbd)\
**Post date:** [October 31, 2023, 2:44pm UTC](https://forum.inductiveautomation.com/t/day-wise-report-from-a-table-of-monthly-data/81179/3 "2023-10-31T14:44:54Z")

</div>

Hi Brian

Thanks for your suggestions.

Actually I wanted to show the timestamps as well. Not sure if that would be possible though.

Below is what I wanted:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/2/3226b719cb9c21732b0fe31b9dcccba7dfc740b1.png)

Any idea?

---

<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 31, 2023, 3:53pm UTC](https://forum.inductiveautomation.com/t/day-wise-report-from-a-table-of-monthly-data/81179/4 "2023-10-31T15:53:20Z")

</div>

Check out the grouping data inside tables doc here [Grouping Data Inside of Tables - Ignition User Manual 8.1 - Ignition Documentation](https://docs.inductiveautomation.com/display/DOC81/Grouping+Data+Inside+of+Tables) You'll likely need to adjust your data query to retrieve the date as a separate column so you can group data by that date.

---

<div class="post-metadata">

**Author:** ![maqsudbd](https://avatars.discourse-cdn.com/v4/letter/m/74df32/32.png) [@maqsudbd](https://forum.inductiveautomation.com/u/maqsudbd)\
**Post date:** [November 1, 2023, 4:20am UTC](https://forum.inductiveautomation.com/t/day-wise-report-from-a-table-of-monthly-data/81179/5 "2023-11-01T04:20:45Z")

</div>

Thanks a lot.