I have a report that I am trying to display a history tag over a period of time. On the report I want to display the value, the min, the max and the average. When I run the reports the value shows correct but the min, max and average show “<N/A>”. I am trying to achieve this using a “Tag Historian Query”.
Can someone assist me with this issue.
You need to use a Calculated History Tag query and not a regular Historical Tag Query.
You can’t ask for help on the test - This will be a good way for you to not pass if they catch you.
That worked. But know in that type of data source I do not get the sample size option as I do on a Tag Historian Query. For example, I need to display the average, min and max of the last 24 hours every hour.
I already completed and submitted the test. This question is to help a coworker with an issue we are running in a real application for one of our costumers and I happened to do it on my test project.
Gotcha - If you want more help from others I would just not post it like that. A lot of people won’t even attempt to help since that looked like what you were doing.
Thanks for the tip. This is my second time using this forum.
To be fair, I saw a question a while back that looked like a certification question and I mentioned it on the post but came up red-faced as it turned out to be a legit question. It pays not to assume anything
How do I reference a min, max and average value from a tag calculation query? My report consists of a line graph from a tag historian query and under each graph I want to display the min, max and average from that time period. What I’ve found if using the calculations from the tag historian query that some of the values return either “N/A” or “NAN.” However when using a tag calculation query when I try and drag the value from the key browser is that nothing references the specific tag in question and it comes back with NAN or N/A in the preview.