[Mondrian] RES: RES: Percentile() function

Kleyson Rios kleyson.rios at saude.go.gov.br
Wed Aug 7 08:52:19 EDT 2013


Hi Paul,

 

I am using mondrian-3.5.7.

 

Do you remember which version has the 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)

 

De: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] Em
nome de Paul Stoellberger
Enviada em: quarta-feira, 7 de agosto de 2013 07:20
Para: Mondrian developer mailing list
Assunto: Re: [Mondrian] RES: Percentile() function

 

What version of mondrian are you using?

There used to be a bug that would return negative values in some cases

 

 

On Aug 6, 2013, at 8:47 PM, Kleyson Rios wrote:





Now Trying:

 

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], 50)'

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

 

And Getting:

 

Semana               Median                Percentile50      ThirdQ
Percentile75

1                             8,210334              8,210334
16,119757           -70,457817

2                             16,494635           16,494635
22,855360           -747,925440

3                             19,793562           19,793562
33,987053           -129,299646

4                             23,139128           23,139128
40,587217           -1125,307673

5                             24,826356           24,826356
40,814809           -3227,370688

6                             29,239905           29,239905
44,532143           -1849,499531

 

 

Now Percentile50 is correct but Percentile75 not.

 

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)

 

De: Matt Campbell [mailto:mcampbell at pentaho.com] 
Enviada em: terça-feira, 6 de agosto de 2013 15:08
Para: Mondrian developer mailing list
Cc: Kleyson Rios
Assunto: Re: [Mondrian] Percentile() function

 

Try 50 and 75 for the 3rd parameter of Percentile, instead of .50 and .75.


On 08/06/2013 01:11 PM, Kleyson Rios wrote:

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)

 

 

_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org
http://lists.pentaho.org/mailman/listinfo/mondrian

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20130807/72f0cc43/attachment-0001.html 


More information about the Mondrian mailing list