Count handler in Reports

Ignition
1

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

2

In reporting we use the ReportMill library, and their documentation on keychains will help you here. Check out page 5 for how to use @count@

1 Like
3

Thanks!

1 Like
4

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.

1 Like
5

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.