1. What is the issue? Please be detailed.
I work with a lot of data and my task is to check if each actor was able to count 5 households during 1 hour.
How to proceed?
2. What steps can we take to reproduce this issue?
Help me to find the best way to resolve it quickly.
3. What have you tried to fix the issue?
I tried to calculate manually but it's just so difficult.
Assuming each household is separate submission, I would recommend using the OData feed of Central to access your data from a data visualization tool such as Tableau or Power BI. It should be possible to extract the hour of day for the end time of each submission, then plot the frequency of submission (on the y-axis) against the hour (on the x-axis). You can then use a slicer to filter for the day and the actor. Here's a thread from Power BI forum that asks a similar question.