# Count handler in Reports

**URL:** <https://forum.inductiveautomation.com/t/count-handler-in-reports/87036>\
**Category:** Ignition\
**Tags:** vision\
**Created:** [March 8, 2024, 2:04pm UTC](https://forum.inductiveautomation.com/t/count-handler-in-reports/87036 "2024-03-08T14:04:43Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dwayne\_Schwartz](https://avatars.discourse-cdn.com/v4/letter/d/ec9cab/32.png) [@Dwayne\_Schwartz](https://forum.inductiveautomation.com/u/Dwayne_Schwartz)\
**Post date:** [March 8, 2024, 2:04pm UTC](https://forum.inductiveautomation.com/t/count-handler-in-reports/87036/1 "2024-03-08T14:04:43Z")

</div>

Hey everyone. I am trying to do a count on a report using the count handler for the summary. What do I need to do in order to count specific items? I have 1 and 0 as the data (Boolean). I just want to count all the 1s in a column. Thanks

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [March 8, 2024, 2:39pm UTC](https://forum.inductiveautomation.com/t/count-handler-in-reports/87036/2 "2024-03-08T14:39:01Z")

</div>

In reporting we use the ReportMill library, and their [documentation on keychains](https://www.reportmill.com/support/keychains.pdf) will help you here. Check out page 5 for how to use @count@

---

<div class="post-metadata">

**Author:** ![Dwayne\_Schwartz](https://avatars.discourse-cdn.com/v4/letter/d/ec9cab/32.png) [@Dwayne\_Schwartz](https://forum.inductiveautomation.com/u/Dwayne_Schwartz)\
**Post date:** [March 8, 2024, 2:58pm UTC](https://forum.inductiveautomation.com/t/count-handler-in-reports/87036/3 "2024-03-08T14:58:04Z")

</div>

Thanks!

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [March 8, 2024, 3:04pm UTC](https://forum.inductiveautomation.com/t/count-handler-in-reports/87036/4 "2024-03-08T15:04:10Z")

</div>

And duh, I should probably have finished my thought that the easiest way to do what you want will be @sum@ / @count@ -- conditional counting is funky in report mill.

Off to install more caffeine.

---

<div class="post-metadata">

**Author:** ![Dwayne\_Schwartz](https://avatars.discourse-cdn.com/v4/letter/d/ec9cab/32.png) [@Dwayne\_Schwartz](https://forum.inductiveautomation.com/u/Dwayne_Schwartz)\
**Post date:** [March 8, 2024, 3:12pm UTC](https://forum.inductiveautomation.com/t/count-handler-in-reports/87036/5 "2024-03-08T15:12:51Z")

</div>

Thanks, I figured to use the hour meter in transaction groups. How do I set the hour meter to reset every night at midnight? I have it counting every minute a status is 1. Just want to reset that counter at midnight each evening.