I'm using a tag's historian as one of the data sources in a report. The tag is an expression that is intentionally null if certain conditions aren't met. The issue I'm having is that when I pull the tag's history into the report, it somehow assumes that I want the null values to be "0". I don't want the null values to be "0", I want the null values to be disregarded from the Basic Average aggregation that is being performed on this built in query.
Any suggestion on how to disregard null values from the tag history data source would be appreciated.
P.S. When I pull the tag into a power chart, it treats the null values at just that - null. There's no data for the time periods when the conditions aren't met for the tag to not be null.
Thanks in advance!