MDX示例:求解众数(mode)

在统计学中,众数(Mode)是样本观测值在频数分布表中频数最多的那一组的组中值,主要应用于大面积普查研究之中,众数在一组数据中可能会有好几个。简单的说,众数就是一组数据中占比例最多的一个或几个数。MDX众数求解又是那位人力资源商业智能团队的开发人员咨询的。

 

求解众数(MODE).MDX
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
//MDX众数MODE求解
//letusbi.com: begin
With
     SET SampleSet AS
     {
         [ Date ].[Calendar].[ Month ].&[2013]&[1],
         [ Date ].[Calendar].[ Month ].&[2013]&[2],
         [ Date ].[Calendar].[ Month ].&[2013]&[3],
         [ Date ].[Calendar].[ Month ].&[2013]&[4],
         [ Date ].[Calendar].[ Month ].&[2013]&[5],
         [ Date ].[Calendar].[ Month ].&[2013]&[6],
         [ Date ].[Calendar].[ Month ].&[2013]&[7],
         [ Date ].[Calendar].[ Month ].&[2013]&[8],
         [ Date ].[Calendar].[ Month ].&[2013]&[9],
         [ Date ].[Calendar].[ Month ].&[2013]&[10],
         [ Date ].[Calendar].[ Month ].&[2013]&[11],
         [ Date ].[Calendar].[ Month ].&[2013]&[12]
     }
 
     MEMBER measures.CountSame AS
         count (
             filter(
                 union (
                     SampleSet,
                     {[ Date ].[Calendar].currentmember} as CurrentMonth
                 ),
                 (
                     [ Date ].[Calendar].currentmember, [Measures].[Customer Count ])
                     =(CurrentMonth.item(0).item(0), [Measures].[Customer Count ])
                 )
             )
         )
 
//众数MODE
     MEMBER measures.mode AS
         (
             topcount(
                 SampleSet,
                 1,
                 measures.CountSame
             ).item(0).item(0),
         [Measures].[Customer Count ]
         )
 
select
{
     [Measures].[Customer Count ],
     measures.CountSame,
     measures.MODE
} on 0
from
     [Adventure Works]
//letusbi.com: End

本文维护地址:MDX示例:求解众数(mode)

posted @ 2013-07-29 19:28  坚固66  阅读(691)  评论(0编辑  收藏  举报