# Report - Retreive Historical Tag Values Greater than X

**URL:** <https://forum.inductiveautomation.com/t/report-retreive-historical-tag-values-greater-than-x/16566>\
**Category:** Ignition\
**Created:** [January 11, 2018, 8:38pm UTC](https://forum.inductiveautomation.com/t/report-retreive-historical-tag-values-greater-than-x/16566 "2018-01-11T20:38:47Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![mlatour](https://avatars.discourse-cdn.com/v4/letter/m/e95f7d/32.png) [@mlatour](https://forum.inductiveautomation.com/u/mlatour)\
**Post date:** [January 11, 2018, 8:38pm UTC](https://forum.inductiveautomation.com/t/report-retreive-historical-tag-values-greater-than-x/16566/1 "2018-01-11T20:38:47Z")

</div>

I was looking to see if it’s possible to use the “Tag Historian Query” in the report builder for a tag, but only retrieve values for the tag that are greater than X. We’re trying to get the average flow rate over a shift, but only want to use flow rates greater than 1 i.e. only when something is running. In a SQL query this is easy, but I wasn’t sure if it’s possible to do it on historical tag values.