# Report Tag History Data Sub Query

**URL:** <https://forum.inductiveautomation.com/t/report-tag-history-data-sub-query/17759>\
**Category:** Ignition\
**Created:** [April 18, 2018, 4:39pm UTC](https://forum.inductiveautomation.com/t/report-tag-history-data-sub-query/17759 "2018-04-18T16:39:09Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hazmat480](https://avatars.discourse-cdn.com/v4/letter/h/97f17d/32.png) [@Hazmat480](https://forum.inductiveautomation.com/u/Hazmat480)\
**Post date:** [April 18, 2018, 4:39pm UTC](https://forum.inductiveautomation.com/t/report-tag-history-data-sub-query/17759/1 "2018-04-18T16:39:09Z")

</div>

Is there a way to take the tag history data for a start and end date binding, then query that to only show values between two numbers. I need to create a table that shows data over a 24 hour period, however this generates a lot of data and I only need to see critical data between two points. Don’t know if there is some way to use a where clause based on the data that is brought in for the 24 hrs. Example where data \< 180 and \> 160. Thank you for the help.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [April 18, 2018, 5:33pm UTC](https://forum.inductiveautomation.com/t/report-tag-history-data-sub-query/17759/2 "2018-04-18T17:33:44Z")

</div>

You can access the results of another data source in a [scripting data source](https://docs.inductiveautomation.com/display/DOC79/Scripting+Data+Source#ScriptingDataSource-DataSources) which would allow you to iterate over it with some Python code.

Another option would be to use a [filter key](https://docs.inductiveautomation.com/display/DOC79/Table+Rows#TableRows-Filtering) on the table.