在统计学中，众数（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
|