How can I get count of queries per week of month in KQL

SHREY JAGAD 6

Q1. I am trying to extract the count of requests that happened in the week.

It is possible to use the calendar GUI but I need a query to make that possible.

Q2. Also if we provide a month to the query is there any way to get the total number of requests WEEK-wise?

QuantumCache 20,266 Reputation points

2022-02-23T18:28:34.453+00:00

Hello @SHREY JAGAD Thanks for reaching out on this forum.

Just a quick question on the Azure Service used here: Is this related to Azure Data Explorer Kusto Kusto Query Language Kusto query overview ?
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee

2022-03-02T06:29:01.82+00:00

Hello @SHREY JAGAD ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee

2022-03-09T19:46:01.77+00:00

Hello @SHREY JAGAD ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others .
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread .
Thanks
Himanshu
SHREY JAGAD 6 Reputation points

2022-03-10T05:44:49.853+00:00

Hey Himanshu, Yes this is based on KQL.

2 answers

Uri Barash 176 Reputation points Microsoft Employee

2022-02-28T23:42:37.233+00:00

Q1: You can either use Azure Monitor (https://learn.microsoft.com/en-us/azure/data-explorer/using-diagnostic-logs?tabs=ingestion#set-up-diagnostic-logs-for-an-azure-data-explorer-cluster) and the you can analyze the activity (https://learn.microsoft.com/en-us/azure/data-explorer/using-metrics)
You can also use the .show queries command (https://learn.microsoft.com/en-us/azure/data-explorer/kusto/management/queries) - .show queries | count

Q2: Try to summarize by startofweek(date)
Please sign in to rate this answer.

1 person found this answer helpful.
SHREY JAGAD 6 Reputation points

2022-03-10T05:53:22.767+00:00

Just another question comes up is that,

If I plot a column chart for the data and adding a query like:

| where Val3 == "false"
| as T
| summarize Count = count() by Val1, Val2
| extend Percentage = round(100.0 * Count / toscalar(T | count), 2)

My question is: Is there any query that can take each column value as 100% and then the results on the column can be averaged from that 100%?
Currently, it is taking the whole month as 100% and then giving the results.

You can see in the picture, in red is the current situation, in blue is required.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
SHREY JAGAD 6 Reputation points

2022-03-10T05:57:41.777+00:00

The Solution for me was to include a query line that contained
bin(timestamp ,7d)
selecting the whole month from the calendar given above.
Please sign in to rate this answer.

1 person found this answer helpful.
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee

2022-03-16T19:08:18.057+00:00

Hello @SHREY JAGAD ,
It was great to know that you were able to get to a resolution . We expect you to keep using this forum and also motivate others to do that same . You can always help other community members by answering to their queries ..
Thanks
Himanshu
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

How can I get count of queries per week of month in KQL

2 answers

Your answer