# Best method to display all values greater than x in a certain period? **URL:** \ **Category:** Ignition\ **Tags:** ignition80\ **Created:** [February 5, 2020, 10:50pm UTC](https://forum.inductiveautomation.com/t/best-method-to-display-all-values-greater-than-x-in-a-certain-period/31973 "2020-02-05T22:50:35Z")\ **Posts on this page:** 1\ **Showing post:** 5
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [February 6, 2020, 3:46pm UTC](https://forum.inductiveautomation.com/t/best-method-to-display-all-values-greater-than-x-in-a-certain-period/31973/5 "2020-02-06T15:46:10Z")
Consider using your tag historian query to collect all the raw data you need, then use a script data source to reprocess that data into the nested data keys you need. Your report's charts and tables (and/or nested tables) would use the reprocessed data. This post might help you: > [@Report with Scripted Nested Data](http://forum.inductiveautomation.com/t/report-with-scripted-nested-data/11801): > > The report datasource scripting examples explain how to access the nested data in another key for use constructing a custom dataset. What I don’t see is how to construct nested data that would be suitable for use with a child table in a table group. I have a parent dataset that I’m constructing via script due to annoying limitations of an ancient SQL Server 2000 instance. I need a subquery for each row that could be done with a normal query, but there’s no way to add a regular subquery to a s… --- _[View the full topic](https://forum.inductiveautomation.com/t/best-method-to-display-all-values-greater-than-x-in-a-certain-period/31973)._