Need help in Usage Metrics for API

Summary:

I am trying to run usage metrics to get API counts but it is always giving me result as 0. Any idea why it is not giving me correct results?

I tried various date ranges and combinations but no success.

End Point:

https://****.bigmachines.com/rest/v17/companies/usage?q={$and:[{type:"api"},{timestamp:{$gt:"2024-10-01",$lt:"2024-10-31"}}]}

{

    "items": [

        {

            "total": 0,

            "exhausted": 0,

            "type": "api"

        }

    ]

}

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

24D Patch 4

Code Snippet (add any code snippets that support your topic, if applicable):