Warm tip: This article is reproduced from serverfault.com, please click

其他-如何使用Application Insights上的结果分组对Azure Kusto进行排序?

(其他 - How to make an Azure Kusto sorting with grouping of results on Application Insights?)

发布于 2020-11-27 14:41:41

我想要的是

按计数器排序结果,按国家/地区分组

样本输入

    let Source = datatable(Page:string, Region:string, Count:int)
[
    'page1', 'United States', 100,
    'page2', 'United States', 50,
    'page3', 'United States', 25,
    'page1', 'United Kingdom', 120,
    'page2', 'United Kingdom', 60,
    'page3', 'United Kingdom', 30,
    'page1', 'Russia', 60,
    'page2', 'Russia', 30,
    'page3', 'Russia', 15,
    'page1', 'Canada', 80,
    'page2', 'Canada', 40,
    'page3', 'Canada', 20
];
Source
| sort by Region, Count

我所看到的

page1 | United States  | 100
page2 | United States  | 50
page3 | United States  | 25
page1 | United Kingdom | 120
page2 | United Kingdom | 60
page3 | United Kingdom | 30
page1 | Russia         | 60
page2 | Russia         | 30
page3 | Russia         | 15
page1 | Canada         | 80
page2 | Canada         | 40
page3 | Canada         | 20    

我期望看到的

page1 | United Kingdom | 120
page2 | United Kingdom | 60
page3 | United Kingdom | 30
page1 | United States  | 100
page2 | United States  | 50
page3 | United States  | 25
page1 | Canada         | 80
page2 | Canada         | 40
page3 | Canada         | 20
page1 | Russia         | 60
page2 | Russia         | 30
page3 | Russia         | 15

我获得了按国家/地区分类的页面列表,并按访问次数排序,但是国家/地区本身是随机排列的,而不是按访问次数降序排列。如何解决?

Questioner
Re1ter
Viewed
11
ZakiMa 2020-12-01 02:19:40

这是一个示例,该示例如何计算总和,首先按国家/地区加入并首先按TotalCount进行排序:

let Source = datatable(Page:string, Region:string, Count:int)
[
    'page1', 'United States', 100,
    'page2', 'United States', 50,
    'page3', 'United States', 25,
    'page1', 'United Kingdom', 120,
    'page2', 'United Kingdom', 60,
    'page3', 'United Kingdom', 30,
    'page1', 'Russia', 60,
    'page2', 'Russia', 30,
    'page3', 'Russia', 15,
    'page1', 'Canada', 80,
    'page2', 'Canada', 40,
    'page3', 'Canada', 20
];
Source
| join kind=leftouter (Source | summarize TotalCount=sum(Count) by Region) on Region
| sort by TotalCount, Region, Count
| project Page, Region, Count

结果如下:

在此处输入图片说明