You have been asked by our customers to provide analytic reports for a derived metric within Application Insights. So, what is a derived metric? Well, by default, Application Insights provides you with many insights into metrics such as requests, errors, exceptions, and so on.
You can run queries on the information that Application Insights provides using its Analytics query language.
In this context, requests per hour is a derived metric, and if you would like to build a new report within Application Insights, then you will need to feed Application Insights about the new derived metric on a regular basis. Once you feed the required data regularly, Application Insights will take care of providing reports for your analysis.
We will be using Azure Functions that feed Application Insights with a derived metric named requests per hour:
For this example, we will develop a query using the Analytics query language for the request per hour derived metric. You can make changes to the query to generate other derived metrics for your requirements, say, requests per hour for my campaign or something similar to that.