I am somewhat familiar with NRQL and have created dashboard to count the total requests count of certain transactions in a month/year.
SELECT count(*)/1000 AS ‘Thousands Requests’ FROM Transaction WHERE appName IN (‘my-app-name’) and name like ‘%my-transaction-name%’ SINCE 1 month ago
Now i am trying to find out the max count of the same transaction per hour over a period of one week, one month or a year. Like was this call made 20 times in an hour or 200 times in an hour.
I am not looking for transaction duration.