我想要的是
按计数器排序结果,按国家/地区分组
样本输入
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
我获得了按国家/地区分类的页面列表,并按访问次数排序,但是国家/地区本身是随机排列的,而不是按访问次数降序排列。如何解决?
这是一个示例,该示例如何计算总和,首先按国家/地区加入并首先按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
结果如下: