在统计学中,众数(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求解
//jbean.org:
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]
//jbean.org:
End
|