[Mondrian] Percentile() function

Kleyson Rios kleyson.rios at saude.go.gov.br
Tue Aug 6 13:08:44 EDT 2013


I am trying to use Percentile function in the following way:

 

member [Measures].[Median] as 'Median([Ano].[Ano].Members,
[Measures].[Incidencia])'

member [Measures].[ThirdQ] as 'ThirdQ([Ano].[Ano].Members,
[Measures].[Incidencia])'

member [Measures].[Percentile50] as 'Percentile([Ano].[Ano].Members,
[Measures].[Incidencia], 0.50)'

member [Measures].[Percentile75] as 'Percentile([Ano].[Ano].Members,
[Measures].[Incidencia], 0.75)'

 

select 

 

NON EMPTY {[Measures].[Median], [Measures].[Percentile50],
[Measures].[ThirdQ], [Measures].[Percentile75]} ON COLUMNS,

NON EMPTY {[Semana].[Semana].Members} ON ROWS

 

It was supposed Median == Percentile50 and ThirdQ == Percentile75, right ?

 

But I am getting different values, like:

 

Semana               Median                Percentile50      ThirdQ
Percentile75

1                             8,210334              0,151375
16,119757           0,227063

2                             16,494635           2,175962
22,855360           2,239248

3                             19,793562           2,447579
33,987053           2,553519

4                             23,139128           1,733540
40,587217           1,948231

5                             24,826356           1,895903
40,814809           2,191776

6                             29,239905           2,461290
44,532143           2,806971

 

 

Am I doing something wrong or it could be a bug ?

 

Regards.

 

-- 

Kleyson Rios

Gestor de TI

Coordenador de BI / Banco de Dados

Gerência de Tecnologia da Informação

Secretaria de Estado da Saúde de Goiás

(62) 3201-3707

 

Se não pode vencer pelo talento, vença pelo esforço. (Dave Weinbaum)

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20130806/7ba86104/attachment.html 


More information about the Mondrian mailing list