# Average Value Missing End of Data When Querying Historian Tag **URL:** \ **Category:** Ignition\ **Tags:** vision, ignition81\ **Created:** [July 22, 2022, 8:51am UTC](https://forum.inductiveautomation.com/t/average-value-missing-end-of-data-when-querying-historian-tag/62202 "2022-07-22T08:51:25Z")\ **Posts on this page:** 1\ **Showing post:** 6
**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Post date:** [July 22, 2022, 11:55am UTC](https://forum.inductiveautomation.com/t/average-value-missing-end-of-data-when-querying-historian-tag/62202/6 "2022-07-22T11:55:51Z")
> [@Calculating Total Time in Seconds](https://forum.inductiveautomation.com/t/calculating-total-time-in-seconds/49322): > > Hi, I’m working on a project and I’m trying to figure out how to calculate the total time that passes when a boolean tag is active & display that information in a report. For example, someone activates a toggle button (boolean value = 1) and 30 seconds later, they deactivate the toggle button (boolean value = 0). I want to record & store the time between activation (boolean value = 1) and deactivation (boolean value = 0) and then display that information on a report. For a better explanation, … --- _[View the full topic](https://forum.inductiveautomation.com/t/average-value-missing-end-of-data-when-querying-historian-tag/62202)._