Perform the following steps:
- Now, it's time to develop a query that provides us with the requests per hour derived metric value. Navigate to the Application Insights Overview blade and click on the Analytics button.
- You will be taken to the Analytics blade. Write the following query in the query tab. You can write your own query as per your requirements. Make sure that the query returns a scalar value:
requests | where timestamp > now(-1h) | summarize count()
- Once you are done with your query, run it by clicking on the Run button to see the count of records, as shown in the following screenshot:
- We are now ready with the required Application Insights query. Let's integrate the query ...