I found this site to be very helpful: https://github.com/cisco-en-programmability/dnacenter_reports_operations
Client Report Detail
"viewName": "Client Detail",
"description": "This client report view provides detailed information about the list of clients that are seen in the network",
There is no hourly option today. I thought maybe a workaround is to just continuously create new reports to run NOW, but that will quickly leave you with a long list of reports that DNA is tracking, so I think you should occasionally clean up (DELETE) the old ones via API.
However, depending on what information you are trying to fetch, you may not need DNA's reporting feature. You can collect lots of information, like client device details via API at whatever frequency you run your script to build your own report. (https://github.com/cisco-en-programmability/dnacenter_device_report has an example of that)
If you think an hourly report would be valuable, please submit a "Make a Wish" in your Cisco DNA GUI