# Creating new dataset for Ignition reporting from two SQL queries

**URL:** <https://forum.inductiveautomation.com/t/creating-new-dataset-for-ignition-reporting-from-two-sql-queries/80756>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [October 20, 2023, 11:14am UTC](https://forum.inductiveautomation.com/t/creating-new-dataset-for-ignition-reporting-from-two-sql-queries/80756 "2023-10-20T11:14:01Z")\
**Posts on this page:** 1\
**Showing post:** 10

<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:49pm UTC](https://forum.inductiveautomation.com/t/creating-new-dataset-for-ignition-reporting-from-two-sql-queries/80756/10 "2023-10-31T14:49:52Z")

</div>

Hi

I have a subsequent topic related to this topic.

> [@Day wise report from a table of monthly data](https://forum.inductiveautomation.com/t/day-wise-report-from-a-table-of-monthly-data/81179/2):
>
> 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.

Please have a look if possible.

Thanks.

---

_[View the full topic](https://forum.inductiveautomation.com/t/creating-new-dataset-for-ignition-reporting-from-two-sql-queries/80756)._